[Potato Uno]

I plan on using a database for a plugin I am writing and I have a few questions about using sqlite:

1. Does SM support threaded queries for sqlite?

2. The main sqlite executable and python's sqlite library supports in-memory databases (that is, a database stored completely in RAM and not on a HDD). Is this supported in sourcemod? If so, how do I make one that lives in RAM? If not, is there any lag from reading a database file from the disk? (Maximum query size is about 600 entries.)

(Random note: SM 1.7 API is broken on mobile browsers.)

Thanks!

[psychonic]

Originally Posted by Potato Uno 1. Does SM support threaded queries for sqlite?

Yes.

Originally Posted by Potato Uno 2. The main sqlite executable and python's sqlite library supports in-memory databases (that is, a database stored completely in RAM and not on a HDD). Is this supported in sourcemod? If so, how do I make one that lives in RAM?

Maybe. Try putting ":memory:" as the "database" name in databases.cfg.

Originally Posted by Potato Uno If not, is there any lag from reading a database file from the disk? (Maximum query size is about 600 entries.)

With threaded queries, it shouldn't be a concern.

[Potato Uno]

Thanks! I'll try that out.

[Potato Uno]

Bumping this.

I tried this and it didn't work:

PHP Code:

    PlayerLoadouts = SQLite_UseDatabase(":memory:", Error, sizeof(Error)); 


Error:

PHP Code:

unable to open database file 


Is this a bug with the sourcemod version of sqlite? Even the official sqlite docs say to use ":memory:" for a transient database, so one would assume that it should work here.

I mean it's not a big deal; I can always write an .sq3 file in the server without any problems, but for something that I'd only need to use per game before it can be destroyed, memory would have been nice.

[Nerus]

Any news ?,

will be good to have temporary database.

My server works on SSD and for session I use sqlite to save temp data with big ratio changes for each client (scores).

So, will be improvement from sourcemod crew side, you will be able to add sqlite feature with memory (ram) support ?

Regards,
Nerus.

[psychonic]

I took a look and found the issue causing them to not work. The version of SQLite that SM uses supports them, but SM tried to do a bunch of handling on the database name given for SQLite.

Once this Pull Request is merged, it will work.
https://github.com/alliedmodders/sourcemod/pull/565

[Nerus]

Originally Posted by psychonic I took a look and found the issue causing them to not work. The version of SQLite that SM uses supports them, but SM tried to do a bunch of handling on the database name given for SQLite. Once this Pull Request is merged, it will work. https://github.com/alliedmodders/sourcemod/pull/565

Nice work, this option will suppress my ssd .

==================================

For version sm older than 1.9 based on Linux or Windows you can create ramdisk and use it to store sqlite database:

Linux Solution:

Create symlink for sqlite database with /dev/shm/file_name_to_store_in_ram

Windows Solution:

Create ramdisk (e.g. ImDisk), mount it as disk partition, link file to the ramdisk partition (Link Shell Extension)

Best regards,
Nerus.