SQLite

From GretlWiki
Jump to navigation Jump to search

SQLite is a lightweight, serverless database engine often used for small-scale applications and embedded systems.

Setup

GNU/Linux

To connect to the database Gretl uses the ODBC driver . The process for setting it up is described by Andrew B. Collier in an article on his blog. The article describes how to set it up on a computer running Ubuntu but it also works for other distributions.

Packages download

You need to download and install the unixODBC and SQLiteODBC packages depending on the distribution you use.

Setup files

If it is not already present you need to create an odbcinst.ini file in the /etc folder as shown below

; /etc/odbcinst.ini file content

[SQLite]
Description=SQLite ODBC Driver
Driver=libsqliteodbc.so
Setup=libsqliteodbc.so
UsageCount=1

[SQLite3]
Description=SQLite3 ODBC Driver
Driver=libsqlite3odbc.so
Setup=libsqlite3odbc.so
UsageCount=1

and an .odbc.ini file in the home directory that specifies the name and path to the database file.

; ~/.odbc.ini file content

[databaseFileName]
Description = Database description
Driver = SQLite3
Database = /path/to/database/file
Timeout = 2000

As a final step, you need to create an environment variable that points to the /etc folder. In the example, a global environment variable is created by adding a line to the /etc/environment file.

#
# Content of /etc/environment
#

ODBCSYSINI=/etc

Connecting via Gretl

Once everything is set up to create a connection via Gretl and be able to retrieve data, simply use the open command with the --odbc flag specifying the database name given in the .odbc.ini file.

open dsn=databaseFileName --odbc

At this point you can use the open and data commands as specified in the command reference.