I am using SQLite database for my Sublime Text plugin. Currently each command opens the database file to create a new connection. This is working fine but i wonder if it is a good solution.
Is there a better way to share a database connection with Sublime Text commands? In theory i’d only need to open a connection for
plugin_loaded() and its cursor for my commands. But of course i cannot pass the connection to my commands to commit a query.