sqlar and the sqlite3 tcl interface
(1) By anonymous on 2021-11-25 11:02:08 [link]
I can't seem to find any information about using SQLite3 archives from the official Tcl SQLite3 interface documentation: https://sqlite.org/tclsqlite.html I would rather not exec to the sqlar CLI to create and manage these archives if possible.
(2) By Richard Hipp (drh) on 2021-11-26 12:39:14 in reply to 1
You will need to load the [sqlar.c extension][1] and then use it to access or create an SQLAR file. The only documentation is in comments in the source file, or some vague hints at <https://www.sqlite.org/cli.html#_sql_used_to_implement_sqlite_archive_operations_> [1]: src:/file/ext/misc/sqlar.c
(3) By anonymous on 2021-11-26 13:02:10 in reply to 2 [link]
Thank you