postgres?
Hi this might be an odd question but what database is Convex using under the hood, and can we get direct access to it? The reason I'm asking is because I'm trying out the managed cloud offering of Supaglue, a unified CRM connector, and what they do is they sync all of a customer's data into a postgres instance that I give its connection info to. It only supports postgres or s3.
3 Replies
Right now I have postgres on an EC2 that is syncing with supaglue, but that's obviously outside the convex system, and the bulk of the data I need to store beyond just simple bits of user/company info is this CRM data.
I saw it looks like maybe Supabase runs on postgres and gives direct access to it, is that something I can do with Convex??
Hi! Convex internally stores data with both postgres and mysql, but we don't provide direct access to the underlying database. For one thing, the data is stored in a special format so we can run each javascript function as a transaction. We are considering exposing a layer where you can run sql queries against the data, but that will have caveats and won't be a direct postgres database.
To support your use-case, we have built an Airbyte connector which can sync data from Convex into any Airbyte destination, including postgres and S3. https://docs.airbyte.com/integrations/sources/convex/ . We are working with airbyte to make it available in their OSS and cloud offerings.
Convex | Airbyte Documentation
This page contains the setup guide and reference information for the Convex source connector.