Say, you have already created a pysqlite database "testDB". In a Python
program, you connect to the database as:
> con = sqlite3.connect("testDB")
> cur = con.cursor()
To use a database in memory (ie. all the 'testDB' tables are held in memory)
the pysqlite documentation says the declaration is:
> con = sqlite3.connect(":memory:")
> cur = con.cursor()
But, this can't be right as you're not telling Python/pysqlite which database
to keep in memory. I've tried ...
> con = sqlite3.connect("testDB", ":memory:")
> cur = con.cursor()
.. but that didn't work. Any ideas?
Dinesh
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
