[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
