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