jupyter sql
-
https://www.datacamp.com/tutorial/sql-interface-within-jupyterlab
!pip install ipython-sql
%load_ext sql
这种方式本质是从python执行sqljupyterlab-sql extension
这个插件时间比较久了 而且功能相对比较单一 -
https://pypi.org/project/jupyterlab-sql-editor/
A JupyterLab extension providing:SQL formatter
Automatic extraction of database schemas
Auto-completion triggered by tab or dot for:
table names
table aliases
table joins
nested column names
functions
Syntax highlighting for:
line magic
cell magic
Python strings
IPython magic for:Spark SQL
Trino -
https://github.com/jupyter-xeus/xeus-sql
另外一个扩展 和%%sql相比优势不明显 -
-
https://github.com/ploomber/jupysql
About
Better SQL in Jupyter
Run SQL in Jupyter/IPython via a %sql and %%sql magics.IPython-SQL's functionality and maintenance have been eclipsed by JupySQL, a fork maintained and developed by the Ploomber team. Future work will be directed into JupySQL - please file issues there, as well!
这个项目应该是最新的支持了
-