Bookmarks (1191)

  • screenshot

    kyleconroy/sqlc

    sqlc 1.8: Generate Type Safe Go(lang) from SQL — You write SQL queries, run sqlc to...

  • screenshot

    Open-sourcing Datanymizer, in-flight template-driven data anonymization tool by Evrone

    Datanymizer: A Database Anonymizer with Flexible Rules — Written in Rust, this tool offers in-flight template-driven...

  • screenshot

    xo/usql

    usql 0.9: A Universal CLI for Databases — A CLI tool (written in Go) for working...

  • screenshot

    Finding the root cause of slow Postgres queries using EXPLAIN

    Finding the Root Cause of Slow Postgres Queries Using EXPLAIN — An in-depth guide on how...

  • screenshot

    TLS: Demystifying communication encryption in PostgreSQL - CYBERTEC

    TLS: Demystifying Communication Encryption in Postgres — TLS (Transport Layer Security) is a widely used technology...

  • Bruce Momjian: Postgres Blog

    JSONB Multi-Column Type Casting — I’ve been doing a lot of work with JSONB columns lately...

  • Dave Page | PostgreSQL Person of the Week

    An Interview with Dave Page — The latest in the PostgreSQL Person of the Week series...

  • screenshot

    supabase/realtime

    Supabase: Listen to Database Changes in Real Time via WebSockets — We first mentioned this project...

  • screenshot

    Creating PostgreSQL Test Data with SQL, PL/pgSQL, and Python

    Creating Test Data with SQL, PL/pgSQL, and Python — Greg posits that creating test data on...

  • ERROR: deadlock detected | Understanding deadlocks - CYBERTEC

    Understanding Deadlocks — One of the more straightforward demonstrations of what a deadlock actually is. Essentially...

  • screenshot

    ankane/pgvector

    pgvector: A Vector Similarity Search Extension for Postgres — Supports L2 distance, inner product, and cosine distance.

  • Bruce Momjian: Postgres Blog

    On Database Software Bundles — No strong point here but Bruce ponders on how commercial database...

  • Developer Productivity Metrics

    [Guide] The Truth About Developer Productivity Metrics — What you need to know to avoid weaponizing...

  • Hash Index Internals - Highgo Software Inc.

    The Internals of Hash Indexes — B-trees are the most popular type of index in Postgres...

  • screenshot

    CHAR(1) to Boolean transformation while migrating to PostgreSQL - MigOps

    A CHAR(1) to Boolean Transformation While Migrating to Postgres — Did you know Oracle Database doesn’t...

  • screenshot

    Getting Started with PostgreSQL Set Operators

    Getting Started with Set Operations — For example, UNION for bringing result sets together and INTERSECT...

  • Getting value from dynamic column in pl/PgSQL triggers? – select * from depesz;

    Can You Get a Value From a Dynamic Column in pl/PgSQL Triggers? — There’s a workaround...

  • screenshot

    Choice of Table Column Types and Order When Migrating to PostgreSQL

    When to Use NUMERIC/DECIMAL vs. Other Numeric Types — For Postgres users looking for any incremental...

  • screenshot

    Cockroach University | Cockroach Labs

    Cockroach University: Learn to Build Cloud-Native Apps — Cockroach University is a free online learning platform...

  • screenshot

    Benchmarking PostgreSQL: Setting up a RAID Array from Scratch

    As part of my work on the CTO Team here at EDB, I do daily benchmarking...

  • screenshot

    Citus Talk at CMU: Distributed PostgreSQL as an Extension

    Last month we released Citus 10 and we’ve received an overwhelming amount of positive feedback on...

  • Bruce Momjian: Postgres Blog

    This blog is about my work on the Postgres open source database, and is published on...

  • screenshot

    Cleaning up a large number of BLOBs in PostgreSQL - CYBERTEC

    PostgreSQL allows end users to store BLOBs (binary large objects) in the database. Many people use...

  • screenshot

    Getting started with QGIS, PostgreSQL and PostGIS - CYBERTEC

    Visualizing spatial data is an important task. In this mini-tutorial, you will learn how to quickly...

  • Devrim Gündüz | PostgreSQL Person of the Week

    Tags: postgresql community enterprisedb edb london friends rpm redhat fedora centos Category: Interviews Interviewed by: Andreas...

  • Bruce Momjian: Postgres Blog

    This blog is about my work on the Postgres open source database, and is published on...

  • How to run Hierarchical Queries with PostgreSQL - Highgo Software Inc.

    A hierarchical query is built upon parent-child relationship, the relationship exist in the same table or...

  • screenshot

    13 Tips to Improve PostgreSQL Database Insert Performance

    Some of these may surprise you, but all 13 ways will help you improve ingest (INSERT)...

  • screenshot

    PostgreSQL: Get member roles and permissions - CYBERTEC

    PostgreSQL provides a highly sophisticated and powerful security and permission system. It allows you to define...

  • PostgREST Documentation — PostgREST 7.0.1 documentation

    PostgREST PostgREST is a standalone web server that turns your PostgreSQL database directly into a RESTful...

  • Bruce Momjian: Postgres Blog

    This blog is about my work on the Postgres open source database, and is published on...

  • screenshot

    Standing on the Shoulders of a Giant Elephant: Upgrading Discourse to PostgreSQL 13

    When the Discourse project started, way back in 2013, the team had to pick and choose...

  • Preventing FreeBSD to kill PostgreSQL (aka OOM Killer prevention)

    There are a lot of interesting articles on how to prevent the Out of Memory Killer...

  • screenshot

    Logging of Pgpool-II on Kubernetes

    Logging is an important topic and particularly useful for troubleshooting, debugging and monitoring. Many applications have...

  • screenshot

    Speeding up SQL queries by orders of magnitude using UNION – Foxhound Systems

    SQL is a very powerful tool for querying data. It allows you to write queries against...