« Handling tab in Listb… | Home | Features to be remove… »

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. The biggest plugin in space...
11 06 15 - 09:31