There's an updated version of Datalore, the online data science notebook with smart coding assistance from JetBrains which adds support for database connections and SQL cells, along with the ability to turn Jupyter notebooks into interactive reports.

Datalore Enterprise was originally released in July 2021, see JetBrains Releases Onsite Datalore For Enterprise. It provides smart coding assistance for Python in online Jupyter notebooks, can be used to run code on CPUs and GPUs, and to collaborate in real-time. The developers say the changes tin the latest version are designed to make it easier for data scientists to share their work, and to provide a way to fetch data from databases with SQL.

Datalore Enterprise now supports user and password authentication for Amazon Redshift, Azure SQL Database, MariaDB, MySQL, Oracle, PostgreSQL, Snowflake, and other databases.

You can add SQL cells to get data from the database directly to your Python notebook. Code completion has also been added based on the database tables in use, alongside SQL syntax highlighting.

Jupyter notebooks can be made into interactive reports for end users, who will be able to change control parameters and reevaluate a notebook with a single button.

Support has been added for R and Scala, and there's an improved Reactive mode designed to ensure notebooks are tidy and up-to-date. With Reactive mode enabled, Datalore will enforce a top-down evaluation order and will automatically recalculate the cells below the modified one.

More Information

Datalore Website

Related Articles

JetBrains Releases Onsite Datalore For Enterprise

JupyterLab 3 Released

Kite Adds Jupyter Integration

.NET Jupyter Notebooks Announced

Jupyter Notebook 5 Adds Cell Tagging

Jupyter 4 Completed By Release Of IPython 4

PyCharm Now Supports Pipenv

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.