Loading SQLite extensions at sqlitestudio startup

Problems, tips, hints - all about usage.

Loading SQLite extensions at sqlitestudio startup

Postby mbezzi » Sun Jan 08, 2017 11:29 am

Hello,

is there a way to automatically execute SQLite commands when sqlitestudio starts?

I do have SQLite extensions which I need to load. Sqlite3 CLI has a rc file which contains commands to be automatically executed.

I wonder if something similar is available with sqlitestudio. I searched through documentation but couldn't find anything.

Running Linux (RHEL 7.3).

Thank you in advance,

mario
mbezzi
 
Posts: 3
Joined: Sun Jan 08, 2017 11:18 am

Re: Loading SQLite extensions at sqlitestudio startup

Postby Googie » Mon Jan 09, 2017 12:42 pm

Unfortunately no, sorry.
Googie
Site Admin
 
Posts: 718
Joined: Wed Jul 27, 2011 8:04 pm

Re: Loading SQLite extensions at sqlitestudio startup

Postby mbezzi » Tue Jan 10, 2017 11:24 am

Thank you for your kind reply.

From my early experiments it looks like extensions loaded while a given database connection is active are associated to that db and get lost as soon as the db is disconnected, which means manually reloading them for any new db connection. Is this the expected behavior? Any hope to have a way to automate this? By the way - sqlite studio is awesome, thanks!
mbezzi
 
Posts: 3
Joined: Sun Jan 08, 2017 11:18 am

Re: Loading SQLite extensions at sqlitestudio startup

Postby Googie » Thu Jan 12, 2017 12:39 pm

Loaded extensions are linked to connections (that's how SQLite works), so this is behaviour you will get by default.

SQLiteStudio 3.x.x has a very weak support for extensions currently, but I'm planing to improove it significantly. Possibly in 3.2.0 (which should be a next release).
Googie
Site Admin
 
Posts: 718
Joined: Wed Jul 27, 2011 8:04 pm

Re: Loading SQLite extensions at sqlitestudio startup

Postby mbezzi » Fri Jan 13, 2017 5:15 pm

Looking forward to it!

Thank you!

mario
mbezzi
 
Posts: 3
Joined: Sun Jan 08, 2017 11:18 am


Return to Usage

Who is online

Users browsing this forum: No registered users and 1 guest

cron