npm

sqliteodbc

ODBC driver for SQLite databases

brewmacoslinux

Try with needOr install directly

Source

About

ODBC driver for SQLite

Commands

sqliteodbc

Examples

Configure SQLite ODBC data source in odbcinst.ini$ odbcinst -i -d -f /usr/local/etc/odbcinst.ini

Test ODBC connection to SQLite database$ isql -v SQLite /path/to/database.db

Query SQLite database via ODBC using Python

$ python3 -c "import pyodbc; conn = pyodbc.connect('Driver=SQLite3;Database=test.db'); cursor = conn.cursor(); cursor.execute('SELECT * FROM table'); print(cursor.fetchall())"