3 ms·
Show HN: Stripe Sync Engine – Sync Stripe to Postgres
- kiwicopple 6y agoHey HN, this is a very simple API server. It: - creates a `stripe` schema in a postgres database. - creates relevant tables/columns (eg, `customer` table, `products` table ...) - listens to stripe webhooks - upserts data into the postgres database when Stripe issues a webhook We built this to solve a few problems at Supabase. We just released billing and now our data is split between our Postgres database and stripe. We use Redash, and need a way to "join" stripe data onto our product data. We now ship the data to our main database so that we have a single-source of truth. It's very basic for now, but we like to build in public. We're releasing it early to (hopefully) gather contributors.
- rahimnathwani 6y agoThis is cool. Any reason you didn't use Singer or PipelineWise, with https://github.com/singer-io/tap-stripe https://github.com/singer-io/tap-stripe as the source? Your solution has the advantage that it's real-time. And I guess Stripe will retry webhooks if your endpoint is temporarily down. But it seems like extra maintenance effort vs. a launching Singer with a cron script, or installing PipelineWise.
- kiwicopple 6y agoHonest answer, I didn't know about Singer before but it looks great. > But it seems like extra maintenance effort vs. a launching Singer with a cron script Agreed - I'll try it out or use them in tandem - Singer for initial load, this repo for keeping up to date. Thanks for sending this through
- kiwicopple 6y agoI found another tool which uses Singer: https://airbyte.io https://airbyte.io Looks very promising, and was fast to get set up