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 IPythonVariable 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.