Resource with own .db file (SQLite)

['LinKin]

Hello,

I've been told that using executeSQLQuery hangs the whole server while waiting for response and lacks support for callbacks.

I was told to use db* functions for better performance.

I assume I'd need to create a resource with its own database file, so that I can connect to it by using dbConnect

How to create this .db file (for SQLite) inside the script that I am doing?

Regards,

Linkin.

[TAPL]

dbConnect will create the database file if it not exist.

For SQLite it is a filepath to a SQLite database file. If the filepath starts with ":/" then the server's global databases directory is used. The file will be created if it does not exist.

['LinKin]

Ah, thank you!