is there a recommend way to sync a separate postgresdb with convex?
I'm working on a crypto based chat application that takes in a user mapping depending on some onchain state. To get the onchain state, I am running my own indexer which stores (apart from metadata) these indexed values in postgres. The indexer (https://ponder.sh/docs/production/railway) currently only supports writing to postgres.
Is it possible to somehow sync state between convex and this postgres db I run? It would only need to be one direction, from postgres -> convex and I can use convex as the source of truth for the application state
Deploy on Railway
Host a Ponder app on Railway
3 Replies
Thanks for posting in <#1088161997662724167>.
Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets.
- Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.)
- Use search.convex.dev to search Docs, Stack, and Discord all at once.
- Additionally, you can post your questions in the Convex Community's <#1228095053885476985> channel to receive a response from AI.
- Avoid tagging staff unless specifically instructed.
Thank you!
I don't know if you have a way to hit external api's from ponder, but if you do, you could use http actions in Convex to set up CRUD and basically run it like webhooks.
hey thanks for replying. I'm going to try it this way for now