Skip to content

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.

608 B
Raw Blame
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()