sqlite in memory?

[jerico2day]

Is it possible to create and use an sqlite database in memory? I found this thread:

http://www.purebasic.fr/english/viewtopic.php?t=27149

But the code no longer works and I can't wrap my head around it.

[ts-soft]

use the native pb functions:

Code: Select all

UseSQLiteDatabase()

If OpenDatabase(0, ":memory:", "", "")
  If DatabaseUpdate(0, "CREATE TABLE info (test VARCHAR(255));")
    Debug "Table created"
  EndIf
EndIf

Here a more complete example

[jerico2day]

Ah wonderful. Thanks!

[kinglestat]

you can also set the temporary storage #PRAGMA to MEMORY and create your table in temp...eg CREATE TABLE temp.mytable.....

this way you can operate both ways I have a post to this effect somewhere on the forum dont ask me where I am hopeless in navigating the web (and this forum in particular!)