Bookmarks (1010)

  • screenshot

    Re-Introducing Hash Indexes in PostgreSQL

    Re-Introducing Hash Indexes in Postgres — Billed as the ‘ugly duckling of index types’, this is...

  • screenshot

    leafo/pgmoon

    PGMoon 1.12.0: A Pure Lua Postgres Driver for Use in OpenResty and More

  • screenshot

    vapor/postgres-nio

    PostgresNIO: Non-Blocking, Event-Driven Client for Swift

  • pg_back 1.10 released

    pg_back 1.10: A Bash Script for Dumping Databases to Files — Essentially a wrapper around pg_dumpall...

  • The mapping of oid and relfilenode in PG - Highgo Software Inc.

    The Mapping of oid and relfilenode — Technical ‘under the covers’ stuff about how the location...

  • Hosting PostgreSQL on a t4g Graviton2 ARM Instance on AWS EC2

    Hosting Postgres on an AWS EC2 t4g Graviton2 ARM Instance — Sure, AWS has its managed...

  • Sysbench: in-memory Postgres, Postgres is boring

    Sysbench: In-Memory Postgres, Postgres Is Boring — Sometimes no news is good news. “I am happy...

  • screenshot

    12 things you need to know about time-series data

    ⏰ 12 Things You Need to Know About Time-Series Data — Get our top advice and...

  • How to limit rows to at most N per category – fix – select * from depesz;

    How to Limit Rows to At Most N Per Category (Take Two) — Several issues ago...

  • screenshot

    Using R in Postgres for Logistic Regression Modeling

    Using R in Postgres for Logistic Regression Modeling — Continuation of a ‘Postgres for Data Science’...

  • Waiting for PostgreSQL 14 – Add idle_session_timeout. – select * from depesz;

    Waiting for Postgres 14: Add idle_session_timeout — Have sessions terminated when they’re been waiting around for...

  • screenshot

    Amazon RDS for PostgreSQL Supports New Minor Versions 12.5, 11.10, 10.15, 9.6.20, and 9.5.24

    Amazon RDS for PostgreSQL Supports 12.5, 11.10, 10.15, 9.6.20, and 9.5.24 — Support has also been...

  • screenshot

    Efficient Search in Rails with Postgres

    Free eBook: Efficient Search in Rails with Postgres — Speed up a search query from seconds...

  • PostgreSQL: int4 vs. float4 vs. numeric | data types - CYBERTEC

    int4 vs. float4 vs. numeric — Postgres offers many different data types and this post focuses...

  • screenshot

    All-in-one Website & Database Backups Automation

    All-In-One and Automated Website & Database Backups — Remove backups from your to-do list in 2...

  • screenshot

    Performance impact of idle PostgreSQL connections | Amazon Web Services

    The Performance Impact of Idle Postgres Connections — Connections to a Postgres database consume resources even...

  • PostgreSQL is the DBMS of the Year 2020

    Postgres is DB-Engines' 'DBMS of the Year 2020' — DB-Engines is a popular DBMS knowledge base...

  • Security Best Practices for PostgreSQL

    Security Best Practices for PostgreSQL — Here is a framework and a series of recommendations to...

  • screenshot

    The shibboleth of PostgreSQL- (how to pronounce it correctly) - Cybertec

    The Shibboleth of 'PostgreSQL' — A shibboleth is a custom or tradition (which can be as...

  • screenshot

    Stop worrying about PostgreSQL locks in your Rails migrations

    Stop Worrying About Postgres Locks in Your Rails Migrations — Most common pitfalls that could happen...

  • screenshot

    Loading Data into PostGIS: An Overview

    Loading Data into PostGIS: An Overview — PostGIS is a popular addition for Postgres when you...

  • screenshot

    Ensuring consistent performance after major version upgrades with Amazon Aurora PostgreSQL Query Plan Management | Amazon Web Services

    Ensuring Consistent Performance After Version Upgrades with Amazon Aurora PostgreSQL Query Plan Management — You only...

  • Pavel Stehule's blog: redirect query result from psql to LibreOffice Calc by using clipboard

    Redirect Query Result from psql to LibreOffice Calc — Let’s say you’ve got the results of...

  • screenshot

    PostgreSQL 13 Benchmark: Memory Speed vs. TPS

    A Postgres 13 Benchmark: Memory Speed vs. TPS — Does something as simple as running 2133MHz...

  • screenshot

    supabase/postgres-deno

    postgres-deno: A Deno Postgres Extension — Run TypeScript in your Postgres functions and triggers. Still very...

  • screenshot

    Postgres.ai / Database Lab Engine – instant database clones to boost development

    Database Lab Engine 2.1: Instant Clones of Large Postgres Databases for Dev Environments — Provision independent...

  • screenshot

    GeorgeKaraszi/ActiveRecordExtended

    ActiveRecordExtended: Add Extended Postgres Functionality to Ruby and Rails Apps — A continuation of work done...

  • Devrim Gunduz's PostgreSQL Blog

    RPM Repository for Unsupported PostgreSQL Releases — “If you are using an unsupported PostgreSQL version or...

  • screenshot

    aiven/pghoard

    pgHoard 2.2: Postgres Backup and Restore Tooling

  • Highly Available PostgreSQL with Physical (Streaming) Replication

    Highly Available PostgreSQL with Physical Replication — This white paper discusses the scenarios when designing a...

  • screenshot

    Seamless MongoDB to PostgreSQL migration

    A Seamless MongoDB to PostgreSQL Migration — Coinbase is a large digital currency exchange so having...

  • Monitoring Postgres EXPLAIN plans · pganalyze

    Wondering How You Should Optimize a Particular Query? — pganalyze uses auto_explain to automatically collect EXPLAIN...

  • Benchmark V4 Uuid Generation In Postgres

    A V4 UUID Generation Benchmark — uuid_generate_v4 vs gen_random_uuid.. fight! And the result is not even close.

  • screenshot

    Using PostgreSQL Aggregate Functions in YugabyteDB to Analyze COVID-19 Data - The Distributed SQL Blog

    Using Postgres Aggregate Functions in YugabyteDB to Analyze COVID-19 Data — Yugabyte is a Postgres-compatible ‘NewSQL’...

  • screenshot

    BLOB cleanup in PostgreSQL - CYBERTEC | Data Science & PostgreSQL

    Cleaning Up the BLOBs — BLOB is the SQL standard’s binary string type which differs slightly...

  • screenshot

    When to use Hyperscale (Citus) to scale out Postgres

    When to Use Hyperscale (Citus) to Scale Out Postgres — Citus by Citus Data is now...

  • screenshot

    The Architecture of a Distributed SQL Database

    ▶️ Future of Database Architecture is Postgres Compatible — The language and the tools that you...

  • screenshot

    Replacing Lines of Code with 2 Little Regexs in Postgres

    Replacing Lines of Code with 2 Little Regexes in Postgres — I love them but the...

  • Restoring individual postgres table

    Restoring An Individual Postgres Table — What if you want to restore an individual table from...

  • screenshot

    Upgrading and updating PostgreSQL - Cybertec

    Upgrading and Updating Postgres — Updating (such as from 12.0 to 12.1, say) is a different...

  • Bulk loading into PostgreSQL: Options and comparison - Highgo Software Inc.

    Comparing Options for Bulk Loading into Postgres — A comparison of COPY, \copy, file_fdw, and pg_bulkload...

  • screenshot

    pgtop – a top clone for PostgreSQL

    A Look at pgtop, A top Clone for Postgres — Another way to look at currently...

  • screenshot

    andywer/pg-listen

    pg-listen: Postgres LISTEN and NOTIFY for Node.js — If you’re using Node.js and wish to use...

  • Blog @ RustProof Labs

    PostGIS Trajectory Tricks: Playing with Space and Time — A fun, yet practical, post demonstrating how...

  • https://www.phrozen.io/resources/paper/41df297b-cfe3-43ec-88e8-0686e5548dd5

    How a Postgres Extension Shellcode Execution Exploit Works — This would take a little work to pull...

  • screenshot

    PostgreSQL Configuration Changes You Need to Make Post-Installation - Percona Database Performance Blog

    Postgres Configuration Changes to Make Post-Installation — So you’ve installed Postgres onto your machine, and you...

  • screenshot

    How pgBackRest is Addressing Slow PostgreSQL WAL Archiving Using Asynchronous Feature - Percona Database Performance Blog

    How pgBackRest is Addressing Slow WAL Archiving — pgBackRest is a backup and restore tool. This...

  • screenshot

    Running PgBouncer on AWS Elastic Container Service

    Running PgBouncer on AWS Elastic Container Service — RevenueCat has an Aurora-based database, wanted a connection...

  • screenshot

    Trigger for checking a given value before INSERT or UPDATE on PostgreSQL

    How to Write a Trigger for Checking a Given Value Before INSERT or UPDATE — Seen...

  • Build a backend with TypeScript, PostgreSQL and Prisma | Series

    Building a Modern Backend with TypeScript, PostgreSQL and Prisma — A four part written/video series focused...