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, must be installed. The libraries required for each database or spreadsheet application are:

• PostgreSQL: psycopg2.
• Firebird: fdb.
• MySQL or MariaDB: pymysql.
• SQL Server: pyodbc.
• MS-Access: pyodbc and pywin32.
• DSN data source: pyodbc.
• OpenDocument spreadsheets: odfpy.
• Excel spreadsheets (read only): xlrd.

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 software libraries must be installed also.