~postgresweekly | Bookmarks (153)
-
Identify PostgreSQL semantic issues with the plpgsql_check extension | Amazon Web Services
How to Identify Semantic Issues with plpgsql_check — plpgsql_check is a linter for statically analyzing Postgres...
-
Checking Your Privileges
Checking Your Privileges — “If you are counting on the PostgreSQL privilege system to prevent roles...
-
MobilityDB
MobilityDB 1.1: Geospatial Trajectory Data Management and Analysis Platform — Built upon Postgres and PostGIS, MobilityDB...
-
Introducing pgzx: create PostgreSQL extensions using Zig
Introducing pgzx: Create Postgres Extensions using Zig — Yes, we linked to pgzx last week, but...
-
GitHub - gajus/slonik: A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL.
Slonik v38: The Sophisticated Postgres Client for Node.js — A ‘battle tested’ framework offering strict types, detailed...
-
Inside PostGIS: Calculating Distance | Crunchy Data Blog
Inside PostGIS: Calculating Distance — Paul dives inside PostGIS’s distance calculation implementation.
-
Recovering Deleted Data From PostgreSQL Tables
Recovering Deleted Data from Postgres Tables — Transactions and backups cover most situations, but can you...
-
Will PostgreSQL ever change its license? | Jonathan Katz
Will Postgres Ever Change Its License? — The recent announcement that Redis will be dropping the...
-
Webinar: Automating Postgres Index Selection Using Constraint Programming
How to Automate Postgres Index Selection Using the CP-SAT Solver — Learn about the Constraint Programming...
-
GitHub - xataio/pgzx: Create PostgreSQL extensions using Zig.
pgzx: Create Postgres Extensions using Zig — If you’re familiar with pgrx as a way to...
-
How Figma's Databases Team Lived to Tell the Scale | Figma Blog
Figma's Nine Month Journey to Shard Its Postgres Stack — In a quest to unlock '(nearly)...
-
Product Tour | OtterTune
OtterTune Optimizes Your RDS and Aurora Postgres Databases — No mock-ups or fake screenshots — use...
-
Look ma, I wrote a new JIT compiler for PostgreSQL – Pinaraf's website
'Look Ma, I Wrote a New JIT Compiler for Postgres' — Before you get too excited,...
-
Distributed queries for pgvector | Jonathan Katz
Distributed Queries for pgvector — Distributing a workload across multiple databases provides another way to scale...
-
Postgres Performance Boost: HOT Updates and... | Crunchy Data Blog
Postgres Performance Boost: HOT Updates and Fill Factor — There’s a way for Postgres to only...
-
When Postgres is not enough: performance evaluation of PostgreSQL vs. Distributed DBMSs
When Postgres is Not Enough? Performance Evaluation of Postgres vs. Distributed DBMSs — An empirical study...
-
Release v3.0.0 · wal-g/wal-g
WAL-G 3.0: Database Archive Restoration Tool — A tool for database archival and restoration for Postgres,...
-
dalibo / transqlate · GitLab
transqlate: Transpile SQL into the PostgreSQL Dialect — Focusing on Oracle-flavored SQL, this Go-powered tool (which...
-
Speed up PostgreSQL® pgvector queries with indexes | EverSQL
Speeding Up pgvector Queries with Indexes — If you’re using Postgres and pgvector to work with...
-
Enforcing join orders in PostgreSQL
Enforcing Join Orders in Postgres — With SQL being a declarative language, you'd reasonably expect Postgres...
-
How to use PostgreSQL for (military) geoanalytics tasks · Taras Kloba's
🌐 Using Postgres for (Military) Geoanalytics Tasks — If you dislike military scenarios, skip this, but otherwise...
-
Writing a Postgres Logical Replication System in Golang
Creating a Postgres Logical Replication System in Go — The folks behind the (Go-powered) Dolt database...
-
Path To Citus Con, for developers who love Postgres
▶ The Path to Citus Con: A Podcast for Postgres — The Citus Con event itself is...
-
Hello DBOS - Announcing DBOS Cloud
Postgres Creator Introduces His New Database Startup — MIT professor Mike Stonebraker was a principal architect...