📰 Dev.to · Eugene

Inside PostgreSQL MATCH Queries: Syntax, Paths, and Parameters with pg_igraph Cypher-like...

On podbor-minuta.ru some database queries are heavy, so we keep their results in a cache: apartment lists, aggregate numbers for listing pages. While the…

Scraped metro and district fields were polluted with walk times and project names. How a station allow list and a junk block list removed about 193 thin pages.

One scraped field held a 295-character sentence. The page generator turned it into a directory name and the static build crashed with ENAMETOOLONG.

TL;DR When an AI agent changes few files, runs few tests, and says "Done", is it really...

Give every Playwright run a unique email address, poll a catch-all test inbox, and assert the exact OTP message.

Inspect Stripe sandbox deliveries on a persistent HTTPS endpoint, query them over MCP, and build a signature-verifying handler.

How steganography solved the eternal UUID performance vs privacy dilemma in PostgreSQL

A novel approach to weight initialization that lets you track exactly which parameters changed during training, enabling 60-70% safe pruning with zero quality l

We Replaced Recursive CTEs with a C Traversal Framework and Got ×207 Faster TL;DR: We...

A PostgreSQL C extension that encodes any SQL value into a compact bytea with a 2-byte typed header — and decodes it back without knowing the type in advance.

Recently I tried to resolve a recurring question in our team: Is JSON or JSONB actually faster in...