JupySQL vs ipython-sql#

JupySQL is an actively maintained fork of ipython-sql; it is a drop-in replacement for 99% cases with a lot of new features.

Incompatibilities#

If you’re migrating from ipython-sql to JupySQL, these are the differences (in most cases, no code changes are needed):

  • Since 0.6 JupySQL no longer supports old versions of IPython

  • Variable expansion is replaced from {variable}, ${variable} to {{variable}}

New features#

  • Plotting module that allows you to efficiently plot massive datasets without running out of memory.

  • JupySQL allows you to break queries into multiple cells with the help of CTEs. Click here to learn more.

  • Using %sqlcmd tables and %sqlcmd columns --table/-t user can quickly explore tables in the database and the columns each table has. Click here to learn more.

  • Polars Integration to convert query results to polars.DataFrame. %config SqlMagic.autopolars can be used to automatically return Polars DataFrames instead of regular result sets.

  • Integration tests with PostgreSQL, MariaDB, MySQL, SQLite and DuckDB.