New things for regular expressions in PostgreSQL (pg_tre and pg_re2) – select * from depesz;

kept by blakbelt78 sep 02

The post evaluates PostgreSQL's pg_tre and pg_re2 extensions, showing pg_re2 outperforms pg_trgm on complex regexes while pg_tre enables fuzzy matching but is slower and larger.

PostgreSQL for Everything
The article argues that PostgreSQL can serve as a versatile backend for diverse applications, from caching to analytics, reducing the need for multiple specialized databases.
also on PostgreSQL, #technology, #open-source, #software-engineering, #developer-tools
GitHub - NikolayS/pgque: PgQue – Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick.
PgQue is a zero-bloat Postgres queue engine implemented entirely in PL/pgSQL, using snapshot-based batching and table rotation to avoid the dead-tuple bloat that plagues SKIP LOCKED queues.
also on PostgreSQL, #open-source, #software-engineering, #developer-tools