Requirements

The execsql program uses third-party Python libraries to communicate with different database and spreadsheet software. These libraries must be installed to use those programs with execsql. Only those libraries that are needed, based on the command line arguments and metacommands that are used, must be installed. The libraries required for each database or spreadsheet application are:

• PostgreSQL: psycopg2.

• MariaDB or MySQL: pymysql.

• SQL Server: pyodbc.

• DuckDB: duckdb. Version 0.8.1 or later.

• MS-Access: pyodbc and pywin32.

• Firebird: fdb.

• Oracle: cx-Oracle.

• DSN data source: pyodbc.

• OpenDocument spreadsheets: odfpy.

• Excel spreadsheets (read only): xlrd for .xls files and openpyxl for .xlsx files.

Connections to SQLite databases are made using Python’s standard library, so no additional software is needed.

To use the Jinja or Airspeed template processors with the EXPORT metacommand, those Python packages must be installed also.

If data are to be imported from the Parquet file format, the pandas library and either the pyarrow or fastparquet Python packages must also be installed.

If data are to be exported to the feather file format, the pandas and pyarrow Python packages must also be installed.

If data are to be exported to the HDF5 file format, the tables library must be installed.

All of the additional Python packages that may be needed can be installed with pip.

To use MS-Access, SQL Server, or a DSN data source, an appropriate ODBC driver needs to be installed as well (e.g., the Database Engine 2010 Redistributable for MS-Access).