frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

War Department Cuts Ties with Harvard University

https://www.war.gov/News/News-Stories/Article/Article/4399812/war-department-cuts-ties-with-harva...
1•geox•1m ago•0 comments

Show HN: LocalGPT – A local-first AI assistant in Rust with persistent memory

https://github.com/localgpt-app/localgpt
1•yi_wang•1m ago•0 comments

A Bid-Based NFT Advertising Grid

https://bidsabillion.com/
1•chainbuilder•5m ago•1 comments

AI readability score for your documentation

https://docsalot.dev/tools/docsagent-score
1•fazkan•12m ago•0 comments

NASA Study: Non-Biologic Processes Don't Explain Mars Organics

https://science.nasa.gov/blogs/science-news/2026/02/06/nasa-study-non-biologic-processes-dont-ful...
2•bediger4000•16m ago•2 comments

I inhaled traffic fumes to find out where air pollution goes in my body

https://www.bbc.com/news/articles/c74w48d8epgo
2•dabinat•16m ago•0 comments

X said it would give $1M to a user who had previously shared racist posts

https://www.nbcnews.com/tech/internet/x-pays-1-million-prize-creator-history-racist-posts-rcna257768
3•doener•19m ago•0 comments

155M US land parcel boundaries

https://www.kaggle.com/datasets/landrecordsus/us-parcel-layer
2•tjwebbnorfolk•23m ago•0 comments

Private Inference

https://confer.to/blog/2026/01/private-inference/
2•jbegley•26m ago•1 comments

Font Rendering from First Principles

https://mccloskeybr.com/articles/font_rendering.html
1•krapp•29m ago•0 comments

Show HN: Seedance 2.0 AI video generator for creators and ecommerce

https://seedance-2.net
1•dallen97•34m ago•0 comments

Wally: A fun, reliable voice assistant in the shape of a penguin

https://github.com/JLW-7/Wally
2•PaulHoule•35m ago•0 comments

Rewriting Pycparser with the Help of an LLM

https://eli.thegreenplace.net/2026/rewriting-pycparser-with-the-help-of-an-llm/
2•y1n0•37m ago•0 comments

Lobsters Vibecoding Challenge

https://gist.github.com/MostAwesomeDude/bb8cbfd005a33f5dd262d1f20a63a693
2•tolerance•37m ago•0 comments

E-Commerce vs. Social Commerce

https://moondala.one/
1•HamoodBahzar•37m ago•1 comments

Avoiding Modern C++ – Anton Mikhailov [video]

https://www.youtube.com/watch?v=ShSGHb65f3M
2•linkdd•39m ago•0 comments

Show HN: AegisMind–AI system with 12 brain regions modeled on human neuroscience

https://www.aegismind.app
2•aegismind_app•43m ago•1 comments

Zig – Package Management Workflow Enhancements

https://ziglang.org/devlog/2026/#2026-02-06
1•Retro_Dev•44m ago•0 comments

AI-powered text correction for macOS

https://taipo.app/
1•neuling•48m ago•1 comments

AppSecMaster – Learn Application Security with hands on challenges

https://www.appsecmaster.net/en
1•aqeisi•49m ago•1 comments

Fibonacci Number Certificates

https://www.johndcook.com/blog/2026/02/05/fibonacci-certificate/
2•y1n0•50m ago•0 comments

AI Overviews are killing the web search, and there's nothing we can do about it

https://www.neowin.net/editorials/ai-overviews-are-killing-the-web-search-and-theres-nothing-we-c...
5•bundie•55m ago•1 comments

City skylines need an upgrade in the face of climate stress

https://theconversation.com/city-skylines-need-an-upgrade-in-the-face-of-climate-stress-267763
3•gnabgib•56m ago•0 comments

1979: The Model World of Robert Symes [video]

https://www.youtube.com/watch?v=HmDxmxhrGDc
1•xqcgrek2•1h ago•0 comments

Satellites Have a Lot of Room

https://www.johndcook.com/blog/2026/02/02/satellites-have-a-lot-of-room/
3•y1n0•1h ago•0 comments

1980s Farm Crisis

https://en.wikipedia.org/wiki/1980s_farm_crisis
4•calebhwin•1h ago•1 comments

Show HN: FSID - Identifier for files and directories (like ISBN for Books)

https://github.com/skorotkiewicz/fsid
1•modinfo•1h ago•0 comments

Show HN: Holy Grail: Open-Source Autonomous Development Agent

https://github.com/dakotalock/holygrailopensource
1•Moriarty2026•1h ago•1 comments

Show HN: Minecraft Creeper meets 90s Tamagotchi

https://github.com/danielbrendel/krepagotchi-game
1•foxiel•1h ago•1 comments

Show HN: Termiteam – Control center for multiple AI agent terminals

https://github.com/NetanelBaruch/termiteam
1•Netanelbaruch•1h ago•0 comments
Open in hackernews

Postgres for everything, does it work?

11•saisrirampur•1mo ago
I recently revisited an HN discussion on using “Postgres for everything” (https://news.ycombinator.com/item?id=42347606 ) and also read/participated in this Twitter thread: https://x.com/BenjDicken/status/2002742633966514544 . Both prompted a few reflections. What stood out to me was how divided opinions still are—some people strongly believe in this approach, while others don’t. I wanted to share my perspective on this.

In my experience, many proponents of “Postgres for everything” haven’t been exposed enough to (newer) purpose-built technologies and the tremendous value they can create. I was firmly in that camp for nearly a decade while working at Citus and on the Microsoft Postgres team. After building PeerDB (a Postgres CDC product that syncs data to various systems) and working at ClickHouse, my perspective completely changed. Seeing firsthand the “magic” that purpose-built systems deliver for their specific use cases—especially in terms of cost, performance, and scale—was truly eye-opening.

Don’t get me wrong—I’m a huge Postgres proponent and have spent 10 years helping customers implement it. However, I strongly believe in using Postgres for what it was designed for in the first place. Postgres is a row-based OLTP database, with over 30 years of engineering effort dedicated to making it robust for that specific workload.

Proponents of “Postgres for everything” often argue that a single stack is simpler and reduces complexity. What’s frequently overlooked, however, is the CAPEX and OPEX required to make Postgres work well for use cases it wasn’t designed for. At Citus, many customers had reasonably sized teams of Postgres experts whose primary job was to constantly tune, operate, and “babysit” the system to keep it working at scale.

Separately, we’re seeing the need for purpose-built technologies emerge much earlier in a company’s lifecycle, likely driven by AI. At ClickHouse, many customers using Postgres CDC are seed-stage companies that have grown rapidly. We pulled together some data that highlights these trends here: https://clickhouse.com/blog/postgres-cdc-year-in-review-2025#use-cases

Ultimately, I believe it’s better to make it seamless and even magical for users to integrate purpose-built technologies with Postgres, rather than making an overgeneralized claim of “Postgres for everything.”

Comments

websiteapi•1mo ago
postgres is great but seems too high level "for everything."
speedgoose•1mo ago
Because you worked at Citus and Clickhouse, I think you are more experienced than most of us.

But I can add that saving medium to large files in PostgreSQL, or clickhouse, doesn’t work well.

romanhn•1mo ago
My interpretation of "Postgres for everything", which I totally agree with, is that it is a sane initial default for just about anything. It is a well-understood stack that most people have had some exposure to, and that can handle quite a wide variety of problems. New/specialized tech will have all sorts of sharp edges, it will absolutely introduce complexity, and bring about headaches you didn't expect. And frankly, in lots of cases it's premature optimization. With all that said, if the use case has proven itself out and Postgres is truly starting to struggle - by all means, good time to explore alternatives. There are no silver bullets in this business.
nacozarina•1mo ago
‘Every app is properly a db app’ is Oracle’s defining mantra and they weren’t the first.

Their sales reps LOVE the Postgres For Everything movement. It realigns app arch debates to traditional structures, conventions and objection handling.

Once a target account has made a tech commitment to PG4E, it is a trivial matter for sales to walk in later, have a ‘business conversation’, and the next thing you know your boss signed a seven-year Oracle deal.

borplk•1mo ago
Simply speaking "Postgres for everything" is meant as a fool-proof default choice for the average person making an average app. It helps startups avoid tangling themselves with some bespoke/complex combination of Redis+Postgres+RabbitMQ+MongoDB from day 1 for their app that reaches a peak of 10 requests per second with 100 daily average users if they are lucky.

This usually happens because a junior dev wants to have fun and pad their resume while playing around with tech. Or they are insecure and want to make the "maximally proper" choice with everything so they appear to be an expert. For example they think storing any JSON or cache data in Postgres is somehow incorrect or forbidden and they must use something more specific to feel like they've made the correct choice.

In general Postgres will take people very far. Majority of companies could start with it and live with it forever. If they are lucky enough to need something else by that point hopefully they have enough money and staff to re-evaluate the stack and make changes for the future of the company.