PureBasic Forums - English

jacdelad wrote: Mon Aug 12, 2024 5:24 pm This would a great addition to the help.

TI-994A wrote: Tue Aug 13, 2024 6:52 amOr at the very least a sticky, perhaps.

Kiffi wrote: Tue Aug 13, 2024 10:39 am

TI-994A wrote: Tue Aug 13, 2024 6:52 amOr at the very least a sticky, perhaps.

[X] Done

Fred wrote: Tue Aug 13, 2024 12:09 pmYour second topic at the top . Well deserved !

jacdelad wrote: Tue Aug 13, 2024 12:28 pmIt is well written and touches all the basics. ...

jacdelad wrote: Tue Aug 13, 2024 12:28 pm...how to use a database which is not written to a file, but into memory (for temporary usage).

OpenDatabase(#sqLite, ":memory:", "", "")

Fangbeast wrote: Thu Aug 15, 2024 1:32 pm Good stuff TI-994A, nicely done examples.

TI-994A wrote: Thu Aug 15, 2024 11:12 am

jacdelad wrote: Tue Aug 13, 2024 12:28 pm...how to use a database which is not written to a file, but into memory (for temporary usage).

Hi jacdelad. An in-memory database works exactly like a normal file-based one. The only difference is, like you said, it's temporary. All the processed data will be lost when the program terminates unless it's saved to file.

To use an in-memory database, simply replace the database file name with the :memory: directive - that's all! Everything else works exactly the same way.

Code: Select all

OpenDatabase(#sqLite, ":memory:", "", "")

Here's a simple, working example which I had posted a few years ago, demonstrating an in-memory database in action:

> In-Memory SQLite Example

I hope it's helpful.

jacdelad wrote: Thu Aug 15, 2024 3:09 pm... I just thought this would be a great addendum to your tutorial, like a last chapter with some tipps and tricks.