sqlite: foreign keys

[Thierry]

Le 28 sept. 2010 à 23:59, Monte Goulding a écrit :

>> Just use an in-memory db.
> 
> ooo, that's a new one to me. Is it possible to write it out to a file later?


Hi,

Running SQLite without a database file creates an in-memory database.
Using the .dump command will dump that in-memory DB to a SQL file that
can then be re-read into a file-backed database (or back into a memory
database)

But....
Sqlite  caches data in memory so a file based database and memory based perform 
much the same.

Well, depends of what you want to achieve...


HTH

Thierry