Self-hosting

Hosted catalog: Cloud. This page is which local process to start after pxt schema update.

If you want	What you run	What starts
Python only	`pxt schema update`, insert from Python, then `export_sql`	Nothing listening
Your FastAPI	`pxt schema update`, then `app.include_router(...)`	Your process. HTTP serving
`pxt service`	`pxt schema update`, then `pxt service update`	A process Pixeltable starts. Quickstart

uvx pixeltable-new myapp copies the chat agent; pass agent as the last argument to pxt schema update. --video copies video search; pass videointel.

Python only

This example expects the starter-kit chat agent (Knowledge in that repo’s app.py). Insert rows, then export them to SQLite. Same snippet: chat-agent README.

pxt schema update app.py agent

from pixeltable.io.sql import export_sql

from app import Knowledge

Knowledge.insert(
    [{'body': 'One application file. Insert runs compute.', 'title': 'intro', 'source': 'docs'}]
)
export_sql(
    Knowledge.select(Knowledge.title, Knowledge.body, Knowledge.uuid),
    'knowledge',
    db_connect_str='sqlite:///agent.db',
    if_exists='replace',
)

For Docker and disks, see Infrastructure and Operations.

HTTP serving

Insert, compute, update, delete, query, uploads, background jobs.

Cloud

Use the same app.py with a hosted URL such as pxt://org:mydb.

Getting started

Tools

How to

Resources

Python only

Next

HTTP serving

Cloud

​Python only

​Next

HTTP serving

Cloud

Python only

Next