Скачать или смотреть Why doesn't Convex have SELECT or COUNT?

Convex takes a different approach to database queries by skipping traditional SQL functions like SELECT and COUNT. This video breaks down why Convex omits these features, what that means for query performance, and how to structure your data and queries for predictable performance in production.

The walkthrough covers:
• How Convex handles queries and caching
• Why SELECT and COUNT aren’t part of its API
• Practical workarounds using mutations and aggregate components
• Performance testing with real schemas and logging via Axiom
• How Convex’s hybrid relational-document design impacts query design

Developers will learn how to model data explicitly for consistent performance and avoid hidden costs when building real-time apps with Convex.

Resources:
Theo's video:    • Why I moved away from SQL  
Aggregate Component: https://www.convex.dev/components/agg...
How Convex Works: https://stack.convex.dev/how-convex-w...
Postgres TOAST: https://www.postgresql.org/docs/curre...

Timestamps
00:00 Convex lacks SELECT and COUNT operations
01:45 Why Convex queries are cached and how to test
03:37 Measuring query performance and using Axiom logs
06:13 How Convex handles data reads without SELECT
08:14 Why Convex stores entire documents instead of columns
09:44 The real cost of SELECT and COUNT in Convex
11:48 Explicit modeling vs implicit SQL primitives
14:10 Workarounds for SELECT and COUNT in Convex

#Convex #Database #FullStackDevelopment #BackendDevelopment #WebDevelopment #TypeScript #React #Serverless #RealTimeApps #queryoptimization