Unique Indexes
Do table indexes automatically have a unique attribute? I am trying to insert a row into a table if and only if the combination of two columns does not already exist, and I have an index on the table for those two columns. How do I enforce this uniqueness?
Table deletion
Is there any way to delete a table? I had a typo and it created a table that I do not want
convex outside react
Are there any docs on writing to convex outside of React? I want to seed my database with some data via a script.
Querying the Database | Convex Developer...
Hi folks!
I was reading through the docs\blogs and I have only one question, is this https://docs.convex.dev/using/database-queries#more-complex-queries really the way to go with complex queries?
I imagined Convex to the a better alternative to Firestore, but this looks... confusing to say the least 😦...
Any hot tips for how to delete a set of
Any hot tips for how to delete a set of documents whose count is greater than 4096 (in prod environment)? Manually deleting thousands of documents is an unattractive solution (see screenshot) 😅
I imagine I could write a mutation which would do so, deploy it, and run it, but is there an easier way? (I'm aware this may not be something you'd like to make easier)...
MongoDB Realm
Hi guys, I am trying to build an application with Convex, I also looked up MangoDB realm briefly, it seems very similar in the backend serverless DB interactions, I just wonder what are the differences between Convex and Realm
Deeply nested documents
I discovered today that there is a limit on object depth in Convex of 16—I see that this is documented here (https://docs.convex.dev/using/types#limits), but it could also be nice to write a note in the description of the
Object Convex type in the Convex Types table here (https://docs.convex.dev/using/types#convex-types) (I don't think I would have missed it if it were there).
Is there any chance this limit might be changed in the future? I ran into this with an extremely small document by trying to store a ProseMirror doc serialized as JSON. I can just serialize it as a string and everything should be fine, but (naively, with no technical knowledge of why the limit is in place) I did find it surprisingly small....Scheduled functions
I would love to be able to trigger a mutation at a certain time. Is there any kind of cron feature on the roadmap?
Read & Write data access security rules
Hi all. I am just checking out Convex for the first time, and something that is not clear to me from the docs is how read/write access works. In firebase we have security rules, is there a convex equivalent? My main concern is I would like to use a db api that is not a serverless function in order to write data from the client, using CORS as the main security. I don't want something like firebase where api keys are freely exposed, and anyone can write whatever data they like if the security rule...
ablobwave poking in again one of my
:ablobwave: poking in again. one of my greater wishlist items is a way to do auth without using OpenID. is that eventually coming down the pipeline?
Auth0 token expired
I'm using Convex + Auth0 (with a custom provider, but it's pretty similar to
ConvexProviderWithAuth0). When I leave a page open for a while and then try to do something, I get a "token expired" error from Convex. Presumably I need to update the ID token periodically. Has anyone else run into similar problems?Hey guys have you ever run into this
Hey guys, have you ever run into this deployment failure with Vercel? I'm following Convex's Quickstart.
Deployment log at Vercel:
Running "npx convex deploy && npm run build" - Checking for changed table indexes......
Deploy keys
Hey all. Quick question. I've been using Convex with Fly.io for hosting. It works great. But I realized I don't really understand why it's working since I never set the CONVEX_DEPLOY_KEY environment variable in the fly Docker container. My workflow is simple, I just deploy convex, build locally (%npm run build). Copy the Vite dist/ files to a public/ directory. And then roll all that into a Fly Docker image.
My concern is that the access token was rolled into the production .js files. Is there anyway to verify this? I have a bare bones project on Github (https://github.com/61cygni/flyconv-pixi) and here is it running on Fly.io (https://falling-star-8336.fly.dev/)...
Hi I m working on a Next js app with
Hi! I'm working on a Next js app with Convex. I have a few questions 😄
1. Is it normal that every time I make a query/mutation, it does it twice at a time?
2. How does caching work? I read that Convex handles caching automatically, but I don't know how/where that works. For context, I am querying some data on the first page. When I navigate to another page, then go back to the first page, it queries the data again. I'd expect it to save the data from the previous query. Sorry, I'm sort of new to caching.
...
Latency!
Hi everybody! How big is the synchronization delay? When I do some changes in one client app how much time it takes to deliver them to another client app? I wonder whether I can build my multiplayer game on top of Convex or not.
Convex airbyte details
I couldn't find Convex in the Airbyte as a Source: https://www.loom.com/share/0ea825fbf4fb4283ab980e32eda57046, any idea?
snapshot for analytics & ml
I’m evaluating convex for a project that would require snapshotting the data periodically for analytics and training ML models..
Is there a recommended mechanism for this? (Ie does convex regularly snapshot to s3, etc)
Don’t really need to get new data/events in real-time for now...
Fine-grained developer permissions
Feature request: User group: delete permissions (clearing table/rows) - helps to onboard more personnel on growing projects with different trust profiles. I understand snapshot exports help in this regard right now and that's great! Probably more down the line we could see line item activity of what team members have done in Convex.