Convex CommunityCCConvex Community
Powered by
oscklmO
Convex Community•3y ago•
3 replies
oscklm

Advice/feedback on big schema for our video table

Hello,

So after using convex for a while now, and our platform growing in size and complexity. I would love to ask for feedback & potential advice on how to improve our way of defining our schema. I'm mostly curious to learn whether we are doing anything that is specifically advised against, so that i can fix this while we are still in development.

Below i have attached a gist which is our videos table, and how its currently defined. This is by far the most complex piece of data in our platform at the moment, and i have tried to set it up after the best practices that i've gathered from all the great advice received from stack posts and the team in general, including my own experience from using convex for a little while now.

Anyway, feel free to leave any thoughts in this thread. I'd love to discuss this, so that i can improve and others can find this and also use it as example if they are too sitting with schema definitions that are getting big in size.

Link to gist:
https://gist.github.com/oscdot/b1ff1cae4d7442f2d11c78ac5bad7c8a
Convex Community banner
Convex CommunityJoin
Join the Convex Discord! Explore Convex, the backend platform that keeps your app in sync.
15,010Members
Resources
Recent Announcements

Similar Threads

Was this page helpful?
Recent Announcements
james

Hi @everyone with everything going on today I forgot to post on discord about our EU launch! We have a region in Dublin now! You can start using it immediately, even for folks on the free plan. https://news.convex.dev/we-finally-got-our-eu-visa/ Stay tuned for more regions but also stay tuned for more infra improvements where we improve latency for teams no matter where their servers are located. Just at the tip of the iceberg re all the optimizations we have lined up.

james · this hour

Wayne

Hi @everyone happy Monday. Components Authoring [Challenge](https://www.convex.dev/components/challenge) updates! Meet the second batch of community-approved components **Firecrawl Scrape **- Scrape any URL and get clean markdown, HTML, screenshots, or structured JSON - with durable caching and reactive queries. https://www.convex.dev/components/firecrawl-scrape Built by: Gitmaxd **Durable Agents **- A Convex component for building durable AI agents with an async tool loop. https://www.convex.dev/components/durable-agents Built by: Siegfried **Convex Debouncer** - A server-side debouncing component for debouncing expensive operations like LLM calls, metrics computation, or any heavy processing that should only run after a period of inactivity. https://www.convex.dev/components/debouncer Built by: Ilya **DatabaseChat **- A Convex component for adding natural language database queries to your app. https://www.convex.dev/components/database-chat Built by: Nick **Transloadit** - A Convex component for creating Transloadit Assemblies, handling resumable uploads with status, and persisting status/results in Convex. https://www.convex.dev/components/transloadit Built by: Kvz **Loops** - A Convex component for integrating with Loops.so email marketing platform. https://www.convex.dev/components/loops Built by: Bobby The [challenge](https://www.convex.dev/components/challenge) is now ongoing, so keep building, and we'll keep rewarding. Thanks, everyone!

Wayne · 2w ago

Liz C

Hi everyone! Have you ever wanted to get your hands on some convex swag? Well you're in luck! We just launched our Convex swag store. Check it out here ---> https://store.convex.dev/

Liz C · 3w ago

Similar Threads

Advice on my schema size, nesting.
oscklmOoscklm / support-community
3y ago
Schema and functions advice
✪ Flamakæ✪✪ Flamakæ / support-community
12mo ago
Convex schema/functions design advice for dashboard app
NamioNNamio / support-community
6mo ago
Bandwidth - change table schema
ZoreslavZZoreslav / support-community
2y ago