jupysql VS voila

Hey, HN community!

We're stoked to launch JupySQL today! JupySQL is an open-source library that brings a modern SQL experience to Jupyter. JupySQL is compatible with all major databases, such as Snowflake, Redshift, PostgreSQL, MySQL, MariaDB, DuckDB, SQL Server, Clickhouse, Trino, and more!

To get started, check out our tutorial: https://jupysql.ploomber.io/en/latest/quick-start.html

SQL is the defacto language for data analysis; however, analysis often requires a mix of SQL and Python. JupySQL bridges this gap, allowing users to execute SQL queries seamlessly in Jupyter and continue their analysis in Python. Add %%sql to the top of your cell and start writing SQL.

Here are some of JupySQL's main features:

- Syntax highlighting

Please show your support with a 🌟: https://github.com/ploomber/jupysql

If anyone is looking for something like this in Python/Jupyter, check out JupySQL: https://github.com/ploomber/jupysql

How are people managing the existence of data frame APIs like pandas/polars with SQL engines like BigQuery, Snowflake, and DuckDB?

Most of my notebooks are a mix of SQL and Python: SQL for most processing, dump the results as a pandas dataframe (via https://github.com/ploomber/jupysql) and then use Python for operations that are difficult to express with SQL (or that I don't know how to do it), so I end up with 80% SQL, 20% Python.

Unsure if this is the best workflow but it's the most efficient one I've come up with.

Disclaimer: my team develops JupySQL.

Quick link: https://github.com/voila-dashboards/voila

Humbly recommend when you share a product, you include a link to it ;)

https://voila.readthedocs.io/en/stable/

> Works with CI/CD out of the box. Deploy to vercel, netlify, your own infra.

Jupyter is suited for whatever you want to do with it. Voila exists to enable the use case of re-generating notebooks on a CI/CD system: https://github.com/voila-dashboards/voila

Anyways, seems like the templating is more powerful than the one being offered by Jupyter Notebooks.

Good luck and much success with it :)

i don't understand why everyone isn't just using voila. it's so much better than streamlit or gradio. but that's just my opinion i guess.

Ill have to check it out and see how it compares to voilà and holoviz panel. What I like about Holoviz panel is you can create a data web app from code that resides in a notebook or create a completely standalone app from just plain py scripts, and it supports many different visualization backends. I have found it to be the more flexible and generalizable data web app framework among the others I have come across (like Voilà, Dash, Plotly, and Streamlit).

Any insights what the differences between this and Voila are? https://github.com/voila-dashboards/voila

A nifty little alternative to voila, one might say.

Markdown and/or Voilà https://github.com/voila-dashboards/voila

If you are comfortable working in a Jupyter Notebook you can combine ipywidgets & Voila.