PixeltablePixeltable Logo
Example apps

Sticky Notes

Sticky-notes REST API where titles and previews are computed columns, served with FastAPI

Open in CodespacesView on GitHub

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

app.py
"""Sticky Notes API built with Pixeltable.


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


from udfs import blurb


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




class Notes(TableModel, name='notes'):
    id = pxt.Column(value=pxtf.uuid.uuid7(), primary_key=True)
    title: pxt.String
    body: pxt.String
    tag: pxt.String | None


    title_upper = pxtf.string.upper(title)   # built-in string function
    blurb = blurb(body)                       # our UDF from udfs.py




# ---- queries ----
@pxt.query
def notes_by_tag(tag: str):
    """Notes with a given tag, newest first (UUIDv7 ids sort by creation time)."""
    return Notes.where(Notes.tag == tag).select(Notes.id, Notes.title, Notes.blurb).order_by(Notes.id, asc=False)




# ---- routes ----
notes_api = FastAPIRouter(name='notes_api')
notes_api.add_insert_route(Notes, path='/notes', inputs=[Notes.title, Notes.body, Notes.tag],
                           outputs=[Notes.id, Notes.title_upper, Notes.blurb])
notes_api.add_update_route(Notes, path='/notes/update', inputs=[Notes.title], outputs=[Notes.id, Notes.title_upper])
notes_api.add_delete_route(Notes, path='/notes/delete')
notes_api.add_compute_route(Notes, path='/titles', inputs=[Notes.title], outputs=[Notes.title_upper])
notes_api.add_query_route(path='/notes/by-tag', query=notes_by_tag, method='get')

What app.py declares

Each row links to its line.

  • runs on insert
  • stored
  • index
  • route
notesL16
  1. idtitlebodytag
  2. title_upper = pxtf.string.upper(title)L22
  3. blurb = blurb(body)L23

serves notes_api

  1. POST/notestakes title, body, tag; returns id, title_upper, blurbL35
  2. POST/notes/updatetakes title; returns id, title_upperL37
  3. POST/notes/deleteL38
  4. POST/titlestakes title; returns title_upperL39
  5. GET/notes/by-tagtakes tagL40

Run it

Needs uv. The routes then answer on port 8000.

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

Related apps

All 29 example apps