SQL in Jupyter Notebooks 🔥

Introducing Jupysql a python library that lets you run SQL commands right inside Jupyter Notebooks:

A Thread 🧵👇

Jupyter Notebooks already has Ipython magic commands to run SQL queries.

You can run any SQL query with %sql(line magic) and %%sql(cell magic) commands

"Jupysql" is an extension to this Ipython SQL package

Check out below example on how to install and use Jupysql:👇

Jupysql has other great features compared to IPython SQL like the one below to Plot large-scale datasets:

With the help of the "sqlplot" line command, you can plot large datasets inside the jupyter notebooks itself📊

Check out the below example on how to use sqlplot:👇

Jupysql also has other really great features compared to Ipython SQL. Checkout the blog and the GitHub repository:

Blog: ploomber.io/blog/jupysql/

GitHub Repository: github.com/ploomber/jupysql

That's a wrap!

If you are interested in:

- Python 🐍
- Data Science 📈
- Machine Learning 🤖
- Data Analysis 📊
- MLOps 🛠
- NLP 🗣
- Computer Vision 🎥

I'm sharing daily content over here, follow me → @Sumanth_077 if you haven't already ✅