« Make a 32-bit FileMak… | Home | MBS FileMaker Plugin,… »

SQLite in memory databases


Sometimes you need more than an assoziative array in memory (Dictionary for Xojo and for FileMaker.).

Sometimes you may want to look at a SQLite database in memory. It has the big advantage that you can fill it with data and run SQL queries against it to find records of data.

To create a memory database with sqlite you specify a file path of ":memory:".

In FileMaker you call:

MBS("SQL.Connect"; $Connection; ":memory:"; ""; ""; "SQLite")

In Xojo or Real Studio you call with SQLDatabaseMBS class:

db.DatabaseName = "sqlite::memory:"

In Xojo or Real Studio you call with SQLConnectionMBS class:

con.Connect(":memory:", "", "", SQLConnectionMBS.kSQLiteClient)

All data is lost if not copied elsewhere when the application quits or you close the database.
11 06 15 - 09:31