April 17, 2023, 7:20 p.m. | /u/idomic

Data Science www.reddit.com

Hey r/datascience!
I found [this ancient thread](https://www.reddit.com/r/datascience/comments/bx59cv/tool_for_integrating_sql_jupyter_seamlessly/) about Jupyter Notebooks and SQL queries.
I’m wondering if:

1. Are people here still running SQL from within the notebook?
2. What best practices/tips do you have?
3. What are the main use cases?

I usually use it to connect to multiple sources, store the queries within the notebook, and then put the notebooks into version control. I also found pandas way slower from running a duckdb + jupysql when possible.

best practices cases control datascience duckdb hey jupyter multiple notebook notebooks pandas people practices running sql tips use cases version control

AI Research Scientist

@ Vara | Berlin, Germany and Remote

Data Architect

@ University of Texas at Austin | Austin, TX

Data ETL Engineer

@ University of Texas at Austin | Austin, TX

Lead GNSS Data Scientist

@ Lurra Systems | Melbourne

Lead Data Scientist, Commercial Analytics

@ Checkout.com | London, United Kingdom

Data Engineer I

@ Love's Travel Stops | Oklahoma City, OK, US, 73120