Question about best practices for Piccolo tables to API schemas

I am exploring Piccolo and Piccolo API for building an async ASGI service.

I am curious about the recommended approach for connecting Piccolo tables to API schemas.
Specifically, I am interested in:

I haven’t implemented this yet, so I am looking for guidance on the recommended patterns or examples.

If maintainers think this is useful, I would be interested in contributing documentation, examples, or a focused PR once I’ve tried it in practice.

Thanks.

Assuming you're using Pydantic for serialisation, there's this for auto creating models:

You can also easily create endpoints based on tables using this:

They're good for getting you started. But after a while you'll probably have to write custom endpoints and models as your app grows in complexity.

Navigation Menu