Using #MarkdownSQLPro Tools 🛠️ with new #SQLBookmarks 🔖, #SQLite & our #DuckDBPro #SQLTools in #VSCode IDE on @ploomber's #JupySQL #JupyText / #MyST #JupyterBook 📓 markdown docs 😎

#SQL #DuckDB #Markdown #ProDataTools 🧙‍♂️ ...

Same #JupySQL Intro #JupyterBook 📓 markdown document in #VSCode IDE with the added top level Execute All, Select All, Extract All SQL code lenses, and Execute, Select, Copy and Create SQL code lenses in the code cells with %%sql #SQLMagics:

#MarkdownSQLProTools 🧙‍♂️ ...

Quick demo of the new Extract All SQL and Execute SQL code lenses in the upcoming #MarkdownSQL Pro Tools v1.2.0 with #JupyterBook markdown support and #JupySQL / #SQLMagics SQL code extraction and execution in action:

This example uses VS Code #SQLTools and #DuckDBPro Tools to execute SQL queries directly from the Jupy SQL Jupyter Book markdown document (https://github.com/ploomber/jupysql/blob/master/doc/quick-start.md).

#VSCode #ProDataTools 🧙‍♂️ ...

Check out this #MyST markdown #VSCode extension with syntax highlighting, hovers and autocomplete of directives, and extended .md preview rendering.

📥 https://marketplace.visualstudio.com/items?itemName=ExecutableBookProject.myst-highlight

Viewing #JupySQL intro markdown:

#MarkdownTools 🛠️ ...

Looking to up your data handling game with with Oracle?

Oracle is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.

Get started today!

https://tinyurl.com/oracle-jupysql

#DataScience #JupySQL #Oracle #Python #SQL

Our latest blog post explains how to integrate deepset's #Haystack, an open-source framework for building NLP systems, with #JupySQL and #JupyterNotebooks.

Discover how the JupySQL Agent leverages the power of GPT-4 to convert natural language queries into #SQL queries for seamless database access. The secret ingredient: the JupySQLQuery subclass, enabling SQL queries in Haystack pipelines within your Jupyter notebook environment.

Read more here: https://tinyurl.com/haystack-jupysql

#ML #AI #NLP

Noticias sobre Python y Datos de la semana, episodio 73 🐍⚙️

En resumen: Versiones nuevas de JupySQL, Modin, Prefect y más, machine learning "doble", detección de comunidades en grafos, ojo a la chi2 de scikit-learn, y noticias del viejo Spyder

https://astrojuanlu.substack.com/p/episodio-73

Apoya el noticiero suscribiéndote por correo 📬

#python #pydata #jupysql #ploomber #modin #prefect #doubleml #networkx #sklearn #spyder

What are the best open tools for more ergonomic interactive #SQL? Can I get syntax highlighting and tab-completion and auto-formatting of SQL cells and nice readable dataframe like output in a #Jupyter notebook?

#jupysql is the closest thing I've found so far:

https://jupysql.ploomber.io/en/latest/quick-start.html

RT @ploomber@twitter.com

Did you know? #JupySQL has a @duckdb@twitter.com integration!

Query your dataset from #CSV files to perform your analysis with #SQL commands in #Jupyter. Analyze and visualize data in charts, tables, and more!

Learn to use #DuckDB in your #notebooks:
https://buff.ly/3XgeRav

#DataScience