SQLite version 2


The SQLite version 2 back-end requires the SQLite version 2 shared library file. Its default file name is /usr/lib/libsqlite.so.



(asdf:operate 'asdf:load-op 'clsql-sqlite)

to load the SQLite version 2 back-end. The database type for the SQLite version 2 back-end is :sqlite.

Connection Specification

Syntax of connection-spec


Description of connection-spec


String or pathname representing the filename of the SQLite version 2 database file.



  • 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 version 2.

Symbolic SQL Syntax

  • SQLite version 2 does not support the all, some, any and exists subquery operations.