SQLite Forum

sqlar and the sqlite3 tcl interface
Login

sqlar and the sqlite3 tcl interface

(1) By anonymous on 2021-11-25 11:02:08 [source]

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 [link] [source]

You will need to load the sqlar.c extension 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_

(3) By anonymous on 2021-11-26 13:02:10 in reply to 2 [link] [source]

Thank you