nowfound

Dev tools · March 9, 2023

Safe Data Changes in PostgreSQL

Hi HN, we're excited to share our open source tool with the community! We previously posted here with the tagline “real-time events for Postgres” [0]. But after feedback from early users and the community, we’ve shifted our focus to working on tooling for manual database changes. We've consistently heard teams describe challenges with the way manual data updates are handled. Seemingly every engineer we spoke with had examples of errant queries that ended up causing significant harm in production environments (data loss/service interruptions). We’ve seen a few different approaches to how…

Safe Data Changes in PostgreSQL launched on March 9, 2023 with 47 votes, #1,664 of 5,007 launches that month and more than 90% of that year's launches. The site was still online in September 2026, 3 years on.

In plain words

Safe Data Changes in PostgreSQL is an open-source tool designed to help engineering teams safely execute manual database updates in production PostgreSQL environments. It addresses the risk of destructive queries by providing a structured approach to data modifications, reducing incidents of accidental data loss and service interruptions. The tool targets development teams struggling with balancing speed and safety when managing production database changes, offering a middle ground between unrestricted access and cumbersome approval processes.

written from the facts on this page · September 2026

From the sources

The open-source CSV importer, maintained by @tableflowhq - tableflowhq/csv-import

In the maker’s words, at launch

Hi HN, we're excited to share our open source tool with the community! We previously posted here with the tagline “real-time events for Postgres” [0]. But after feedback from early users and the community, we’ve shifted our focus to working on tooling for manual database changes. We've consistently heard teams…

Does a similar job

all alternatives →
  • Realtime Postgres2020 · github.com · ▲62

    Broadcast, Presence, and Postgres Changes via WebSockets - supabase/realtime

  • Open Source PostgreSQL Studio2021 · supabase.com · ▲407

    Powerful PostgreSQL tool is now open source for self-hosting

  • Postgresqlco.nf: PostgreSQL Configuration for Humans2020 · ongres.com · ▲223

    We like open source, we develop open source software, and we are very active and well known at Postgres community. We also develop custom products for clients, always around Postgres environment

  • PN
    PostgresML, now with analytics and project management2022 · postgresml.org · ▲444

    We've been hard at work for a few weeks and thought it's time for another update. In case you missed our first post, PostgresML is an end-to-end machine learning solution, running alongside your favorite database. This time we have more of a suite offering: project management, visibility into the datasets and the deployment pipeline decision making. Let us know what you think! Demo link is on the page, and also here: https://demo.postgresml.org

  • PS
    Peerdb Streams – Simple, native Postgres change data capture2024 · ▲177

    Hello HN, I am Sai Srirampur, one of the Co-founders of PeerDB. (https://github.com/PeerDB-io/peerdb). We spent the past 7 months building a solid experience to replicate data from Postgres to data warehouses. Now we're expanding to queues. PeerDB Streams provides a simple and native way to replicate changes as they happen in Postgres to Queues (Kafka, Redpanda, Google PubSub, etc). We use Postgres logical decoding to enable Change Data Capture (CDC). Blog post here: https://blog.peerdb.io/peerdb-streams-simple-native-postgres.... 10-min quickstart here:…

  • Postgres query lock explainer2023 · github.com · ▲143

    This is like 4 years old, but I’m braver now and ready to share stuff with this community. I’ve been a lurker for a while. I made this tool - it’s kind of like “explain” but it tells you about what locks would be required by the query. I was making it as part of a larger tool that would try to prevent deadlocks during migrations at my last company, I never finished it.

More dev tools this month

the category →
  • /dev/null▲481

    a social network for devs

    Dev tools · 2d ago · dev-null.sh

  • open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

    Dev tools · 27d ago · github.com

  • Contribute to reladraw/reladraw development by creating an account on GitHub.

    Dev tools · 25d ago · github.com

  • OpenBot▲362

    Grok Bot alternative: free, local, open-source, multiplayer

    Dev tools · 22d ago · openbot.run

  • Talanoa▲341

    Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

    Dev tools · 20d ago · talanoa.email

  • CoreSpeed▲332

    One MCP for everything your agents need: apps, memory, tools

    Dev tools · 27d ago · corespeed.io

Source: Show HN post ↗ · launch text quoted in part

Launched alongside, March 2023

the whole month →
  • GPT-4▲1,160

    More accurate, less cringe, smoother & useful daily chats!

    AI · 2023 · openai.com

  • Collato▲972

    One AI search to find anything instantly, across all apps

    AI · 2023

  • Chat with AI using your API keys. Pay only for what you use. ChatGPT, Gemini, Claude, and other LLMs supported. The best chat LLM frontend UI for all AI models.

    AI · 2023 · typingmind.com

  • Meet the internet again

    Work · 2023 · apps.apple.com

  • Sequoia▲726

    Personalized men's sexual health with on-demand experts

    Life & fun · 2023 · sequoia.health

  • BI

    I'm a big fan of the BBC podcast In Our Time -- and (like most people) I've been playing with the OpenAI APIs. In Our Time has almost 1,000 episodes on everything from Cleopatra to the evolution of teeth to plasma physics, all still available, so it's my starting point to learn about most topics. But it's not well organised. So here are the episodes sorted by library code. It's fun to explore. Web scraping is usually pretty tedious, but I found that I could send the minimised HTML to GPT-3 and get (almost) perfect JSON back: the prompt includes the Typescript definition. At the same time I…

    AI · 2023 · genmon.github.io