[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] 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

[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)

[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