vinarun
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
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...
Tech stocks are way up: layoffs and buy backs
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
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
What the US can do to prepare for a war with China
Russia's foreign minister says its the highest probability of nuclear conflict
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
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...
Is BTC up because of lack of trust in banks post-SVB?
BITCOIN EXTENDS GAINS TO INTRADAY HIGH OF $23,558, LAST UP 5.9%
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...
Congress makes moves against Chinese tech
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...
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...
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)?
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
Bracket: Turn G-Sheets into a UI for your database / warehouse
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
Show HN: Set up internal tools directly in G sheets, Airtable and Notion
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....