nowfound

Life & fun · August 24, 2023

IB

I built this Postgres logger

Hey HN, Some of you were really interested in Postgres logging with pgAudit in my previous post here: https://news.ycombinator.com/item?id=37082827 So I built this logger: https://rocketgraph.io/logger-demo using pgAudit to show you what can be done with Postgres auditing. It offers some powerful features like "get me all the CREATE queries that ran in the past hour". These are generated by AWS RDS Instance running on my Rocketgraph account. Then they are forwarded to Cloudwatch for complex querying. In the future we can connect these logs to slack so you can…

I built this Postgres logger launched on August 24, 2023 with 94 votes, #986 of 4,347 launches that month and more than 90% of that year's launches.

Visit rocketgraph.io ↗Alternativestop 23% of August 2023

In plain words

A Postgres logger built using pgAudit that captures and analyzes database queries from AWS RDS instances. It forwards logs to CloudWatch for complex querying, allowing users to search for specific query types like all CREATE statements from the past hour. Designed for developers and database administrators who need detailed audit trails of Postgres activity, with planned integrations for Slack alerts on critical database operations.

written from the facts on this page · September 2026

From the sources

In the maker’s words, at launch

Hey HN, Some of you were really interested in Postgres logging with pgAudit in my previous post here: https://news.ycombinator.com/item?id=37082827 So I built this logger: https://rocketgraph.io/logger-demo using pgAudit to show you what can be done with Postgres auditing. It offers some…

Does a similar job

all alternatives →
  • pg_flame – flamegraph visualizations of PostgreSQL query plans2019 · github.com · ▲321

    A flamegraph generator for Postgres EXPLAIN ANALYZE output. - mgartner/pg_flame

  • PgDog – Scale Postgres without changing the appFeb 2026 · github.com · ▲326

    Hey HN! Lev and Justin here, authors of PgDog (https://pgdog.dev/), a connection pooler, load balancer and database sharder for PostgreSQL. If you build apps with a lot of traffic, you know the first thing to break is the database. We are solving this with a network proxy that works without requiring application code changes or database migrations. Our post from last year: https://news.ycombinator.com/item?id=44099187 The most important update: we are in production. Sharding is used a lot, with direct-to-shard queries (one shard per query) working pretty much…

  • Rocketgraph2024 · ▲121

    Build production grade web applications in minutes

  • Log collector that runs on a $4 VPS2023 · github.com · ▲118

    Hey guys, I'm building erlog to try and solve problems with logging. While trying to add logs to my application, I couldn't find any lightweight log platform which was easy to set up without adding tons of dependencies to my code, or configuring 10,000 files. ErLog is just a simple go web server which batch inserts json logs into an sqlite3 server. Through tuning sqlite3 and batching inserts, I find I can get around 8k log insertions/sec which is fast enough for small projects. This is just an MVP, and I plan to add more features once I talk to users. If anyone has any problems with…

  • BemiDB – Postgres read replica optimized for analytics2024 · github.com · ▲209

    Hi HN! We're Evgeny and Arjun, and we’re building a better way to do analytics with Postgres. We love Postgres for its simplicity, power, and rich ecosystem. But engineers have to still get bogged down with heavyweight and expensive OLAP systems when connecting an analytics data stack. Postgres is amazing at OLTP queries, but not for OLAP queries (large data scans and aggregations). Even in this case, we’ve still heard from countless scaling startups that they still try to use only a read replica to run analytics workloads since they don’t want to deal with the data engineering complexity of…

  • pganalyze2019 · pganalyze.com · ▲84

    Automated EXPLAIN Plan Visualization & Insights for Postgres

More life & fun this month

the category →

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

Launched alongside, August 2023

the whole month →
  • Resend▲1,325

    An entire collection of pre-built components with a much faster development experience.

    Dev tools · 2023 · resend.com

  • STORI AI▲1,316

    Your ideas become visually compelling branded social posts

    AI · 2023 · storiai.com

  • Kombai▲1,079

    A new AI model that you can prompt with UI designs

    AI · 2023 · kombai.com

  • Understand your audience without 50 interviews

    AI · 2023 · founderpal.ai

  • Lottielab▲869

    Create and ship lottie animations to sites and apps faster

    Dev tools · 2023 · lottielab.com

  • Outlines is a Python library that focuses on text generation with large language models. Brandon and I are not LLM experts and started the project a few months ago because we wanted to understand better how the generation process works. Our original background is probabilistic, relational and symbolic programming. Recently we came up with a fast way to generate text that matches a regex (https://blog.normalcomputing.ai/posts/2023-07-27-regex-guide...). The basic idea is simple: regular expressions have an equivalent Deterministic-Finite Automaton (DFA) representation. We…

    AI · 2023 · github.com