Libsqlite3
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine
Install / Use
/learn @LuaDist/Libsqlite3README
This package contains:
- the SQLite library amalgamation (single file) source code distribution,
- the shell.c file used to build the sqlite3 shell too, and
- the sqlite3.h and sqlite3ext.h header files required to link programs and sqlite extensions against the installed libary.
- autoconf/automake installation infrastucture.
The generic installation instructions for autoconf/automake are found in the INSTALL file.
The following SQLite specific boolean options are supported:
--enable-readline use readline in shell tool [default=yes] --enable-threadsafe build a thread-safe library [default=yes] --enable-dynamic-extensions support loadable extensions [default=yes]
The default value for the CFLAGS variable (options passed to the C compiler) includes debugging symbols in the build, resulting in larger binaries than are necessary. Override it on the configure command line like this:
$ CFLAGS="-Os" ./configure
to produce a smaller installation footprint.
Other SQLite compilation parameters can also be set using CFLAGS. For example:
$ CFLAGS="-Os -DSQLITE_OMIT_TRIGGERS" ./configure
Related Skills
feishu-drive
350.8k|
things-mac
350.8kManage Things 3 via the `things` CLI on macOS (add/update projects+todos via URL scheme; read/search/list from the local Things database)
clawhub
350.8kUse the ClawHub CLI to search, install, update, and publish agent skills from clawhub.com
postkit
PostgreSQL-native identity, configuration, metering, and job queues. SQL functions that work with any language or driver
