~postgresweekly | Bookmarks (153)
-
Hacking on PostgreSQL is Really Hard
Hacking on PostgreSQL is Really Hard — Robert has consistently been in the top ten committers...
-
GitHub - HexaCluster/pgdsat: PostgreSQL Database Security Assessment Tool
pgdsat: A Postgres Database Security Assessment Tool — Checks around 70 security controls on your clusters...
-
Saturation Arithmetic with a PostgreSQL Extension
Saturation Arithmetic with a Postgres Extension — Saturation arithmetic is the concept of bounding the results...
-
cursor_tuple_fraction and the PostgreSQL JDBC driver
cursor_tuple_fraction and PostgreSQL JDBC — Laurenz had me at the first sentence: “This article is a...
-
The Notifier Pattern for Applications That Use Postgres
The Notifier Pattern for Apps That Use Postgres — Brandur is a big fan of Postgres’s...
-
How not to change PostgreSQL column type | boringSQL
How Not to Change Postgres Column Type — ALTER TABLE .. ALTER COLUMN is fine in...
-
Understanding Postgres Database Schemas and the search_path
Understanding Postgres Schemas and search_path — The developers of the Dolt database have a lot of...
-
What's new in pgvector v0.7.0
What's New in pgvector v0.7 — We mentioned pgvector’s rather exciting v0.7 release last week, but...
-
PG Phriday: Papa's Got a Brand New RAG
Papa's Got a Brand New RAG — RAG (Retrieval-Augmented Generation) is a technique used alongside large...
-
Crunchy Bridge for Analytics: Your Data Lake in... | Crunchy Data Blog
Crunchy Bridge for Analytics: Your Data Lake in Postgres? — Marco ponders: “What if you could...
-
The 150x pgvector speedup: a year-in-review | Jonathan Katz
The 150x pgvector Speedup: A Year in Review — pgvector provides Postgres with extra data types,...
-
Postgres Bloat Minimization
Postgres Bloat Minimization — Tables occupying more space than expected is a common cause of complaint,...
-
PeerDB: Fast, Simple, Cost-effective Postgres Replication
PeerDB: A Simple, Fast Way to Replicate Postgres Data Elsewhere — A data replication system built...
-
GitHub - tembo-io/pg_tier: Postgres Extension written in Rust, to enable data tiering to AWS S3
pg_tier: Tier Data to External Amazon S3 Storage — Once data becomes older or much less...
-
Squawk — a linter for Postgres migrations
Squawk: A Linter for Postgres Migrations — Prevent unexpected downtime caused by database migrations and encourage...
-
https://nextgres.com/res/20240419-The-Future-of-MySQL-is-Postgres.pdf
PDF: The Future of MySQL is Postgres — The title of this slidedeck certainly caught my eye!...
-
Release v7.0.0 · salsita/node-pg-migrate
node-pg-migrate 7.0: Database Migration Management for Postgres — Lots of cleanups and refactoring from the project’s...
-
GitHub - georgia-tech-db/pgvector-remote
pgvector-remote: A pgvector Fork to Work with Remote Vectors — Pinecone only, for now. There's a blog...
-
ParadeDB - Postgres for Search and Analytics
ParadeDB: An Elasticsearch Alternative Built on Postgres — Taking the common ‘cloud offering + open source...
-
GitHub - lacanoid/pgddl: DDL eXtractor functions for PostgreSQL (ddlx)
pgddl / ddlx: DDL EXtractor Functions — An SQL-only extension that can create SQL DDL (e.g....
-
An unfair advantage: multi-tenant queues in Postgres – Nextra
Creating Multi-Tenant Queues — Spinning up a basic queue on Postgres is reasonably easy, but what...
-
PGXN v2/Architecture - PostgreSQL wiki
The Architecture of PGXN v2 — David Wheeler, and others, are working on a major update...
-
GitHub - noborus/trdsql: CLI tool that can execute SQL queries on CSV, LTSV, JSON, YAML and TBLN. Can output to various formats.
trdsql: Tool to Execute SQL Queries Upon Text-Based Data — A CLI tool that can execute...
-
GitHub - viggy28/pglite: postgres + sqlite = pglite
Postgres + SQLite = pglite? — Not to be confused with the PGlite WASM build of...