News for hackers. Stuff that matters.

vinarun

Yeah agreed! We were surprised to hear how deeply bundled Heroku Connect is in their Enterprise plan. Reps not knowing about heroku connect coupled with their abandoned roadmap make us excited to build a better solution
this is actually answered on the airtable community forum

https://community.airtable.com/t5/development-apis/feature-r...

Ask HN: Why do you use Heroku Connect?

I’ve seen articles like the one below on 2-way syncs between Salesforce & Postgres. As someone in the data engineering space, what is the use case / business reason for companies doing this?https://gorenje.medium.com/the-case-for-bi-directional-salesforce-postgres-synchronization-ff0090ef6531

( Read More... | no comments | on HN )

Best Practices for Data Pipelines

To set up reliable data pipelines, there are some best practices you should follow: 1. Think about which data connectors you need 2. Abilities of your team (set up time, maintenance time, skills) 3. Budget 4. Customer support SLAsOne tool may not meet all requirements or needs, but if it’s best-in-class at what it does, it’s worth it. Some helpful advice I’ve seen online:Safeguard your raw...

( Read More... | no comments | 2 points | on HN )
Re:Turn Notion into a UI for Postgres on Tuesday April 04, 2023 @01:32PM (#35443148)
There are limitations by notion on what can be viewed to thousands of records, but you can use a query to pull a filtered view of data in Notion. It's not just a 1:1 mapping but changes in Notion will persist through data in the database that is joined

It's really a way for teams such as customer service who may have their CS ops in Notion to view & change customer data in your data store without adding to an engineer's backlog

Re:Turn Notion into a UI for Postgres on Tuesday April 04, 2023 @01:30PM (#35443113)
looks like it's working now!

Turn Notion into a UI for Postgres

Saw this product hunt post that helps customer service teams who use Notion view and change customer service data in Postgres, without leaving Notion. Sharing in case it's helpfulhttps://www.producthunt.com/posts/portal-b96e3e18-f1d7-4c75-bf65-330bf5df4962

( Read More... | 5 comments | 8 points | on HN )

How much bank short sellers profited

Short sellers in first republic made about $560 Million in profit on paper over the past weekShort sellers in western alliance bancorp made about $59 Million in profit on paper over the past weekShort sellers in Pacwest bancorp made $14.7 Million in profit on paper over the past week - ORTEX

( Read More... | 1 comment | on HN )

How LatAm Tech Is Replacing Retool with Google Sheets and Notion

BackgroundThe Latin American tech scene is an operations heavy one. Cost of labor is cheap, so it only makes sense. With cheap cost of labor comes a high number of ops workers that rely on tools they’re most familiar with, which we’ve seen has been primarily Google sheets and notion – for everything, literally everything. FYI I’m a founder of Bracket: a two-way data syncing product that lets...

( Read More... | 1 comment | on HN )
Re:I asked ChatGPT to explain why SVB stock is crashing on Friday March 10, 2023 @03:01PM (#35100080)
yeah you're right. Is a few weeks the true lag time for chatGPT?

I asked ChatGPT to explain why SVB stock is crashing

I love AI. results below! ____Silicon Valley Bank (SVB) is a bank that primarily serves the technology and innovation sector. The bank has been around since 1983 and has grown to become a major player in the industry, with a reputation for working with high-growth companies and startups. However, in recent months, the stock price of SVB has been going down. In this post, we will explore the...

( Read More... | 4 comments | on HN )
Re:Congress makes moves against Chinese tech on Monday March 06, 2023 @08:34PM (#35050360)
U.S. SENATORS WARNER AND THUNE TO ANNOUNCE BILL ON TUESDAY "THAT WILL COMPREHENSIVELY ADDRESS THE ONGOING THREAT POSED BY TECHNOLOGY FROM FOREIGN ADVERSARIES, SUCH AS TIKTOK" -STATEMENT
it was only a matter of time given that Stripe has a penalty too

Two-way syncs across your data stack and SaaS tools

Hey data teams! I wrote a blog post on how to data teams can help non-technical colleagues receive & send data to the rest of the company. Thought it'd be useful to lay out the key points here for anybody who is facing this problem!The problemThe point of using Airtable & Notion is to give nontechnical folks the ability to easily work with data. But a company’s data primarily sits in a...

( Read More... | 1 comment | 5 points | on HN )
Re:Make G-Sheets a UI for your MongoDB on Tuesday January 17, 2023 @03:41PM (#34418662)
https://usebracket.com in case you're interested!

Make G-Sheets a UI for your MongoDB

Hey fellow Sheets lovers,I recently wrote a blog post on different ways to sync Google Sheets with MongoDB, and thought it would be useful to lay out the key points here for anybody who is facing this problem!The problemG sheets is an incredibly popular way for business teams to interact with data. You can use Sheets for internal tools, BI, ad hoc analysis, you name it. However, it's extremely...

( Read More... | 2 comments | 4 points | on HN )

How do you sync customer data in CRMs and Accounting tools to your database?

If your customers have data in Salesforce, Quickbooks, SAP, or whatever else and you need to bring that into your product. How do you bring that data in?Do you build ETL pipelines to sync data both ways?Is there a solution available to buy instead of building it from scratch that can handle a sync both ways (with conflict resolution)?

( Read More... | 1 comment | 3 points | on HN )
Re:Bracket: Turn G-Sheets into a UI for your database / warehouse on Wednesday December 14, 2022 @10:41AM (#33985019)
Great question!

1. We sync as fast as every minute, whereas airbyte syncs at least every hour. This makes the Google Sheet a way less useful read/write tool, and can also lead to a ton of merge conflicts if you're trying to set up a two-way sync.

2. On that note: Bracket is built for two-way syncing, with handling for merge conflicts built in. That way, you're in control of which source wins race conditions.

3. We have field level controls. For example, some data in the google sheet can be read-only while others are read & write

4. It's at least twice the work (often more!) to set up and manage two pipelines instead of one -- almost like having one email address for sending emails and another for receiving them

5. Airbyte does not support transformations for G Sheets currently, whereas with Bracket you can write a SQL query to transform your data from Postgres to Sheets

Ask HN: Have you ever set up two-way data syncs? What did you use?

Hey HN, asking for help from my fellow data engineering community! Between what two systems have you ever needed a two-way data sync?For example, I’ve seen some devs wanting it to connect databases to tools like Airtable. But are there other tools / use cases that you’ve seen? I’ve heard of Mulesoft and Piesync but those seem overly expensive for these use cases

( Read More... | 3 comments | 4 points | on HN )

Show HN: Set up internal tools directly in G sheets, Airtable and Notion

https://www.usebracket.com/

Hey HN! Vinesh, Ian, and Kunal here. We’re building Bracket (YC W22), a bidirectional ETL platform — software that syncs data two ways between your data stack and the spreadsheet tools that your business teams rely on (e.g. Google Sheets, Airtable, and Notion databases), with the ability to add transformation logic (like SQL statements or MongoDB aggregation statements) in between....

( Read More... | no comments | 3 points | on HN )