search

enso-org / enso

Hybrid visual and textual functional programming.
https://ensoanalytics.com
Apache License 2.0
7.36k stars 323 forks source link

Experiment: saving SQLite connection to a file #11297

Open radeusgd opened 2 weeks ago

radeusgd commented 2 weeks ago

Can we dump an open SQLite connection to a file? Figure it out and create a prototype.

For file-backed DBs we could always flush/close the connection and copy the underlying file. But it would be best to be able to do this without having to close the connection.

For in-memory DBs, having this ability could be useful. See if it's possible.

radeusgd commented 2 weeks ago

Can we use this https://www.sqlite.org/backup.html through the JDBC driver somehow?

SQLite Backup API