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
sql
--
powered by python
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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
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
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('
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
6 matches
Mail list logo