Hacker News Reader

The official Ultimate Debian Database only allows Debian project members to access it. Mattia Rizzolo and I co-maintain a mirror. Query and enjoy!

psql "postgresql://udd-mirror:udd-mirror@udd-mirror.debian.net/udd"

I wrote up its history recently: https://announce.asheesh.org/2020/11/the-ultimate-debian-dat...

More info about the service: https://udd-mirror.debian.net/

View on HN

That is cracking! Thank you. I note rather a lot of Ubuntu themed tables which will come in handy as well.

I use Arch for my personal gear, Debian for Home Assistant instances and Ubuntu for nearly everything else. A slack handful of Gentoo boxes hang around, looking moody and causing trouble 8) This sort of resource is a great idea.

I can see myself wiring it up to an automated change tracker or similar idea still boiling around in my head. Bugs are in there as well and a lot of other good stuff that should mean that I can run a query to show me what will break before I do updates!

Just curious, how do you configure the connection limit for this public postgres instance? Is it just a high value, or something more clever?

Reply on news.ycombinator.com