PixeltablePixeltable Logo
Example apps

Coffee Journal

Coffee tasting journal API: roast labels and tasting summaries as computed columns

Open in CodespacesView on GitHub

One app.py with 1 table, 3 computed columns, 4 HTTP routes. Needs pixeltable[serve]>=0.7.14. Updated 2026-09-25.

app.py
"""Coffee Journal API built with Pixeltable.


    pxt schema update app.py coffee
    pxt service run app.py coffee
"""
import pixeltable as pxt
import pixeltable.functions as pxtf
from pixeltable.serving import FastAPIRouter


from udfs import brew_blurb, roast_label


# ---- tables ----
TableModel = pxt.model_base()




class Cups(TableModel, name='cups'):
    id = pxt.Column(value=pxtf.uuid.uuid7(), primary_key=True)
    bean: pxt.String
    origin: pxt.String
    roast_level: pxt.String | None
    rating: pxt.Int | None
    notes: pxt.String | None


    roast = roast_label(roast_level)
    bean_upper = pxtf.string.upper(bean)
    notes_blurb = brew_blurb(notes)




# ---- queries ----
@pxt.query
def top_cups(origin: str, min_rating: int):
    """Best cups from one origin."""
    return Cups.where((Cups.origin == origin) & (Cups.rating >= min_rating)).select(
        Cups.id, Cups.bean, Cups.roast, Cups.rating, Cups.notes_blurb
    ).order_by(Cups.rating, asc=False)




# ---- routes ----
cups_api = FastAPIRouter(name='cups_api')
cups_api.add_insert_route(
    Cups, path='/cups',
    inputs=[Cups.bean, Cups.origin, Cups.roast_level, Cups.rating, Cups.notes],
    outputs=[Cups.id, Cups.roast, Cups.bean_upper, Cups.notes_blurb],
)
cups_api.add_update_route(Cups, path='/cups/update', inputs=[Cups.roast_level, Cups.rating],
                          outputs=[Cups.id, Cups.roast, Cups.rating])
cups_api.add_compute_route(Cups, path='/roast-label', inputs=[Cups.roast_level], outputs=[Cups.roast])
cups_api.add_query_route(path='/cups/top', query=top_cups, method='get')

What app.py declares

Each row links to its line.

  • runs on insert
  • stored
  • index
  • route
cupsL16
  1. idbeanoriginroast_levelratingnotes
  2. roast = roast_label(roast_level)L24
  3. bean_upper = pxtf.string.upper(bean)L25
  4. notes_blurb = brew_blurb(notes)L26

serves cups_api

  1. POST/cupstakes bean, origin, roast_level, rating, notes; returns id, roast, bean_upper, notes_blurbL40
  2. POST/cups/updatetakes roast_level, rating; returns id, roast, ratingL45
  3. POST/roast-labeltakes roast_level; returns roastL47
  4. GET/cups/toptakes origin, min_ratingL48

Run it

Needs uv. The routes then answer on port 8000.

terminal
git clone https://github.com/pierrebrunelle/pixeltable-coffee-journal
cd pixeltable-coffee-journal
uv sync
uv run pxt schema update app.py coffee
uv run python seed.py coffee
uv run pxt service run app.py coffee --port 8000

Related apps

All 29 example apps