Grouping digits in SQL(peter.eisentraut.org)
85 points by ingve | 12 comments
85 points by ingve | 12 comments
47 points by hasheddan | 28 comments
Blog post explaining why microcontroller-based IoT devices are likely unaffected by the eMudhra intermediate CA private key compromise, due to minimal pinned root CA bundles.
412 points by karlmush | 238 comments
A blog post by Raphael Bauer arguing for using PostgreSQL as the single backend for many workloads instead of specialized tools.
389 points by todsacerdoti | 161 comments
A blog post cataloging practical lessons and tips about working with PostgreSQL, including normalization, NULL handling, and making psql more useful.
83 points by KraftyOne | 26 comments
A DBOS blog post by Peter Kraft explaining why Postgres SELECT DISTINCT queries perform poorly at scale.
452 points by turtles3 | 256 comments
A Tiger Data blog post by Raja Rao DV arguing that teams should use PostgreSQL for most workloads instead of adding specialized databases, especially in the AI era.
635 points by pavel_lishin | 373 comments
A blog post on pierce.dev arguing that self-hosting PostgreSQL is a reasonable alternative to managed database services.
387 points by taubek | 296 comments
A blog post by Maciej Walkowiak discussing the use of UUIDs as primary keys in PostgreSQL, including storage and performance considerations, with Java examples.