Hey Stacker fam, wanted to share how the company I work for is making Stacker more valuable in case it’s helpful to others too. We are using Stacker mainly for internal tools but I think this would be helpful for any use case if your company has a database.
We use Postgres to hold our data but customer service and sales wanted to build tools for their teams, and since they’re not engineers they didn’t have access to data they needed in Postgres, and felt more comfortable in Airtable (which is why they pushed for Stacker).
At first we tried getting the engineering team to connect Airtable and Postgres but the syncs kept breaking. We tried working with the Airtable API and BaseQL but it wasn’t a good long term solution.
Zapier does work. But it didn’t catch deletes or certain updates. If you’re looking to send only new records and send data in one direction, I’d use Zapier.
Bracket worked really well. It sends data from Postgres to Airtable (whether it’s an update, delete, anything), and it sends data from Airtable back to Postgres. So when customer service or sales team members made updates in our Stacker apps, those changes were logged in Airtable and then sent to the rest of the business (because it was sent to Postgres). I made some fields only sync one way so that they couldn’t just change any data in the database.
Bracket does work with Google Sheets and other databases too but I haven’t tested the product with those. I’d imagine it works similarly though.
I tried some ETL solutions but it didn’t work well for this use case and seemed like overkill.
Hope this helps!