Hacker News with Generative AI: PostgreSQL

PostgreSQL is the Database Management System of the Year 2024 (db-engines.com)
DB-Engines is today announcing that PostgreSQL is our DBMS of the Year for the second year in a row, winning for the fifth time overall after also being top-ranked in 2017, 2018, 2019, and 2023. Second in the rankings was Snowflake, followed by Microsoft in third place. PostgreSQL has emerged as the most popular database management system over the past year, outpacing all other 423 monitored systems.
Databases, Awards, PostgreSQL
261 points by plaur782 4 days ago | 106 comments
PostgreSQL Anonymizer (readthedocs.io)
PostgreSQL Anonymizer is an extension to mask or replace personally identifiable information (PII) or commercially sensitive data from a Postgres database.
Data Privacy, PostgreSQL, Databases, Security
232 points by chynkm 4 days ago | 48 comments
Apache AGE: Graph Database for PostgreSQL (apache.org)
Databases, PostgreSQL, Graph Databases
4 points by wslh 6 days ago | 0 comments
PostgreSQL Support for Certificate Transparency Logs Now Available (transparency.dev)
Certificate Transparency logs can now leverage PostgreSQL’s reliability and performance, giving log operators additional storage choice and flexibility.
PostgreSQL, Security, Databases, Certificate Transparency
57 points by tracymiranda 10 days ago | 21 comments
Back to basics: Why we chose long-polling over websockets (inferable.ai)
Like many teams building real-time systems with Node.js and TypeScript, we've been exploring ways to handle real-time updates at scale. Our system handles hundreds of worker nodes constantly polling our PostgreSQL-backed control plane for new jobs (tool calls issued by agents), while agents themselves continuously pull for execution and chat state updates. What started as an exploration into WebSockets led us to a surprisingly effective "old-school" solution: HTTP long polling with Postgres.
Real-time Systems, Node.js, TypeScript, PostgreSQL, WebSockets
258 points by lunarcave 13 days ago | 163 comments
Show HN: Postgres-SQLite: SQLite as first-class types in Postgres (github.com/michelp)
postgres-sqlite is a PostgreSQL extension that introduces SQLite databases as a first-class data type within PostgreSQL.
Databases, PostgreSQL, SQLite, Extensions
15 points by michelpp 13 days ago | 2 comments
Using watermarks to coordinate change data capture in Postgres (sequinstream.com)
In change data capture, consistency is paramount. A single missing or duplicate message can cascade into time-consuming bugs and erode trust in your entire system. The moment you find a record missing in the destination, you have to wonder: is this the only one? How many others are there?
Databases, Data Management, PostgreSQL
102 points by misonic 15 days ago | 0 comments
PostgreSQL Meets ScyllaDB's Lightning Speed and Monstrous Scalability (medium.com)
PostgreSQL’s inability to handle our growing write-intensive workloads and real-time demands made it clear that a change was necessary.
Databases, Performance, Scalability, PostgreSQL, ScyllaDB
7 points by sebg 22 days ago | 2 comments
Show HN: Apache Cloudberry – Open-source Massively Parallel Processing database (github.com/apache)
Apache Cloudberry (Incubating), created by the original developers of Greenplum Database, is one advanced and mature open-source Massively Parallel Processing (MPP) database, which evolves from the open-source version of the Pivotal Greenplum Database®️ but features a newer PostgreSQL kernel and more advanced enterprise capabilities.
Open Source, Databases, PostgreSQL
35 points by djhu9 30 days ago | 7 comments
Amazon explains absence of familiar features in 'PostgreSQL compatible' Aurora (devclass.com)
At re:Invent in Las Vegas, Amazon previewed Aurora DSQL – a distributed SQL database manager with fast reads and writes, and declared that it was PostgreSQL compatible. Yet there are missing features including foreign keys, views, triggers, sequences, extensions … and much more.
Databases, PostgreSQL, Cloud Computing, Open Source
12 points by rbanffy 37 days ago | 1 comments
Pgroll – Zero-downtime, reversible, schema changes for PostgreSQL (new website) (pgroll.com)
PostgreSQL, Databases, Database Management, DevOps, Zero-Downtime
262 points by todsacerdoti 37 days ago | 52 comments
How to use Postgres for everything (github.com/Olshansk)
How to reduce complexity and move faster? Just Postgres for everything.
Databases, PostgreSQL, Software Development
289 points by Olshansky 42 days ago | 170 comments
VectorChord: Store 400k Vectors for $1 in PostgreSQL (pgvecto.rs)
We’re pleased to announce our new vector search extension for PostgreSQL, providing a highly cost-effective way to manage large vectors. Using VectorChord, you can achieve a QPS of 131 with 0.95 precision on 100 million 768-dimensional vectors for the top 10 queries. This setup costs only $250 monthly and can be hosted on a single machine.
Database, Vector Search, PostgreSQL, Open Source, Cost-Effective
156 points by gaocegege 44 days ago | 42 comments
Crunchy Data Warehouse: Postgres with Iceberg for High Performance Analytics (crunchydata.com)
Today, we are thrilled to announce Crunchy Data Warehouse, a modern, high performance analytics database built into PostgreSQL, initially available as a managed service on AWS via Crunchy Bridge.
PostgreSQL, Analytics, Cloud Computing, Databases, Managed Services
23 points by petercooper 44 days ago | 2 comments
Scaling Breakthrough: EPAS 17 Scales Twice as Well, Thanks PostgreSQL (enterprisedb.com)
Thanks to the open-source community that maintains PostgreSQL, the release of EDB’s   Postgres Advanced Server (EPAS) 17, and its advancements in scaling efficiency have set a new benchmark, nearly doubling the performance capabilities of its predecessor, EPAS 16.
Databases, PostgreSQL, Open Source, Performance, Enterprise Software
13 points by dougcalobrisi 45 days ago | 4 comments
PostgreSQL High Availability Solutions – Part 1: Jepsen Test and Patroni (binwang.me)
I’ve used Cockroach DB for a few my side projects. I enjoyed it overall. But since it announced license change and require mandatory telemetry collection for free version, I started to look for alternatives. The most nature chose is to just use the plain old PostgreSQL since my data size is not that big and even a less powerful machine can handle it without any problem.
Databases, PostgreSQL, High Availability, Open Source
158 points by wb14123 47 days ago | 41 comments
OrioleDB beta7: Benchmarks (orioledb.com)
OrioleDB is a storage extension for PostgreSQL which uses PostgreSQL's pluggable storage system.
Databases, PostgreSQL, Benchmarks, New Releases
140 points by oliverrice 48 days ago | 15 comments
Securely sending DHT22 sensor data from an ESP32 board to PostgreSQL (c410-f3r.github.io)
Let's collect data provided by a DHT22 sensor and store it asynchronously in a PostgreSQL database via WiFi using an encrypted connection. We will start with a brief introduction about the principal technologies, proceed to setting-up the necessary environment and then code our project.
IoT, ESP32, PostgreSQL, Sensors, Security
6 points by emarsden 49 days ago | 0 comments
How to Create (Lots of) Sample Time-series Data with PostgreSQL (2021) (timescale.com)
As the makers of TimescaleDB, we often need to quickly create lots of sample time-series data to demonstrate a new database feature, run a benchmark, or talk about use cases internally.
Time-series Data, PostgreSQL, Databases, Data Generation, Software
4 points by 0x54MUR41 56 days ago | 0 comments
Pg_karnak: Transactional schema migration across tenant databases (thenile.dev)
When we need to describe Nile in a single sentence, we say "PostgreSQL re-engineered for multi-tenant apps".
PostgreSQL, Database, Multi-Tenant, Cloud, SaaS
29 points by gwen-shapira 57 days ago | 5 comments
Show HN: Pgspot – Find vulnerabilities in Postgres SQL scripts (github.com/timescale)
Spot vulnerabilities in PostgreSQL extension scripts.
Security, PostgreSQL, Databases, Tools
13 points by svenklemm 57 days ago | 0 comments
Show HN: Embed an SQLite database in your PostgreSQL table (github.com/frectonz)
Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved.
Databases, PostgreSQL, SQLite, Multitenancy, Software
180 points by frectonz 60 days ago | 110 comments
SQLite vs. PostgreSQL Performance [video] (youtube.com)
Databases, Performance, Video, PostgreSQL, SQLite
28 points by thunderbong 60 days ago | 7 comments
Don't Do This with PostgreSQL (postgresql.org)
Don't use trust authentication over any TCP/IP method (e.g. host, hostssl) in any production environment.
PostgreSQL, Security, Databases
64 points by sh_tomer 66 days ago | 15 comments
PostgreSQL Conference Europe 2024 Talks (youtube.com)
PostgreSQL, Conferences, Europe, Databases
3 points by davidgomes 69 days ago | 0 comments
PgPDF: Pdf Type and Functions for Postgres (github.com/Florents-Tselai)
This extension for PostgreSQL provides a pdf data type.
Database, PostgreSQL, Data Types, PDF, Programming
97 points by fforflo 73 days ago | 55 comments
Do you need Redis? PostgreSQL does queuing, locking, and pub/sub (2021) (atomicobject.com)
Databases, PostgreSQL, Redis, Queuing, Locking
197 points by fanf2 75 days ago | 129 comments
pg_flo – Stream, transform, and re-route PostgreSQL data in real-time (pgflo.io)
The easiest way to move and transform data between PostgreSQL databases
PostgreSQL, Data Processing, Real-time Data, Databases, Software
239 points by shayonj 75 days ago | 54 comments
Why Pg_dump Is Amazing (blogspot.com)
I wrote a blog post a couple of weeks ago entitled Is pg_dump a Backup Tool? In that post, I argued in the affirmative, but also said that it's probably shouldn't be your primary backup mechanism. For that, you probably shouldn't directly use anything that is included in PostgreSQL itself, but rather a well-maintained third-party backup tool such as barman or pgbackrest.
Database Administration, PostgreSQL, Backup Tools
47 points by zdw 76 days ago | 8 comments
Why pg_dump Is Amazing (blogspot.com)
I wrote a blog post a couple of weeks ago entitled Is pg_dump a Backup Tool? In that post, I argued in the affirmative, but also said that it's probably shouldn't be your primary backup mechanism.
Databases, PostgreSQL, Tools
6 points by eatonphil 77 days ago | 0 comments