PyCafe - Solara - Solara & DuckDB Interactive App

app.py
requirements.txt
app.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
# check out https://solara.dev/ for documentation
# or https://github.com/widgetti/solara/
# And check out https://py.cafe/maartenbreddels for more examples
import solara
import duckdb
import pandas as pd

# reactive variables will trigger a component rerender
# when changed.
# When you change the default (now 0), hit the embedded browser
# refresh button to reset the state
clicks = solara.reactive(0)


con = duckdb.connect()
con.sql('SELECT 42').show()
con.sql('SELECT 42').fetchall()  # Python objects
con.sql('SELECT 42').df()  # Pandas DataFrame



@solara.component
def Page():
    print("The component render function gets called")
    # change this code, and see the output refresh
    color = "green"
    if clicks.value >= 5:
        color = "red"

    def increment():
        clicks.value += 1
        print("clicks", clicks)  # noqa

    solara.Button(label=f"Clicked: {clicks}", on_click=increment, color=color)

    solara.Text(f"Duckdb SQL output: {con.sql('SELECT 42').df()}")

# Solara also supports ipywidgets
# remove the Page component and assign an ipywidget to
# the page variable, e.g.
# page = mywidget
Py.Cafe

solara-duckdb

Solara & DuckDB Interactive App
