VirtualTam's bookmarks

1. Why would I use DuckDB for that?

   2025-06-15
   database/duckdb database/postgresql programming/python programming/sql

   Permalink
   • Analyzing open data with DuckDB
2. PostgreSQL at Scale: Database Schema Changes Without Downtime

   2025-06-12
   database/migration database/postgresql database/schema

   Permalink
   • Safe Operations For High Volume PostgreSQL (Archived 2020-04-14)
3. Time to Better Know The Time in PostgreSQL

   2025-05-16
   database/postgresql programming/sql time

   Permalink
4. Martin - PostGIS, MBtiles and PMtiles tile server

   2025-05-16
   database/postgresql geography/gis map programming/rust

   Permalink
5. PgAssistant - Understand and optimize PostgreSQL database performance

   2025-05-10
   database/postgresql performance programming/javascript programming/python

   Permalink
6. Patroni - A Template for PostgreSQL HA with ZooKeeper, etcd or Consul

   2025-03-30
   database/postgresql distributed-system/cluster distributed-system/high-availability network/reverse-proxy/haproxy programming/python

   Permalink
7. Time Series Benchmark Suite - A tool for comparing and evaluating databases for time series data

   2025-03-30
   database database/postgresql observability/time-series observability/time-series/influxdb performance/benchmark programming/go programming/sql

   Permalink
   • TSBS Documentation
8. PostgreSQL - What is a valid use case for using TIMESTAMP WITHOUT TIME ZONE?

   2025-01-14
   database/postgresql time/timezone

   Permalink
   • Date/Time Types
   • Should I store UTC timestamps or localtime for shifts
9. pgrx - Build Postgres Extensions with Rust!

   2024-12-25
   database/postgresql programming/rust

   Permalink
   • dalibo/postgresql_anonymizer
   • daamien/pgrx-tuto
10. CloudNativePG - A Kubernetes operator that covers the full lifecycle of a highly available PostgreSQL database cluster

    2024-12-03
    database/postgresql linux/container/kubernetes programming/go programming/python

    Permalink
    • cloudnative-pg/cloudnative-pg
    • CloudNativePG Tutorial: Manage Multiple Cloud-Native Databases
    • Barman, Backup and Recovery Manager for PostgreSQL
11. EphemeraSearch - Your ancestors had mail

    2024-12-03
    database/postgresql genealogy history image/optical-character-recognition linux/container/kubernetes mail/postcard programming/go search-engine

    Permalink
    • About EphemeraSearch
    • EphemeraSearch on Github
    • Enix Live Show - Comment CNPG et Kubernetes ont sauvé ma startup !
    • PoZoK - PostgreSQL on ZFS on Kubernetes
12. sqlfluff - A modular SQL linter and auto-formatter with support for multiple dialects and templated code

    2024-11-24
    database/mysql database/postgresql database/sqlite programming/python programming/sql static-analysis/lint

    Permalink
    • Configuration
    • Rules Reference
13. pg_duckdb - A Postgres extension that embeds DuckDB's columnar-vectorized analytics engine and features

    2024-11-20
    database/duckdb database/postgresql programming/apache-parquet programming/c++ programming/json programming/python programming/sql

    Permalink
    • DuckDB - PostgreSQL Extension
    • Querying Postgres Tables Directly from DuckDB
14. psqlrc - PostgreSQL command-line client configuration

    2024-11-19
    command-line/pager database/postgresql

    Permalink
    • How To Customize the PostgreSQL Prompt with psqlrc on Ubuntu 14.04
    • datachomp//dotfiles - psqlrc
    • okbob/pspg - Pager specialized for tabular data
15. What I Wish Someone Told Me About Postgres

    2024-11-19
    command-line database/postgresql programming/csv programming/json programming/sql

    Permalink
16. Is pg_dump a Backup Tool?

    2024-11-03
    backup database/postgresql programming/sql

    Permalink
    • Why pg_dump Is Amazing
    • EnterpriseDB/barman - Backup and Recovery Manager for PostgreSQL
    • pgbackrest/pgbackrest - Reliable PostgreSQL Backup & Restore
17. PostgreSQL Anonymizer

    2024-05-23
    database/postgresql privacy/gdpr programming/rust security/anonymization

    Permalink
    • dalibo/postgresql_anonymizer
    • Introducing PostgreSQL Anonymizer
    • 8 Anonymization Strategies with PostgreSQL
    • Data anonymization with Postgres
18. How to use PostgreSQL for (military) geoanalytics tasks

    2024-03-31
    country/russia country/ukraine database/postgresql geography/gis map nasa/earthdata war

    Permalink
    • From Map to Reality: Using PostGIS in Warfare (PDF)
    • NASA Earthdata - Full and open access to NASA’s collection of Earth science data for understanding and protecting our home planet
    • Visible Infrared Imaging Radiometer Suite (VIIRS) Active Fire detection
    • PostgreSQL - GiST - Generalized Search Tree
    • PostgreSQL - SP-GiST - Space-partitioned GiST
    • H3 - Hexagonal hierarchical geospatial indexing system
    • zachasme/h3-pg - PostgreSQL bindings for H3
19. postgres_lsp - Language Server for PostgreSQL

    2023-12-08
    database/postgresql programming-language programming/sql

    Permalink
    • Postgres Language Server: implementing the Parser
    • Hacker News announcement thread
20. Fly.io - Reliability: It’s Not Great

    2023-07-22
    database/postgresql distributed-system hashicorp/consul hashicorp/nomad hashicorp/vault linux/container/docker

    Permalink