news
PostgreSQL News and Some More Databases
-
PostgreSQL ☛ ReinDB: read-only performance monitoring for PostgreSQL, first database free
Bandlei has released ReinDB, read-only performance monitoring for PostgreSQL, self-managed or on Amazon RDS and Aurora.
ReinDB learns what normal looks like for each database and statement, hour by hour, using pg_stat_statements, and flags what drifts from it, ranked by the extra database time each change costs. Each flag shows the evidence, including plan history, and a fix script your DBA can test, with an undo for each step.
-
PostgreSQL ☛ myDBR 7.7 brings web reporting to PostgreSQL
Helsinki, Finland, 2026-10-28 - myDBR.com announced PostgreSQL support in myDBR, its web-based reporting platform for SQL databases. PostgreSQL 12 or later can now hold both myDBR's own objects and the reports, alongside the MySQL, MariaDB and Abusive Monopolist Microsoft SQL Server support that myDBR already has.
What is myDBR?
myDBR turns SQL into a finished reporting portal. A developer writes the report logic in the database. myDBR supplies the web interface: parameter forms, tables, charts, maps, drill-downs, scheduling, user management and export to Excel, PDF and CSV. Users need only a browser, and there is no separate report designer or proprietary query language to learn. If you can write a query, you can publish a report.
-
PostgreSQL ☛ Autobase 2.12 released
We are pleased to announce the release of Autobase 2.12!
-
Dark Reading ☛ US Government Email Systems Open to Abuse Thanks to Typos
In a new study of more than 25,000 government-related domains, SH Consulting founder Alex Shakhov found dozens whose DNS records referenced either mistyped, expired, or otherwise repurposed domains. Though few in number, those vulnerable included all sorts of agencies representing US towns, cities, counties, regulatory boards, and more.
-
Sean Goedecke ☛ A database is a store for global variables
Databases are for storing global variables. We usually call them “rows” or “records” instead, but they’re definitionally global variables: any part of your program can read or write them. Isn’t this kind of weird? It’s common programming advice that global variables are bad, and yet many elegant programs rely on databases. Either the common advice is wrong, or there’s something special about databases that makes them the exception to the rule.
What’s so bad about global variables? Here’s the two main reasons, in my view: [...]
-
pgEdge Inc ☛ Burnt TOAST
The performance of this table initially confused and enraged me—until I remembered about TOAST. Postgres likes to innocuously dub this backronym “The Oversized-Attribute Storage Technique” but DBAs in the field maintain a love/hate relationship with the system. Whether that’s justified is a different question.
On the surface, it’s a way to store huge blocks of data elsewhere to keep tuples small and avoid exceeding the relatively petite 8KB data page size. Postgres creates a shadow table for the bulky content, splits it up into chunks, and stores a pointer in the original row. It’s an elegant solution to a pressing issue, but there are deep performance implications.
So let’s dig into precisely why DBAs secretly dread large text-based columns, shall we?