Daily edition · Databases
TILens turns technical updates into a focused daily brief: official releases, trusted reporting, and practitioner analysis, deduplicated and organized by topic.
13 articles · 5 sources ·
Top topics: PostgreSQL · AWS · Open Source
Learn how to use Kiro IDE with the Amazon Aurora MySQL MCP server to diagnose deadlocks and high IOPS events through natural language prompts, turning hours of manual, expert-dependent investigation into minutes of…
For years, https://yum.postgresql.org and https://zypp.postgresql.org have had documentation pages for the extensions we package. But the PGDG repositories hold much more than PostgreSQL and its extensions: backup…
It's somehow mid-October already! We're busy working towards the upcoming PG19 release, but it's been just over a year since my last OAuth post, and it's probably time to talk about that again. Sometimes it's even nice…
Security updates have been issued by AlmaLinux (idm:DL1, kernel, libsoup, perl-URI, python3.14-urllib3, and webkit2gtk3), Debian (apache2, cifs-utils, haproxy, jq, kernel, and xen), Fedora (aom, chezmoi, chromium,…
With the first release candidate available, PostgreSQL 19 brings practical advances in database maintenance, query planning, and replication.
With the first release candidate available, PostgreSQL 19 brings practical advances in database maintenance, query planning, and replication.
auth.uid() against (select auth.uid()) in a Supabase-style RLS policy on PostgreSQL 17, measured: 923 against 42 ms without an index, no difference with one.
Why a Supabase row-level security policy returns nothing, fails or leaks, measured on PostgreSQL 17 with Supabase's own roles and auth.uid(): ten causes.
This is the first post in a series exploring graph databases and PostgreSQL’s evolving role in the graph landscape. Over four posts, we’ll move from foundational concepts through PostgreSQL’s SQL/PGQ implementation…
hstore against jsonb on a million flat documents in PostgreSQL 17 and 18, measured: storage, reads, updates, GIN indexes, and what hstore does to types.
Awide Labs releases Awide Polar, its PostgreSQL fork with compute-storage disaggregation and HTAP capabilities, alongside enhanced PolarFS storage and Polar Proxy for consistent replica reads.
Four Supabase row-level security policy sets, tested with Supabase's own roles: own rows, public read, teams without recursion, and admins from the JWT.
