PixeltablePixeltable Logo
Example apps

Habit Tracker

Habit tracker API with streak labels as computed columns, deployable to Pixeltable Cloud

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-24.

app.py
"""Habit Tracker API built with Pixeltable.


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


from udfs import habit_blurb, streak_label


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




class Habits(TableModel, name='habits'):
    id = pxt.Column(value=pxtf.uuid.uuid7(), primary_key=True)
    name: pxt.String
    category: pxt.String
    streak_days: pxt.Int | None
    notes: pxt.String | None


    label = streak_label(streak_days)
    name_upper = pxtf.string.upper(name)
    name_blurb = habit_blurb(name, category)




# ---- queries ----
@pxt.query
def by_category(category: str):
    """Habits in a category, longest streak first."""
    return Habits.where(Habits.category == category).select(
        Habits.id, Habits.name, Habits.streak_days, Habits.label
    ).order_by(Habits.streak_days, asc=False)




# ---- routes ----
habits_api = FastAPIRouter(name='habits_api')
habits_api.add_insert_route(
    Habits, path='/habits',
    inputs=[Habits.name, Habits.category, Habits.streak_days, Habits.notes],
    outputs=[Habits.id, Habits.label, Habits.name_upper, Habits.name_blurb],
)
habits_api.add_update_route(Habits, path='/habits/update', inputs=[Habits.streak_days],
                            outputs=[Habits.id, Habits.streak_days, Habits.label])
habits_api.add_compute_route(Habits, path='/streak-label', inputs=[Habits.streak_days], outputs=[Habits.label])
habits_api.add_query_route(path='/habits/by-category', query=by_category, method='get')

What app.py declares

Each row links to its line.

  • runs on insert
  • stored
  • index
  • route
habitsL16
  1. idnamecategorystreak_daysnotes
  2. label = streak_label(streak_days)L23
  3. name_upper = pxtf.string.upper(name)L24
  4. name_blurb = habit_blurb(name, category)L25

serves habits_api

  1. POST/habitstakes name, category, streak_days, notes; returns id, label, name_upper, name_blurbL39
  2. POST/habits/updatetakes streak_days; returns id, streak_days, labelL44
  3. POST/streak-labeltakes streak_days; returns labelL46
  4. GET/habits/by-categorytakes categoryL47

Run it

Needs uv. The routes then answer on port 8000.

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

Related apps

All 29 example apps