Alternatives
Products that do what pglockanalyze - See the locks your Postgres migrations will acquire does
Hello! I created this tool to make reasoning about Postgres locks a bit easier. Given a database[1] and a set of DDL statements/migrations you want to check, pglockanalyze will open a transaction, execute the statements, read the pg_locks view to analyze the locks they acquire and rollback (or commit, depending on the flags you passed) the transaction. Then, it will output the results for each statement. I think there's merit in this idea, that said it's very much an experiment so there could be flaws and/or corner cases that this strategy won't work well for. It's meant to act as…
- 1
- 2AU
2019 · pgmustard.com
- 3
- 4
- 5
- 6ST
https://github.com/denvaar/pgdiff I cobbled together various programs into a bash script to compare how data changes between two points in time. My idea was basically to have a `git diff` but for data inside postgres. I wanted a util like this to help get to know a new code base: Interact with an app and watch how the data changes. You run the script with a given key (anything) before interacting with an app, then run it again with the same key to see the data diff. I'm not much of a bash scripter, as you can probably see from the script, but it was a fun and useful tool…
2021
- 7PM
2017 · github.com
- 8SF
2015 · github.com
- 9PP
pgrust is a PostgreSQL rewrite in Rust I've been working on with my friend Jason. It now passes 100% of PostgreSQL's regression tests and we were even able to boot pgrust off an existing PostgreSQL 18.3 data directory. You can hack on its code or try it out quickly with the WASM build on pgrust.com. It's not production ready yet. I haven't focused on performance optimized yet and it's not compatible with existing PostgreSQL extensions. I want to improve upon Postgres in many ways in the future. I wrote about some here [0], and Jason and I saw a great talk in person at PGConf.dev a month ago…
Jun 2026 · github.com
- 10IM
Hello HN, I've just released a new migration tool for Go that mimics the functionality of Ruby on Rails migrations. It's designed to help Go developers manage database schema changes with ease. This allows you several benefits: - Write type-safe migrations - Auto down of migrations whenever it's possible - Easy backfill even with business logic because it's Go code - Painless integration with existing schema - sql.DB compatible and driver agnostic (it uses your driver) I have a pretty complete API to manage Postgres schema and I am working on the SQLite one (a little more complicated due to…
2024 · github.com
- 11PC
Hi HN, pgstream is an open source CLI tool and Go library for Postgres logical replication events. We have some bigger plans with it, but as of now its main "differentiator" is that it includes not only data changes but also DDL changes in the same ordered and consistent stream. We have developed this because in the Xata platform we handle automatic replication from Postgres to Elasticsearch/OpenSearch. Initially schema changes were problematic because they required us intercepting them at the API layer and then apply them to the search engine. But if the replication is slightly delayed…
2024 · xata.io
- 12PE
2021 · pawelurbanek.com
- 13IM
Tired of your Go tests being slowed down by repetitive PostgreSQL database setup? I built pgdbtemplate to solve exactly that. It uses PostgreSQL's native template databases to create fully migrated test databases in milliseconds instead of seconds. The problem: Traditional test setup runs all your migrations for every single test. With a complex schema, this wastes minutes in every test run. The solution: Create one "golden" template database. Every test gets its own isolated copy instantly via CREATE DATABASE ... TEMPLATE. Benchmarks don't lie: - 1.5x faster for complex schemas (5+ tables)…
Sep 2025 · github.com
- 14UP
Utilizing Postgres' RLS feature to isolate user data instead of easy-to-forget where-clauses, is such an underrated use case, I really wonder why not more people use it. If you prefer code over the blog post, I've put the full application example on GitHub. Would love to hear your thoughts. https://github.com/simplyblock/example-rls-invoicing
Sep 2025 · simplyblock.io
- 15PI
2021 · pganalyze.com
- 16PE
2013 · pgexercises.com
- 17PI
2019 · github.com
- 18ZA
Hi HN, I'm Jiasheng, co-creator of ZenStack. Access control usually ends up scattered across app code instead of living with the data model — and that's riskier when the code is written by an agent, since it's easy to ship a query with a missing or incomplete authorization check. ZenStack enforces policy (RBAC/ABAC/relation-based) directly at the ORM layer, on top of Kysely, so every query gets checked the same way regardless of who wrote it and who is calling it. Postgres RLS is an option too, but it's hard to maintain and scale, and it's Postgres-only — ZenStack's approach is…
Jul 2026 · zenstack.framer.website
- 19GM
I built GoSMig for my own projects and open-sourced it in case it helps others. It’s a tiny generic library (no external deps except golang.org/x/term) for writing SQL migrations in Go with compile-time checks. It supports transactional and non-transactional migrations, rollback, status, version, and a small CLI handler so you can ship your own migration binary. Why another migrator? - Minimal API, no DSL or file layout to learn - Type-safe via Go generics - Works with database/sql and sqlx out of the box - Should work with any db library (or wrapper) that implements some…
Oct 2025 · github.com
- 20EA
2022 · github.com
- 21BO
Hey HN, I'm Kristiyan, former Engineering Manager for Redis' Visual Developer Tools (including Redis Insight). I built BetterDB because Valkey is growing fast but lacks proper observability tooling. BetterDB is a monitoring platform for Valkey (and Redis) that focuses on what existing tools miss: Historical persistence – Slowlog entries disappear when the buffer fills. BetterDB persists them so you can see what queries were running at 3am, which clients were connected, and what anomalies were detected — not just current state. Pattern analysis – Stop scrolling through raw slowlog entries.…
Jan 2026
- 22MS
MCP Server for PostgreSQL Monitoring/Operations (MCP-PostgreSQL-Ops) "Check PostgreSQL server status" "Check PostgreSQL server version and connection status" "Verify if extensions are installed" "Show current active connection count" "Show the shared_buffers configuration" "Show PostgreSQL configuration parameter for shared_buffers" "Find all memory-related configuration settings" "Show logging configuration parameters" "Display connection-related settings" "Find all timeout configurations" "Show all PostgreSQL configuration parameters" "Show top 10 slowest queries" "Show top 20 slowest…
2025 · github.com
- 23PB
Hi HN - I’m Peter, here with Max (hmaxdml), and we’re building DBOS Go, an open-source Go library for durable workflows, backed by Postgres. https://github.com/dbos-inc/dbos-transact-golang DBOS workflows make your programs durable by automatically checkpointing their state to Postgres. If your program crashes or fails, all workflows seamlessly resume from their last completed step when your program restarts. This durability makes workflows useful for solving many different problems, including: - Operating an AI agent, or anything that connects to an unreliable or…
Sep 2025 · github.com
- 24PP
Hi, the main motivation of this small personal project is the ability to build Postgres-backed python apps that remain fully pip-installable despite the dependency, while saving your users any need to setup Postgres if they don't have it. It also helps me, as a developer, to not have to remember how to set up postgres, which I find is one main barrier to using it for small stuff. It's a little project of mine that may be helpful to more people. I'm curious to hear your feedback (ps. I know about SQLite, but sometimes you want/need to build against postgres)
2024 · github.com
Ranked by how close each launch is in meaning, then by votes. Refine with a description →