SQLite3 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 SQLite3 Embedded Database within GNUe, you must use one of the following python drivers:

pysqlite2

PySQLite2 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://initd.org

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=pysqlite2         # 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.
  2. Other than that, this driver is fully functional without any serious known problems.

sqlite3

Sqlite3 is a Python's builtin extension module for SQLite that conforms to the Python Database API Specification 2.0.

Home Page: http://python.org

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=sqlite3         # 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.
  2. Other than that, this driver is fully functional without any serious known problems.

GNUe Home

Developer Tools