DeFeroci: fixed environment variable

2024-08-10T00:38:15Z

fixed environment variable

← Older revision		Revision as of 00:38, 10 August 2024
Line 38:		Line 38:
	</pre>		</pre>

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

DeFeroci: Page created

2024-08-10T00:36:01Z

Page created

New page

[https://www.sqlite.org/ 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 [https://en.wikipedia.org/wiki/Open_Database_Connectivity ODBC] driver . The process for setting it up is described by Andrew B. Collier in an [https://datawookie.dev/blog/2015/09/setting-up-odbc-for-sqlite-on-ubuntu/ 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 [https://www.unixodbc.org/odbcinst.html unixODBC] and [http://ch-werner.de/sqliteodbc/html/index.html 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 <code>/etc</code> folder as shown below

<pre>
; /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
</pre>

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

<pre>
; ~/.odbc.ini file content

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

As a final step, you need to create an environment variable that points to the .ini file.
In the example, a global environment variable is created by adding a line to the <code>/etc/environment</code> file.
<pre>
#
# Content of /etc/environment
#

ODBCSYSINI=/etc
</pre>

====Connecting via Gretl====
Once everything is set up to create a connection via Gretl and be able to retrieve data, simply use the <code>open</code> command with the <code>--odbc</code> flag specifying the database name given in the <code>.odbc.ini</code> file.
<pre>
open dsn=databaseFileName --odbc
</pre>

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

SQLite - Revision history

DeFeroci: fixed environment variable

DeFeroci: Page created