Reading up on Elasticsearch
4 deep · digging since nov 22, 25
- Full-Text Search with DuckDB
DuckDB's full-text search extension offers BM25 scoring, stemming, and stop-word removal but lacks result highlighting and phrase queries.
- It's 2026, Just Use Postgres
The Hacker News commenters debate whether Postgres can truly replace specialized databases like Redis or Elasticsearch, with pushback on performance claims for caching and search.
- You gotta push if you wanna pull
Push queries incrementally process data changes to keep derived views fresh, while pull queries let humans inspect the materialized results on demand.
- Building a Simple Search Engine That Works
An article advocates building a simple search engine that works with existing databases and avoids external services, challenging the complexity of Elasticsearch and Algolia.