- 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
VirtualTam's bookmarks
-
-
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
-
2023-06-25 -
- 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
-
2019-10-18 -
2019-02-05 -
2018-07-23