Introducing TIN: full-text search for Postgres — PlanetScale

kept by eddie sep 17

PlanetScale announces TIN, a Postgres full‑text search extension that outperforms existing indexes with up to 57× higher query throughput and lower latency.

Show HN: Omni – Open-source workplace search and chat, built on Postgres
Omni is a self-hosted AI agent platform that indexes workplace tools into a unified search and chat layer, using Postgres for hybrid search.
also on ParadeDB, PostgreSQL, #open-source, #developer-tools
Video Conferencing with Postgres — PlanetScale
A developer demonstrates live video calls over PostgreSQL using logical replication, achieving 15fps with a $5 database.
also on PlanetScale, PostgreSQL, #software-engineering, #developer-tools
Cloudflare Workers and Hyperdrive with TanStack Start – Master.dev Blog
Using Cloudflare Workers with Hyperdrive and TanStack Start requires per-request database objects to avoid runtime errors and connection limits.
also on PlanetScale, PostgreSQL, #developer-tools
New things for regular expressions in PostgreSQL (pg_tre and pg_re2) – select * from depesz;
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.
also on PostgreSQL, #benchmarks, #open-source, #software-engineering, #developer-tools
AI inference just plays by different rules
AI inference workloads demand unprecedented concurrency and throughput, exposing cloud storage limits that require a decoupled, software-defined layer to avoid catastrophic failures.
also on PostgreSQL, #performance