~postgresweekly | Bookmarks (156)
-
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...
-
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!...
-
PGXN v2/Architecture - PostgreSQL wiki
The Architecture of PGXN v2 — David Wheeler, and others, are working on a major update...
-
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 - Florents-Tselai/vasco: vasco: MIC & MINE statistics for Postgres
Vasco: MIC & MINE Statistics Extension — Maximal information coefficient (MIC) and maximal information-based nonparametric exploration...
-
GitHub - viggy28/pglite: postgres + sqlite = pglite
Postgres + SQLite = pglite? — Not to be confused with the PGlite WASM build of...
-
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...
-
✂️ Use Cases for Merging and Splitting Partitions With Minimal Locking in PostgreSQL 17
Use Cases for Merging and Splitting Partitions with Minimal Locking in Postgres 17 — Some interesting...
-
PostgreSQL 17 features I am most waiting for
The Postgres 17 Features I'm Most Waiting for — It’s still several months away, but Postgres...
-
Ten years of improvements in PostgreSQL's optimizer · Ryan Marcus
📊 Ten Years of Improvements in Postgres's Optimizer — “I decided to run the join order benchmark...
-
Optimize Your PostgreSQL Database | OtterTune
Improve Postgres Performance and Reduce Costs with OtterTune — Automatically tune and optimize knobs, plus get...
-
General Availability | Supabase
Supabase Declares 'General Availability' — I hadn’t noticed Supabase has been rocking ‘beta’ all this time,...
-
Postgres Roles and Privileges
Postgres Roles and Privileges — A follow along, tutorial style, guide to understanding how roles and...
-
Improved query cancellation in PostgreSQL 17 and Psycopg 3.2
Improved Query Cancellation in Postgres 17 and Psycopg 3.2 — Postgres 17 will gain some improved...
-
Awesome Postgres
Awesome Postgres: A Curated List of 200+ Libraries, Tools, and Resources — A handy, curated resource...
-
GitHub - stackframe-projects/pgmock: In-memory Postgres for unit/E2E tests
pgmock: An In-Memory Postgres for Unit/E2E Testing — No external dependencies and runs entirely within WebAssembly...
-
Building the Best PostgreSQL GUI: PopSQL Joins Timescale
Building the Best Postgres GUI? PopSQL Joins Timescale — The team behind the PopSQL collaborative SQL...
-
Compiling PostgreSQL on macOS To Test Documentation and Patches
Compiling Postgres on macOS to Test Documentation and Patches — One developer’s experience compiling and installing...
-
Protect Your PostgreSQL Database with pg_tde: Safe and Secure
Protect Your Database with pg_tde (Transparent Data Encryption) — A tech preview release of an extension...
-
POSETTE: An Event for Postgres 2024
Save the Date for POSETTE: An Event for Postgres — Wondering who will be speaking at...
-
PostgreSQL Stories: A simple query with a big problem | Render Blog
A Simple Query with a Big Problem — “Most of the time, PostgreSQL invisibly optimizes our...