[sqlite] Load a Sqlite Database on Disk as an In-memory Database
Hi guys, I want to write a program to load a sqlite database on disk as an in-memory database, for sake of reducing number of disk I/O operations. Do you know how to achieve it? Thank you in advance. Best regards, Alex ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] How to cancel subscription of this mail list?
-- powered by python ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] How to read next record of a table after a query 'select from where'
I am using pysqlite2 to access sqlite DB. from pysqlite2 import dbapi2 as sqlite conn = sqlite.connect("db1.db") cur = conn.cursor() cur.execute() cur.fetchone() # get one record cur.fetchone() # get next record conn.close() 2007/2/20, Adriano <[EMAIL PROTECTED]>: "SELECT * FROM mytable WHERE NameField = '"" & Name & Set r= db.execute(cmd) if i'd like to read next record in the same table how to do ? I use last version of sqlite avaible. Thanks Adriano - To unsubscribe, send email to [EMAIL PROTECTED] - -- powered by python
[sqlite] How fast is the sqlite connection created?
Hi, I want to know how many time is spent when create a sqlite connection. Is it effeciency? My application creates a connection and close it when access DB everytime, is it OK? -- powered by python
Re: [sqlite] Re: Leading zeros in strings
You should use TEXT rather than string as the type of STUFF. 2007/2/9, Igor Tandetnik <[EMAIL PROTECTED]>: Robert Simpson <[EMAIL PROTECTED]> wrote: > Issued from the 3.3.12 comand-line: > > CREATE TABLE blah (ID INTEGER PRIMARY KEY, STUFF string NOT NULL); > > INSERT INTO blah (STUFF) VALUES('00302'); > SELECT * FROM blah; > > 1|302 > > Same query, slightly different table definition: > > CREATE TABLE blah (ID INTEGER PRIMARY KEY, STUFF text NOT NULL); > > INSERT INTO blah (STUFF) VALUES('00302'); > SELECT * FROM blah; > > 1|00302 > > Should there be a difference between declaring a column as type > 'text' and type 'string' ? Read about SQLite type model here: http://www.sqlite.org/datatype3.html In particular the notion of column type affinity. Igor Tandetnik - To unsubscribe, send email to [EMAIL PROTECTED] - -- powered by python
[sqlite] How to keep syncronized between two DB on different severs?
Hi all, I encountered a problem. I have two servers (A and B) which host two same DBs, each of them may be modified. If the DB has been modified on server A, the DB on server B should also keep synchronized with server A. If the DB on server B has been modified, the DB on server A should also be modified automatically. How do I implement it? Is there any machanism in Sqlite to do it? Thank you. -- powered by python