pypi.org : execsql
Runs a SQL script against a PostgreSQL, SQLite, MariaDB/MySQL, DuckDB, Firebird, MS-Access, MS-SQL-Server, or Oracle database, or an ODBC DSN. Provides metacommands to import and export data, copy data between databases, conditionally execute SQL and metacommands, and dynamically alter SQL and metacommands with substitution variables. Data can be exported in 18 different formats, including CSV, TSV, ODS, HTML, JSON, LaTeX, and Markdown tables, and using custom templates.
Registry
- Homepage
- Documentation
- JSON
- codemeta.json
purl: pkg:pypi/execsql
Keywords:
SQL
, Postgres
, PostgreSQL
, SQLite
, Firebird
, Access
, SQL Server
, MySQL
, MariaDb
, ODBC
, Oracle
, DuckDB
, database
, xlrd
, psycopg2
, pyodbc
, pymysql
, fdb
, cx_Oracle
, cx-Oracle
, odfpy
, ETL
, CSV
, TSV
, XML
, HTML
, JSON
, Feather
, LaTeX
, OpenDocument
, table
, DBMS
, Redshift
, CockroachDB
, query
, script
, import
, export
, Parquet
, template
, Jinja
, Airspeed
, zip
License: GPL-2.0+
Latest release: over 1 year ago
First release: over 8 years ago
Dependent repositories: 3
Downloads: 2,309 last month
Last synced: about 2 months ago