A reactive notebook for Python — run reproducible experiments, query with SQL, execute as a script, deploy as an app, and version with git. Stored as pure Python. All in a modern, AI-native editor.
Python artificial-intelligencedagdata-sciencedata-visualizationdataflowdeveloper-toolsmachine-learningnotebookspipelinepythonreactivesqlweb-app
import marimo
__generated_with = "0.0.0"
app = marimo.App(app_title="My Title")
@app.cell(hide_code=True)
def _(mo):
mo.md(r"""
# SQL notebook
""")
@app.cell
def _(fn_that_creates_engine):
mem_engine = fn_that_creates_engine("sqlite:///:memory:")
return (mem_engine,)
@app.cell
def _(mem_engine, mo, my_table):
export = mo.sql(
f"""
SELECT * FROM my_table;
""",
output=False,
engine=mem_engine
)
return (export,)
@app.cell
def _(export, mo):
_df = mo.sql("SELECT * FROM export;")
if __name__ == "__main__":
app.run()