What if convex had a structured query language?
I have found myself occasionally miss the quickness of going into a sql editor for some quick one-off analytics.
I vibe coded a read-only demo to see what that would look like.
It's my own flavor of SQL that converts into convex queries under the hood.
Ofc it's probably not scalable and is mildly ironic. But if it's for one-offs why not?
Let me know what you think
https://convexql.vercel.app/
https://github.com/jeffmylife/convex-sql
https://x.com/jeffreylemoine/status/1981392090501435433
4 Replies
Interesting approach, I like it - I do wonder about some weirdness though, esp. related to query timing
This query should seem to be stricly slower than
this other query
but it's not, it seems to be always faster to filter by age
despite age being a table scan?
So I do wonder what the difference is - and what the generated API calls look like