The SQLite back-end requires the SQLite shared library file. Its default file name is /usr/lib/libsqlite.so.
Use
(asdf:operate 'asdf:load-op 'clsql-sqlite)
to load the SQLite back-end. The database type for the SQLite back-end is :sqlite.
Passing filename a value of :memory: will create a database in physical memory instead of using a file on disk.
Some operations will be many times faster if database integrity checking is disabled by setting the SYNCHRONOUS flag to OFF (see the SQLITE manual for details).
The :owner keyword argument to the FDDL functions for listing and testing for database objects is ignored.
The :column-list keyword argument to create-view is not supported by SQLite.