VirtualTam's bookmarks
33 bookmarks found
-
Is pg_dump a Backup Tool?
2024-11-03 - Why pg_dump Is Amazing
- EnterpriseDB/barman - Backup and Recovery Manager for PostgreSQL
- pgbackrest/pgbackrest - Reliable PostgreSQL Backup & Restore
-
- 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
-
Fly.io - Reliability: It’s Not Great
2023-07-22 -
- Postgres Full Text Search vs the rest (MeiliSearch, OpenSearch/Elasticsearch, SQlite FTS, Typesense)
- Optimizing Full Text Search with Postgres tsvector Columns and Triggers
- Word separators for Postgres full text search with Rails
- Using PostgreSQL Full Text Search With Golang
- PostgreSQL: Full Text Search
- PostgreSQL: Preferred Index Types for Text Search
-
jackc/pgx - PostgreSQL Driver and Toolkit
2023-07-04 - Getting started with
pgx - https://donchev.is/post/working-with-postgresql-in-go-using-pgx/
- jackc/pgx/v5/pgtype - Map between all common base types directly between Go and PostgreSQL
- jackc/pgx/v5/pgxpool - Concurrency-safe connection pool for
pgx - scany/v2/pgxscan - Scan data into Go structs and other composite types
- Bulk INSERT in Postgres in GO using pgx
- Postgres table batch updates using golang pgxpool not reflected in database
- pgx.Conn can see uncommitted changes made from a pgx.Tx - TL;DR use
pgxpoolfor concurrency-safe transactions - Not clear if caller is required to close in case of QueryRow or if QueryRow properly closes in case of error
- Getting started with
-
- HyperLogLog: the analysis of a near-optimal cardinality estimation algorithm (PDF)
- HyperLogLog in Practice: Algorithmic Engineering of a State of The Art Cardinality Estimation Algorithm
- https://agkn.wordpress.com/2012/10/25/sketch-of-the-day-hyperloglog-cornerstone-of-a-big-data-infrastructure/
- Redis new data structure: the HyperLogLog
- https://www.reddit.com/r/programming/comments/21wshj/redis_new_data_structure_the_hyperloglog/
- https://redis.uptrace.dev/guide/go-redis-hll.html
- https://towardsdatascience.com/hyperloglog-a-simple-but-powerful-algorithm-for-data-scientists-aed50fe47869
- https://odino.org/my-favorite-data-structure-hyperloglog/
- http://blog.notdot.net/2012/09/Dam-Cool-Algorithms-Cardinality-Estimation
- https://supabase.com/blog/seen-by-in-postgresql
- https://www.citusdata.com/blog/2017/12/22/distributed-count-vs-hyperloglog/
-
An open-source exploration of the city's neighborhoods, nightlife, airport traffic, and more, through the lens of publicly available taxi and Uber data
-
- https://coderwall.com/p/whf3-a/hierarchical-data-in-postgres
- https://stackoverflow.com/questions/tagged/ltree
- https://github.com/jinagamvasubabu/ltreevisualizer
- https://patshaughnessy.net/2017/12/11/trying-to-represent-a-tree-structure-using-postgres
- https://patshaughnessy.net/2017/12/12/installing-the-postgres-ltree-extension
- https://patshaughnessy.net/2017/12/13/saving-a-tree-in-postgres-using-ltree
- https://patshaughnessy.net/2017/12/14/manipulating-trees-using-sql-and-the-postgres-ltree-extension
-
How to collect RDS MySQL metrics | Datadog
2019-02-05