PureBasic Forums - English

Posted: **Tue May 03, 2011 10:47 pm**

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.

Posted: **Tue May 03, 2011 10:59 pm**

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

Posted: **Wed May 04, 2011 3:43 am**

Ah wonderful. Thanks!

Posted: **Wed May 04, 2011 10:04 am**

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!)

PureBasic Forums - English

sqlite in memory?

sqlite in memory?

Re: sqlite in memory?

Re: sqlite in memory?

Re: sqlite in memory?