VirtualTam's bookmarks
-
2024-01-15 -
2023-09-08 -
2023-07-22 -
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
-
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 -
2022-12-15 -
- 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
-
2022-05-02