Example apps built with Pixeltable 29 apps, each one app.py: the tables it declares, the columns that run on insert, and the routes that serve them, drawn from the file itself. Grouped with notebooks and how-tos by task on /examples .
All29 LLM calls3 Embedding indexes4 Views and iterators4 File uploads4 Images, video and audio6 B-tree indexes14
runs on insert stored index route29 apps shown
A knowledge base, conversation memory and an /ask route over Claude, with sentence embeddings for retrieval.
sentences view, string_splitter embedding index on text memory_context = recall_memory(prompt) knowledge_context = search_knowledge(prompt) context = assemble_context(prompt, memory_context, knowledge_context) +2 more computed +2 more tables: knowledge, conversations
serves
POST /api/knowledge POST /api/conversations +6 more routes 3 tables · 1 view · 5 computed · 8 routes Video frames extracted at one per second and indexed with CLIP, searchable by text or by image.
frames view, frame_iterator thumbnail = pxt_image.b64_encode(pxt_image.thumbnail(frame, size=(320, 320))) embedding index on frame thumbnail = pxt_image.b64_encode(pxt_image.thumbnail(image, size=(128, 128))) width = image.width height = image.height +1 more computed +1 more table: videos
serves
POST /api/ingest POST /api/ingest/image +4 more routes 2 tables · 1 view · 5 computed · 6 routes Durable, searchable long-term memory for an AI research assistant: per-user semantic recall, retrieval_udf lookups, tool calling and memory consolidation with custom aggregates
embedding index on content +1 more index recalled = recall_memories(user_id, message, 4) memory_text = memory_block(recalled) response = openai.chat_completions(agent_messages(user_id, message, memory_text), model=CHAT_MODEL... +4 more computed +1 more table: sources
3 tables · 8 computed · Python only Migrate archery-range scoring sessions from legacy JSON into Pixeltable, score with date-aware computed columns, and run as an incremental scheduled pipeline
session_year = pxtd.year(session_date) session_month = pxtd.month(session_date) session_day = pxtd.day(session_date) +10 more computed B-tree index on archer +4 more indexes 1 table · 13 computed · Python only RAG + tool-calling beekeeping advisor: custom embedding index, table-as-UDF agent pipeline, expr_udf mite math
regional_question = with_region(question) hits = search_guides(question, 3) context = format_context(hits) +1 more computed hits = search_guides(question, 3) context = format_context(hits) response = openai.chat_completions(advisor_messages(question, context), model='gpt-4o-mini', model... +3 more computed +3 more tables: guides, guide_chunks, inspections
4 tables · 1 view · 13 computed · Python only Batch ETL for orchard harvest crates: CSV import/export, packing math, and moisture on_error handling
volume_cm3 = length_cm * width_cm * height_cm abs_weight = pxtm.abs(weight_kg) weight_ceil = pxtm.ceil(weight_kg) +10 more computed B-tree index on orchard +2 more indexes 1 table · 13 computed · Python only Harbor radio signal media pipeline: audio normalize/fade, vision box overlays, and StringSplitter sentence views
meta = pxtf.audio.get_metadata(clip) normalized = pxtf.audio.normalize(clip) faded_in = pxtf.audio.fade_in(normalized, duration=0.25) +8 more computed B-tree index on harbor +2 more indexes sentences view, string_splitter length = pxtf.string.len(text) upper = pxtf.string.upper(text) 1 table · 1 view · 13 computed · Python only Forge heat-cycle registry API: B-tree indexes, chained risk UDFs, and parallel shop-floor writers
band = heat_band(peak_c) risk = risk_score(peak_c, hold_min, quench) tag = heat_tag(band, risk, alloy) +1 more computed B-tree index on forge_id +3 more indexes serves
POST /heats POST /heats/status +6 more routes 1 table · 4 computed · 8 routes Climbing-route topo registry API: photo uploads with thumbnails, grayscale copies, grade bands and index-backed crag lookups
thumb = topo.resize((96, 128)) gray = topo.convert('L') aspect = aspect_band(topo) +3 more computed B-tree index on crag +3 more indexes serves
POST /routes POST /analyze +5 more routes 1 table · 6 computed · 7 routes Warehouse pick-list REST API: units, pick zones, waves and tote labels as incremental computed columns over Json order lines
units = total_units(lines) zone_list = zones(lines) est_minutes = pick_minutes(units, zone_list, rush) +2 more computed B-tree index on status +2 more indexes serves
POST /orders POST /orders/update +4 more routes 1 table · 5 computed · 6 routes Ferry booking REST API: fares and deck classes as incremental computed columns, served with FastAPI
fare = fare_cents(party_size, vehicle_len_m, extras) deck_class = deck(vehicle_len_m) extras_order = extras_keys(extras) B-tree index on sailing_id +1 more index serves
POST /bookings POST /bookings/update +7 more routes 2 tables · 3 computed · 9 routes Pharmacy refill queue API with HMAC-signed receipts keyed by a runtime secret and B-tree indexed lookups
state = refill_state(refills_left) B-tree index on patient_ref +1 more index label = status_label(status, channel) receipt_sig = receipt_signature(rx_number, requested_at, status) B-tree index on rx_number +1 more index serves
POST /prescriptions POST /refills +4 more routes 2 tables · 3 computed · 6 routes Public-art mural registry API: wall photo uploads with thumbnails, grayscale copies and color tags
thumb = wall_photo.resize((96, 64)) gray = wall_photo.convert('L') aspect = aspect_band(wall_photo) +2 more computed B-tree index on neighborhood serves
POST /murals POST /analyze +3 more routes 1 table · 5 computed · 5 routes Greenhouse operations API: bays, climate readings and plantings, sized for Pixeltable Cloud in pixeltable.toml
label = bay_label(zone, bay_id, crop) B-tree index on zone +2 more indexes band = climate_band(temp_c, humidity_pct) vpd = vpd_kpa(temp_c, humidity_pct) B-tree index on bay_id +1 more table: plantings
serves
POST /bays POST /bays/status +5 more routes 3 tables · 3 computed · 7 routes Vineyard estate API: blocks, vines, harvests and tastings as four related Pixeltable tables with yield UDFs
age = vine_age(planted_year) tpa = yield_per_acre(tons, acres) band = yield_band(tons, acres) ripe = ripeness(brix) +2 more tables: blocks, tastings
serves
POST /blocks POST /vines +6 more routes 4 tables · 5 computed · 8 routes Backcountry trail permit API with check-ins, permit bands and a full Pixeltable Cloud lifecycle
region_upper = pxtf.string.upper(region) name_lower = pxtf.string.lower(name) band = permit_band(days, party_size) trail_upper = pxtf.string.upper(trail_code) +1 more table: checkins
serves
POST /trails POST /permits +4 more routes 3 tables · 6 computed · 6 routes Marina berth booking API: string primary keys, binary columns, berth fees and stay bands as computed columns
label = slip_label(dock, slip_id, length_m) fee = berth_fee(loa_m, nights) band = stay_band(nights) +1 more table: vessels
serves
POST /slips POST /vessels +7 more routes 3 tables · 4 computed · 9 routes Museum object loan tracker API with overdue flags and urgency bands, explorable from the pxt CLI and dashboard
accession_upper = pxtf.string.upper(accession) title_lower = pxtf.string.lower(title) label = loan_label(accession, borrower, venue) overdue = is_overdue(status, days_out) urgency_band = urgency(status, days_out) serves
POST /objects POST /loans +3 more routes 2 tables · 5 computed · 5 routes Invoice line-item audit API: a chain of computed columns from subtotal to tax, total and risk band
code_upper = pxtf.string.upper(code) tier_upper = pxtf.string.upper(tier) ref = invoice_ref(vendor_code, sku) subtotal = line_subtotal(qty, unit_price) net = apply_discount(subtotal, discount_pct) +5 more computed serves
POST /lines POST /lines/adjust +3 more routes 2 tables · 10 computed · 5 routes Lab sample accession queue API: three related tables, parallel writers and racing claims
label = station_label(name, capacity) urgency = urgency_band(priority, delayed_min) B-tree index on station_id +1 more index +1 more table: samples
serves
POST /stations POST /samples +5 more routes 3 tables · 3 computed · 7 routes Fleet telemetry API with B-tree indexed lookups and a chained severity/alert UDF pipeline
severity = severity_score(speed_kph, engine_temp_c, fuel_pct) alert = alert_label(severity) tag = vehicle_tag(fleet, vehicle_id) B-tree index on vehicle_id +3 more indexes serves
POST /readings POST /readings/correct +5 more routes 1 table · 3 computed · 7 routes Webhook registry API that HMAC-signs payloads with a secret from the environment, as computed columns
host = target_host(url) digest = digest_payload(payload) signature = sign_payload(event, payload) serves
POST /webhooks POST /sign +2 more routes 1 table · 3 computed · 4 routes Travel photo scrapbook API: image uploads, thumbnails and place tags as computed columns
thumb = photo.resize((64, 48)) place = trip_tag(city, country) shape = orientation(photo) +1 more computed serves
POST /photos POST /photos/caption +2 more routes 1 table · 4 computed · 4 routes Houseplant care API that turns soil moisture and watering history into care advice via computed columns
water_label = water_advice(moisture, days_since_water) species_upper = pxtf.string.upper(species) notes_blurb = care_blurb(species, location) serves
POST /plants POST /plants/update +2 more routes 1 table · 3 computed · 4 routes Coffee tasting journal API: roast labels and tasting summaries as computed columns
roast = roast_label(roast_level) bean_upper = pxtf.string.upper(bean) notes_blurb = brew_blurb(notes) serves
POST /cups POST /cups/update +2 more routes 1 table · 3 computed · 4 routes Habit tracker API with streak labels as computed columns, deployable to Pixeltable Cloud
label = streak_label(streak_days) name_upper = pxtf.string.upper(name) name_blurb = habit_blurb(name, category) serves
POST /habits POST /habits/update +2 more routes 1 table · 3 computed · 4 routes Recipe box API with ingredient counts and quick-meal search as computed columns and queries
n_ingredients = ingredient_count(ingredients) title_upper = pxtf.string.upper(title) title_blurb = teaser(title, minutes) serves
POST /recipes POST /recipes/update +2 more routes 1 table · 3 computed · 4 routes Bookmark manager API that derives domains and tag counts as computed columns, served with FastAPI
domain = extract_domain(url) title_upper = pxtf.string.upper(title) n_tags = tag_count(tags) +1 more computed serves
POST /bookmarks POST /bookmarks/update +3 more routes 1 table · 4 computed · 5 routes Sticky-notes REST API where titles and previews are computed columns, served with FastAPI
title_upper = pxtf.string.upper(title) blurb = blurb(body) serves
POST /notes POST /notes/update +3 more routes 1 table · 2 computed · 5 routes