ianyanusko

6 ms·

1.
by ianyanusko 3y ago
With Salesforce specifically, getting a stable and reliable event-driven stream. That's why we ended up adopting a hybrid approach of subscribing to pub/sub events, but also periodically polling the REST API in case pub/sub m
2.
by ianyanusko 3y ago
Thank you! It means a lot to see your comment here
3.
by ianyanusko 3y ago
Hubspot and MySQL are both next on our list for deploying out of beta! I'll shoot you a message when they're out :)
4.
by ianyanusko 3y ago
Good question. Our ultimate goal is to be the go-to for any two-way data syncs. We think the Salesforce syncing market by itself is 500 million to 1B. If you start including all of the tools we have our eyes on (Hubspot, Monday, ERPs), the
5.
by ianyanusko 3y ago
Gotcha, that makes sense. From our perspective, the one-way sync market (backups and ETL/rETL) was already saturated with heavily-capitalized players who were hitting each other hard with marketing dollars. We didn't feel that we
6.
by ianyanusko 3y ago
Nice! Great point about the round trip - we do something similar for formulas and auto-generated fields like `Id`. That's awesome you built this in-house. > Syncing data from Salesforce (to seed a database for example) is done via R
7.
by ianyanusko 3y ago
1. Yes, on our roadmap for Q1! Getting that request a lot 2. We don't currently sync metadata 3. Our footprint on your Salesforce API depends on whether you're using polling or streaming, and then it depends on the cadence of your
8.
by ianyanusko 3y ago
Agreed on the trickiness! Our early users largely told us they preferred one source to take precedence in a conflict, and would rather set that general rule than review every conflict manually. But a handful have expressed interest in the l
9.
by ianyanusko 3y ago
Nice, I hear you on "fun and aggravating" :) Sounds similar to the use cases we're seeing, where it's not only easier to process/build on Postgres, but also saves you on the Salesforce API.
10.
by ianyanusko 3y ago
> How specific is your solution to Postgres? Could it be ported to another db engine? Our polling approach is relatively database-agnostic. We just need to handle each DB's quirks with our transformers (e.g. dealing with MySQL'
11.
by ianyanusko 3y ago
Really helpful on both fronts, thanks for the thoughts. Both the sandbox and migration use cases make a lot of sense.
12.
by ianyanusko 3y ago
Agreed! We’re big fans of consolidating in Postgres. We’re also hearing some downstream benefits to having things scaled in Postgres (makes reporting easier, allows the data team to use SQL rather than hitting an API, etc) from our users.
13.
by ianyanusko 3y ago
Sorry, forgot to respond to one piece: > Many clients I can think of this being most useful for would rather host it themselves, is that an option? Right now you can self-host the associated datasets (like the Postgres event log table),
14.
by ianyanusko 3y ago
Thank you! > do you support subsetting a data source -- only sync records matching criteria? In a one-way sync from Postgres to Salesforce, yes, you can apply filters using a SQL statement, but we’re working on adding this to the Salesfo
15.
by ianyanusko 3y ago
Thanks for the comment - are you saying that one-way sync has a 10x wider audience than two-way syncs?
16.
by ianyanusko 3y ago
Agreed that many technical founders build on the pain points they've experienced themselves. I'm curious your take on why the managed services approach is hard to scale? IMO, the reason many YC companies struggle with enterprise s
17.
by ianyanusko 3y ago
Thanks! Going to shoot you a note
18.
by ianyanusko 3y ago
We use a custom trigger to build an event log in Postgres. We actually found it more straightforward to use this approach than to use the WAL packages we considered. If you're curious, you can read more about our approach to it and the
19.
by ianyanusko 3y ago
Thanks! We've had to internalize the lesson "startups can do one thing well at a time" :) At first, it was a matter of doing discovery with people who we thought would find Bracket useful. These weren't sales convos, but
20.
by ianyanusko 3y ago
For sure, definitely has not been an easy problem to solve. The two-way syncing is one tough element (for the reasons mentioned above), and configuring our requests to the Salesforce API in a way that minimizes our footprint (while still ke
21.
by ianyanusko 3y ago
Thank you!
22.
by ianyanusko 3y ago
Yeah exactly. One-way data syncing is a big market, and these companies have plenty of use cases to tackle, which is why I think two-way syncing has not been a priority for them. That’s one reason why people trying to stand up two-way syncs
23.
by ianyanusko 3y ago
Yup! We offer two ways of interacting with Salesforce: polling and streaming. The benefits of streaming are faster syncs and optimized Salesforce API usage. Right now, we're focusing on use cases that require changes to be synced withi
24.
by ianyanusko 3y ago
Fivetran and Hightouch do ELT and reverse ETL, respectively, which are one-way syncs. While Bracket can handle one-way syncs, two-way syncs (in situations where you need writes from both Postgres and Salesforce to sync) are our bread and bu
25.
Launch HN: Bracket (YC W22) – Two-Way Sync Between Salesforce and Postgres
92 points by ianyanusko 3y ago|77 comments
26.
by ianyanusko 3y ago
Good point. Even if we're stuck on Earth for a while, I wonder if the repression he mentions will manifest itself meaningfully. E.g. today, how repressed are the Amish, who have famously high birth rates? Exempt from SS taxes and ACA r
27.
Fertility Scenarios(overcomingbias.com)
9 points by ianyanusko 3y ago|23 comments
28.
by ianyanusko 3y ago
A trilogy of books from Reza Aslan: God: A Human History , Zealot , and No god but God . These follow 1) the evolution of human conceptions of God, 2) the historical Jesus, and 3) the historical Muhammad, respectively. They're extre
29.
Show HN: Bracket, a Heroku Connect alternative(app.usebracket.com)
6 points by ianyanusko 3y ago|0 comments
30.
by ianyanusko 3y ago
A step in the direction of a personalized software future. Congrats, Arc team - rooting for you.

More ›