SQLite Embedded Database

SQLite is a C library that implements an embeddable SQL database engine. Programs that link with the SQLite library can have SQL database access without running a separate RDBMS process.

SQLite is a great database to use with GNUe for single-user installations where a self-contained, distributable package is desired.

To utilize SQLite Embedded Database within GNUe, you must use one of the following python drivers:

pysqlite

PySQLite is a Python extension for SQLite that conforms to the Python Database API Specification 2.0. The source is released under the Python license.

Home Page: http://pysqlite.sourceforge.net/

Supported Platforms:

Connection Properties

The following properties can be specified in your connections.conf file:

Examples

The following is an example of a connection.conf entry:

[myconn]
provider=sqlite2        # Use the SQLite adapter
dbname=/usr/db/testdb   # The filename for the SQLite database

Notes

  1. The database engine stores all data in string format. Many SQL statements won't work. Comparison of date types won't work correctly, etc.
  2. Other than that, this driver is fully functional without any serious known problems.

GNUe Home

Developer Tools