PureBasic SQLite Database: A Quick Tutorial

[TI-994A]

This would a great addition to the help.

Thanks for your kind endorsement, jacdelad.

Or at the very least a sticky, perhaps.

+1

[Kiffi]

Or at the very least a sticky, perhaps.

[X] Done

[TI-994A]

Or at the very least a sticky, perhaps.

[X] Done

Hi Kiffi. In all honesty, I was simply jesting.

Nevertheless, I'm glad it's helpful. Thank you, kindly.

[Fred]

Your second topic at the top . Well deserved !

[jacdelad]

It is well written and touches all the basics. The only thing that could be added, at least in my eyes, is how to use a database which is not written to a file, but into memory (for temporary usage).

[TI-994A]

Your second topic at the top . Well deserved !

It is well written and touches all the basics. ...

Very kind words, both of you. I'm truly obliged.

[TI-994A]

...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.

[Fangbeast]

Good stuff TI-994A, nicely done examples.

[TI-994A]

Good stuff TI-994A, nicely done examples.

Hi Miki. Trust you are well, dear friend.

I'm glad you think so; thank you. Just sharing all that I've learned here.

[jacdelad]

...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.

Hi TI-994A,
I already knew that. I just thought this would be a great addendum to your tutorial, like a last chapter with some tipps and tricks.

[TI-994A]

... I just thought this would be a great addendum to your tutorial, like a last chapter with some tipps and tricks.

That makes more sense. Great suggestion! Thank you, jacdelad.

Done!