PixeltablePixeltable Logo
Example apps

Bookmark Shelf

Bookmark manager API that derives domains and tag counts as computed columns, served with FastAPI

Open in CodespacesView on GitHub

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

app.py
"""Bookmark Shelf API built with Pixeltable.


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


from udfs import extract_domain, tag_count, title_blurb


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




class Bookmarks(TableModel, name='bookmarks'):
    id = pxt.Column(value=pxtf.uuid.uuid7(), primary_key=True)
    url: pxt.String
    title: pxt.String
    tags: pxt.String | None
    notes: pxt.String | None


    domain = extract_domain(url)
    title_upper = pxtf.string.upper(title)
    n_tags = tag_count(tags)
    blurb = title_blurb(title)




# ---- queries ----
@pxt.query
def shelf(domain: str):
    """Everything saved from one domain."""
    return Bookmarks.where(Bookmarks.domain == domain).select(
        Bookmarks.id, Bookmarks.blurb, Bookmarks.url, Bookmarks.n_tags
    ).order_by(Bookmarks.title)




# ---- routes ----
bookmarks_api = FastAPIRouter(name='bookmarks_api')
bookmarks_api.add_insert_route(
    Bookmarks, path='/bookmarks',
    inputs=[Bookmarks.url, Bookmarks.title, Bookmarks.tags, Bookmarks.notes],
    outputs=[Bookmarks.id, Bookmarks.domain, Bookmarks.title_upper, Bookmarks.n_tags, Bookmarks.blurb],
)
bookmarks_api.add_update_route(
    Bookmarks, path='/bookmarks/update',
    inputs=[Bookmarks.title, Bookmarks.tags],
    outputs=[Bookmarks.id, Bookmarks.n_tags, Bookmarks.blurb],
)
bookmarks_api.add_delete_route(Bookmarks, path='/bookmarks/delete')
bookmarks_api.add_compute_route(Bookmarks, path='/domain', inputs=[Bookmarks.url], outputs=[Bookmarks.domain])
bookmarks_api.add_query_route(path='/shelf', query=shelf, method='get')

What app.py declares

Each row links to its line.

  • runs on insert
  • stored
  • index
  • route
bookmarksL16
  1. idurltitletagsnotes
  2. domain = extract_domain(url)L23
  3. title_upper = pxtf.string.upper(title)L24
  4. n_tags = tag_count(tags)L25
  5. blurb = title_blurb(title)L26

serves bookmarks_api

  1. POST/bookmarkstakes url, title, tags, notes; returns id, domain, title_upper, n_tags, blurbL40
  2. POST/bookmarks/updatetakes title, tags; returns id, n_tags, blurbL45
  3. POST/bookmarks/deleteL50
  4. POST/domaintakes url; returns domainL51
  5. GET/shelftakes domainL52

Run it

Needs uv. The routes then answer on port 8000.

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

Related apps

All 29 example apps