Hacker News with Generative AI: PostgreSQL

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

172 points by frectonz 2 days ago | 108 comments

SQLite vs. PostgreSQL Performance [video] (youtube.com)

Databases, Performance, Video, PostgreSQL, SQLite

28 points by thunderbong 2 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 9 days ago | 15 comments

PostgreSQL Conference Europe 2024 Talks (youtube.com)

PostgreSQL, Conferences, Europe, Databases

3 points by davidgomes 11 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 15 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 17 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 18 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 18 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 20 days ago | 0 comments

Show HN: Pg_mooncake – Delta/Iceberg columnstore tables in Postgres (github.com/Mooncake-Labs)
pg_mooncake is a PostgreSQL extension that adds native columnstore tables with DuckDB execution.

PostgreSQL, Databases, Columnstore, Open Source, Performance

25 points by sunzhousz 22 days ago | 9 comments

Pg_analytics has switched to PostgreSQL license (github.com/paradedb)
pg_analytics (formerly named pg_lakehouse) puts DuckDB inside Postgres. With pg_analytics installed, Postgres can query foreign object stores like AWS S3 and table formats like Iceberg or Delta Lake. Queries are pushed down to DuckDB, a high performance analytical query engine.

Database, PostgreSQL, Analytics, Open Source

69 points by philippemnoel 22 days ago | 13 comments

pg_duckdb beta release: Even faster analytics in Postgres (motherduck.com)
In August, we announced the pg_duckdb extension, a collaborative open-source project with Hydra, DuckDB Labs, and MotherDuck. pg_duckdb is a PostgreSQL extension that integrates DuckDB's analytics engine directly into PostgreSQL, allowing for rapid analytical queries alongside traditional transactional workloads.

Databases, Open Source, PostgreSQL, Analytics

11 points by jeltz 28 days ago | 1 comments

Bulk optimization of queries in Postgres (substack.com)

Database Optimization, PostgreSQL, Performance

78 points by Explain_PS 31 days ago | 7 comments

MVCC – the part of PostgreSQL we hate the most (2023) (cs.cmu.edu)
There are a lot of choices in databases (897 as of April 2023). With so many systems, it’s hard to know what to pick! But there is an interesting phenomenon where the Internet collectively decides on the default choice for new applications. In the 2000s, the conventional wisdom selected MySQL because rising tech stars like Google and Facebook were using it. Then in the 2010s, it was MongoDB because non-durable writes made it “webscale“.

Databases, PostgreSQL, Technology, Trends

382 points by virtualwhys 32 days ago | 137 comments

The Part of PostgreSQL We Hate the Most (2023) (cs.cmu.edu)
There are a lot of choices in databases (897 as of April 2023). With so many systems, it’s hard to know what to pick! But there is an interesting phenomenon where the Internet collectively decides on the default choice for new applications. In the 2000s, the conventional wisdom selected MySQL because rising tech stars like Google and Facebook were using it. Then in the 2010s, it was MongoDB because non-durable writes made it “webscale“.

Databases, PostgreSQL, Technology Trends

51 points by thunderbong 32 days ago | 1 comments

Why does everyone run ancient Postgres versions? (neon.tech)
Most Postgres users won’t upgrade to Postgres 17, but why?

Databases, PostgreSQL, Software, Technology

265 points by davidgomes 35 days ago | 436 comments

A video course on PostgreSQL – Mastering Postgres (masteringpostgres.com)
Mastering Postgres is a comprehensive video course that will help you level up your applications and your career.

PostgreSQL, Databases, Video Courses, Education, Programming

7 points by mike 37 days ago | 0 comments

PostgreSQL Streaming Replication (WAL); What It Is and How to Configure One (mindhub365.com)
Streaming replication in PostgreSQL is an efficient method for maintaining a near real-time replica of a primary database on one or more standby servers.

PostgreSQL, Databases, Replication, High Availability

168 points by thunderbong 40 days ago | 39 comments

Show HN: OneSparse – Open Source Accelerated Sparse Linear Algebra for Postgres (github.com/OneSparse)
OneSparse Postgres extends the PostgreSQL object relational database with the state-of-the-art SuiteSparse:GraphBLAS high performance dense/sparse linear algebra library.

Open Source, Databases, PostgreSQL, Linear Algebra, Performance

13 points by michelpp 52 days ago | 3 comments

Show HN: PGT-Proxy – A PostgreSQL Proxy in 277 Lines of Rust (github.com/ambarltd)
PostgreSQL TLS Proxy is an intermediary server to easily and securely connect TLS enabled PG clients to TLS enabled PG servers.

PostgreSQL, Rust, Open Source, Databases, Networking

10 points by galeaspablo 55 days ago | 0 comments

PostgreSQL 17 (postgresql.org)
The PostgreSQL Global Development Group today announced the release of PostgreSQL 17, the latest version of the world's most advanced open source database.

Databases, Open Source, New Releases, PostgreSQL

661 points by jkatz05 56 days ago | 148 comments

PostgreSQL 17.0 Release Notes (postgresql.org)
PostgreSQL 17 contains many new features and enhancements, including:

Databases, New Releases, PostgreSQL

5 points by davidgomes 56 days ago | 0 comments

pgroll: PostgreSQL zero-downtime migrations made easy (github.com/xataio)
pgroll is an open source command-line tool that offers safe and reversible schema migrations for PostgreSQL by serving multiple schema versions simultaneously.

Database, Open Source, PostgreSQL, DevOps, Tools

121 points by tosh 60 days ago | 5 comments

Sharding and Scaling PostgreSQL, No Citus (pg-sharding.tech)

PostgreSQL, Databases, Scaling, Performance

12 points by rkhapov 64 days ago | 2 comments

Show HN: Parse your Postgres queries into a fully-typed AST in TypeScript (github.com/pg-nano)
Parse your Postgres queries into a 100% type-safe AST (powered by libpg_query).

TypeScript, Databases, PostgreSQL, Software, Open Source

116 points by aleclarsoniv 64 days ago | 21 comments

Hybrid Search with PostgreSQL and Pgvector (jkatz05.com)
A key metric when evaluating vector similarity search algorithms is “recall” - which measures the relevancy of the returned search results.

Database, Search, PostgreSQL, Vector Search, Algorithms

35 points by samwillis 64 days ago | 1 comments

Intel Demonstrates Up to 48% Improvement for AVX-512 Optimized PostgreSQL (phoronix.com)
With the upcoming PostgreSQL 17 database server release there is some initial AVX-512 optimizations that are looking quite nice according to Intel's findings.

PostgreSQL, Database Performance, Optimization, AVX-512, Intel

5 points by rbanffy 69 days ago | 0 comments

Intel Demonstrates Up to 48% Improvement for AVX-512 Optimized PostgreSQL (phoronix.com)
With the upcoming PostgreSQL 17 database server release there is some initial AVX-512 optimizations that are looking quite nice according to Intel's findings.

PostgreSQL, Database Performance, AVX-512, Intel, Optimization

4 points by pella 70 days ago | 0 comments

Haskell Postgres Stored Procedures (github.com/ed-o-saurus)
This project is a "procedural language" extension of PostgreSQL allowing the execution of code in Haskell within SQL code.