What's Changed in 0.7.0!
Hello, SQL!
Version 0.7.0 includes a big new feature: marimo now ships with reactive SQL cells! Use SQL to query Pandas/Polars dataframes, Google Sheets, database tables, and more, and get the query result back as a DataFrame.
reactive-sql.mp4
Details
- You can create a SQL cell by right-clicking a create cell button and choosing "SQL cell", by converting an empty cell to SQL via the cell context menu, or via the SQL button that appears when you mouse hover at the bottom of your notebook.
- Under the hood, marimo translates your SQL statements to Python and passes it to an OLAP DBMS. Our current implementation is powered by duckdb 🦆.
- Stay tuned for more documentation and tutorials on how to use this powerful new feature.
- To use this feature, you'll need to first install duckdb (
pip install duckdb).
All changes
- feat: sql support by @mscolnick in #1709
- chore: upgrade ruff, fix lint errors by @mscolnick in #1721
- improvement: sort tables in dataframe by cell order by @mscolnick in #1723
- improvement: right-click add button to add Markdown or SQL by @mscolnick in #1722
- add python cell to create cell context menu by @akshayka in #1725
- docs: fix typos and a broken link in PR template by @Oreoxmt in #1726
- fix: update @valtown/codemirror-codeium to version 1.0.2 to fix usage in http by @mscolnick in #1729
- no f-strings in md viewer by @akshayka in #1728
- 0.7.0 by @akshayka in #1730
New Contributors
Full Changelog: 0.6.26...0.7.0