Bookmarks (152)

  • screenshot

    SQL query optimization: a comprehensive developer's guide

    SQL Query Optimization: A Comprehensive Developer's Guide — A bumper packed post digging into the optimization...

  • pgexporter | pgexporter

    pgexporter 0.5: Prometheus Exporter for Postgres — As of v0.5, it’s targeting Postgres 12 and higher...

  • screenshot

    GitHub - kristiandupont/schemalint: Lint database schemas

    Schemalint 1.1: A Linter for Postgres Schemas — A linter that lets you raise errors on...

  • Release libpqxx 7.9.0: important fixes and new features · jtv/libpqxx

    libpqxx 7.9: The Official C++ Client API for Postgres — It’s a pretty big release, says...

  • PostgreSQL Anonymizer

    PostgreSQL Anonymizer: Data Masking for Postgres — Rather than simply anonymizing dumps, say, this extension takes...

  • Deciphering PostgreSQL Encryption: A Beginner's Guide - Highgo Software Inc.

    Deciphering Postgres Encryption: A Beginner's Guide — A (very) casual look at six levels of encryption...

  • Last Updated Columns With Postgres

    Creating 'Last Updated' Columns in Postgres — If you want an automatically updated updated_at timestamp column...

  • A story of a spectacular success - Intro to AWS RDS database migration series

    A Story of a Spectacular Success in Migrating to AWS RDS — Being based on EC2...

  • What's faster, COUNT(*) or COUNT(*) with LIMIT in SQL? Let's check

    What's Faster? COUNT(*) or COUNT(*) with LIMIT — SQL guru Lukas Eder looks at the execution...

  • screenshot

    AI-Powered Automatic PostgreSQL & MySQL Tuning | OtterTune

    Auto Optimize Your RDS or Aurora Postgres Databases With AI — Need help optimizing Postgres knobs,...

  • pgagroal-cli gains JSON output

    pgagroal-cli Gains JSON Output Support — pgagroal is a high performance connection pool for Postgres and...

  • Pavel Stehule's blog: new extension pgmeminfo

    pgmeminfo: A New Extension to Investigate Memory Usage — Pavel shows off his new extension which...

  • (plausible) random geography generation with postgis: fluviation

    (Plausible) Random Geography Generation with PostGIS: Fluviation — Geospatial stuff tends to go over my head,...

  • screenshot

    Connecting to Postgres With psql and .pg_service.conf

    Connecting to Postgres with psql and .pg_service.conf — Forgot how to connect to your Postgres services?...

  • pg_analytics: Transforming Postgres into a Fast OLAP Database - ParadeDB

    pg_analytics: Transforming Postgres into a Fast OLAP Database — Some interesting work from the folks over...

  • screenshot

    PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released!

    PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released — All supported versions get updates to fix...

  • screenshot

    What’s new in the Postgres 16 query planner / optimizer

    What’s New in the Postgres 16 Query Planner / Optimizer — Query planner improvements rarely make...

  • screenshot

    Ibis

    Ibis 8.0: A Dataframe Framework for Python — Provides a universal interface for data wrangling in...

  • screenshot

    Postgres is Enough

    Postgres is Enough

  • screenshot

    Implementing System-Versioned Tables in Postgres

    Implementing System-Versioned Tables in Postgres — There’s no official support for system-versioned tables in Postgres, though...

  • PlanSplainer

    PlanSplainer: A New Way to Visualize Query Plans? — explain.depesz.com is perhaps the best known Web-based...

  • screenshot

    GitHub - allaboutapps/integresql: IntegreSQL manages isolated PostgreSQL databases for your integration tests.

    IntegreSQL: API to Manage Isolated Postgres Databases for Testing — Provides a RESTful JSON API for...

  • screenshot

    GitHub - f-prime/pgtera: A PostgreSQL extension for rendering the Tera HTML templating language.

    PGTera: Extension to Render Tera HTML Templates — Tera is a Jinja2-inspired template engine for Rust,...

  • screenshot

    GitHub - theory/pgenv: PostgreSQL binary manager

    pgenv: Postgres Binary Manger for the Shell — Makes it simpler to build and run different...

  • screenshot

    GitHub - directus/directus: The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.

    Directus 10.9: Wrap an SQL Database with a Real-Time GraphQL and REST API — A Node.js-based system...

  • screenshot

    Load StackOverflow’s StackExchange data in Postgresql®

    How to Load Stack Overflow's StackExchange Data into Postgres — It’s an interesting process in itself,...

  • screenshot

    JSON and SVG from PostGIS into Google Sheets | Crunchy Data Blog

    Getting JSON and SVG from PostGIS into Google Sheets — A walk through using pg_featureserv to...

  • screenshot

    Multi-Database Support in DuckDB

    DuckDB's Multi-Database Support — DuckDB is an SQLite-esque in-process DBMS but focused on OLAP use cases....

  • screenshot

    Instant Realtime GraphQL APIs on PostgreSQL database

    Instant Realtime GraphQL APIs on PostgreSQL with Hasura — Connect Hasura to your PostgreSQL database and get...

  • screenshot

    extension-ecosystem-jobs-tools.md

    Towards an Ideal Postgres Extension Ecosystem — Tembo hired David Wheeler, creator of PGXN, to work...

  • screenshot

    GitHub - cybertec-postgresql/pg_show_plans: Show query plans of all currently running SQL statements

    pg_show_plans: Show Query Plans of All Running Statements — Lets you get live access via SELECT...

  • screenshot

    Partitioning Postgres tables by timestamp based UUIDs

    Partitioning Postgres Tables by Timestamp Based UUIDs — A story from the Elixir forum about partitioning...

  • screenshot

    pgvector 0.6.0: 30x faster with parallel index builds

    pgvector 0.6.0: Now ~30x Faster with Parallel Index Builds — The pgvector vector similarity search extension...

  • screenshot

    How to use PostgreSQL® SUBSTRING

    🍕 How to Use SUBSTRING — String slicing and dicing.. along with a little pizza, in this case.

  • screenshot

    POSETTE: An Event for Postgres 2024

    POSETTE: Citus Con Renames for 2024 — Microsoft has run the virtual Citus Con event for...

  • screenshot

    Tuning Autovacuum for best Postgres performance

    eBook: Tuning Autovacuum for Best Postgres Performance — Learn about tuning settings for scheduling and performance,...

  • pgmoneta

    pgmoneta: A Backup / Restore Solution for Postgres — Formerly a Red Hat project, but now...

  • screenshot

    One PID to Lock Them All: Finding the Source of... | Crunchy Data Blog

    One PID to Lock Them All: Finding the Source of the Lock — One process can...

  • screenshot

    GitHub - fabianlindfors/reshape: An easy-to-use, zero-downtime schema migration tool for Postgres

    Reshape 0.7: A Zero-Downtime Schema Migration Tool — During a migration, Reshape ensures both the old...

  • screenshot

    GitHub - laurenz/oracle_fdw: PostgreSQL Foreign Data Wrapper for Oracle

    oracle_fdw: A Foreign Data Wrapper for Oracle Database — Provides efficient access to Oracle databases, including...

  • screenshot

    GitHub - supabase/supa_audit: Generic Table Auditing

    supa_audit: Generic Table Auditing for Postgres — A generic solution for tracking changes to tables’ data...

  • screenshot

    Postgres FM | pgvector

    ▶  Jonathan Katz on pgvector — Postgres core team member Jonathan Katz went on the Postgres.fm podcast...

  • screenshot

    GitHub - ANXS/postgresql: Fairly full featured Ansible role for Postgresql.

    A 'Fairly Full Featured' Ansible Role for Postgres — An Ansible 2.4+ role that installs and...

  • Apache AGE

    Apache AGE 1.5rc: A Graph Extension for Postgres — AGE provides graph database functionality (by way...

  • screenshot

    Crunchy Bridge - Managed, Cloud Postgres

    ❤️ Postgres — You need a database provider that loves Postgres as much as you do. We'll...

  • screenshot

    Happy New Year: GPT in 500 lines of SQL - EXPLAIN EXTENDED

    Implementing GPT in 500 Lines of SQL — When an article pitches itself as demonstrating ‘a...

  • screenshot

    Optimizing PostgreSQL functions with preloaded libraries

    Optimizing Postgres Functions with Preloaded Libraries — Thanks to extensions, it’s possible to write Postgres functions...

  • screenshot

    Waiting for Postgres 17: Incremental base backups

    ▶  Waiting for Postgres 17: Incremental Base Backups — Walking through the incremental backup feature committed to...

  • Postgres password encryption without leaking credentials

    Password Encryption Without Leaking Credentials — Logs and proxies can sometimes open up unexpected holes into...

  • Steampipe | select * from cloud;

    Steampipe: Query Your Cloud Services with SQL — Use SQL to query and even join across...