#JupySQL

🧵🧵My highlights of #PyConUS 2023: TL;DR: 🥑 DevRel @ploomber work, 🇲🇽 @pyconcharlas, 📚 awesome tutorials and 🤗 giving back to the community @pycon

@ploomber @pyconcharlas @pycon 🥑 as Ploomber developer advocate: - iPython SQL author @catherinedevlin and I gave a lighting talk on the transition from iPython SQL to JupySQL Slides:

- Catherine announced that #iPython #SQL graduated to legacy status. The successor fork #JupySQL is now open to absorb current and new issues. Thank you, Catherine!

🚀 NEW RELEASE! JupySQL 0.7.5 now allows the use of the native DuckDB .df() method when autopandas is in action. This integration ensures more efficient performance and seamless operation between DuckDB and pandas. Check it out! #JupySQL #DuckDB #Pandas #DataAnalysis

Learn to seamlessly run SQL queries in Jupyter notebooks for efficient data analysis with DuckDB. Check out our starter guide: @duckdb #JupySQL #DuckDB #Jupyter

🤖 Integrate MindsDB with Jupyter using JupySQL! Leverage the power of AI-driven data analysis in your notebook. Explore our guide: #JupySQL #MindsDB #Jupyter @mindshub

@ploomber @mindshub Dear @ploomber, JupySQL be the key, mixin' MindsDB with Jupyter, you see? AI-driven data analysis spree, check the guide, homie, and you'll agree! 🧠🔥 #JupySQL #MindsDB #Jupyter -- SnoopStein by @mindshub

We’re helping bring a modern #SQL experience to #Jupyter! 🔥 #JupySQL allows you to run SQL in Jupyter via magic commands. We’ve been working on query composition and plotting for large-scale datasets and built a guide for you. Check out our latest post!

Excited to share our new tutorial on product analytics using #SQL! Dive into crucial metrics like user growth and retention, explore practical examples, and learn about #JupySQL for seamless analytics tasks. ➡️ #DataAnalytics #ProductAnalytics #Ecommerce

Don't miss our collaboration: #JupySQL x #MindsDB! 🐻 @mindshub enables you to use your data and make forecasts. It speeds up the ML development process by bringing #MachineLearning into the database. Read the guide we prepared for you: 👉 #DataScience

Use #SQL keyword autocompletion in your #Jupyter notebooks with #JupySQL! 🎉 Simply press tab while typing to get suggestions! Give it a try and share your feedback with us on Slack! Install JupySQL now: #Autocompletion #SQL #NewFeature

🔁 Convert SQL queries to pandas DataFrames with JupySQL! Use the .DataFrame method to streamline data manipulation and analysis in our series on connecting Jupyter to SQL databases. Learn more: #JupySQL #pandas #Jupyter

📢 Exciting news! You can now query @ClickHouseDB with JupySQL, an open-source tool for Jupyter notebooks! Analyze and visualize your data like never before. 🚀 #ClickHouse #JupySQL #DataScience

🚀 Connect Clickhouse to Jupyter with JupySQL for faster data exploration and analysis! Learn how to query @ClickHouseDB databases directly from your notebook. Get started with our tutorial: #JupySQL #Clickhouse #Jupyter

Become a pro with #SQL. Use #JupySQL: 👉

Learn to streamline ETL processes and supercharge your data management - through Jupyter! - with this guide from Ido Michael on @kdnuggets! Automate it with #GitHub actions. Dive in!: 🔗 📊💡 Image #ETL #JupySQL #DataScience

🔄 Explore the .PolarsDataFrame method for converting SQL queries to polars DataFrames using JupySQL! Enhance data processing capabilities in our series on Jupyter & SQL database integration. Dive in: #JupySQL #polars #Jupyter @DataPolars

🎉#JupySQL v0.9.0 is out!🚀 Load config from pyproject.toml, resolve CTEs with new 'with_' feature & enjoy more control over scripts with parameterized queries. Plus, many more features & bug fixes! Learn more: 🌟 Show some love:

💡 Learn how to query Microsoft SQL Server from Jupyter with JupySQL! Improve your data analysis workflow with this powerful integration. Check out our tutorial: #JupySQL #MSSQL #Jupyter @SQLServer

🔗 Connect MySQL to Jupyter with JupySQL! Query MySQL databases directly from your notebook for seamless data access and analysis. Part of our series on Jupyter & SQL integrations. Get started: #JupySQL #MySQL #Jupyter @MySQL

A simple and easy integration between SQL, CSV files, and DuckDB! 🦆 #DataScience involves running #SQL queries and accessing connections to data from different sources. Write your own queries with #JupySQL in #Jupyter and query data from CSV files:

#JupySQL is a powerful tool to work with #SQL in #Jupyter, allowing you to run queries and plot large datasets EASILY. 🦾 Get started: #DataScience #Ploomber #OpenSource