A school discount with no code, because the discount is the email domain
We used to give schools a discount code. A teacher asked for one, we minted it, and then we maintained the parts that follow from a code existing: a…
Последние новости
⚑ Сообщить о проблемеTech news from the best sources
Все темы
- игры
AI
News
Tech
agents
ai
api
architecture
automation
backend
beginners
career
devchallenge
devops
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
testing
tutorial
typescript
webdev
Supabase RLS breaking change (Oct 30, 2026): 5-minute check to avoid 42501 errors
Oct 30, 2026, Supabase is enforcing a breaking change for RLS grants in the public schema. Existing tables are unaffected; new tables created after…
PostgreSQL Constraint Naming Convention: Which Pattern to Use, and How to Find the Names That Drifted
Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: Use the pattern PostgreSQL alrea…
🔎 Building IncidentCopilot: Designing a Deterministic Log Correlation Engine
Milestone 4 of IncidentCopilot — an open-source, local-first AI DevOps Incident Copilot 📌 Introduction Logs are plentiful during outages — the chall…
why pg‑bouncer can still choke your service under burst load
problem statement in a typical microservice, each instance opens its own pg client pool. during a traffic spike the aggregate connection count can e…
Our audit log has 64 actions, 17 of them are also analytics events, and one field is deliberately dropped on the way
Nakodo has 77 call sites that look like this: await audit ({ action : " campaign.launched " , userId , entityType : " campaign " , entityId : campai…
Postgres Logical Replication: Slots, DDL, and Failover
At 2 a.m. on a Tuesday, a client's reporting replica silently stopped applying changes. The publisher kept accepting writes. The replica kept answer…
Joins In PostgreSQL
Joins are one of those topics where everyone nods along when you explain them, then freezes up the moment they have to write one on the spot, in fro…
AI code review just delayed PostgreSQL 19. Finding bugs is now cheap and fixing them isn’t.
PostgreSQL 19 was supposed to ship in October. The release team now says general availability is November 19, with RC 2 on November 12 (postgresql.o…
I'm building an open-source platform for your database, API, auth and apps
I'm Duc. Since May 2025 I've been building Excalibase on nights and weekends, next to my day job. It started as a GraphQL engine for Postgres, becau…
Wait, How Did Hackers Steal the Encryption Key Too?" 5 Supabase Security Traps I Fixed in Production
Introduction: The Headline That Made My Stomach Drop Almost every week, we see another headline about a major tech company or hot startup suffering…
PostgreSQL EXPLAIN ANALYZE: What I Actually Look At in Query Plans
PostgreSQL EXPLAIN ANALYZE: What I Actually Look At in Query Plans Every slow query I have ever chased started the same way: someone guessing. "Prob…
One Null in the Subquery and Your NOT IN Returned Nothing
Marketing wanted a list. Every customer who had never placed an order. The query was short and read like English. Select from customers where id is…
One optional phone number, eleven files, five kinds of empty, and no migration
Yesterday I added an optional phone number to Nakodo. When a creator or a business says yes to a brand, the app introduces them by email, and the br…
Setting an env var above your imports does not run before them, and our integration test works anyway
The largest test file in PubTrivia is 543 lines, and it has no mocks in it. It calls the actual server actions a player's phone calls, and the actua…
Gate your app on a Postgres migration job with service_completed_successfully (and the DNS race that broke our deploy)
Originally published on the Hubfly blog . TL;DR What you get: a 3-service Compose file (Postgres, a one-shot migration job, an API) where the API ca…
Why Your Coding Agent Forgets Your Refactors (And How I Fixed It in PostgreSQL)
This is a submission for the MLH x DEV Writing Challenge What I Built Here is a bug that drove me crazy for three days straight. You ask an autonomo…
OpenSparrow v4.2 adds native Excel export, column masking for viewers
OpenSparrow v4.2 adds native Excel export, column masking for viewers, and record‑tooltips in drilldowns — plus a handful of UI polish and stability…
Why Your Connection Pool is Lying to You
We hit a wall last month. Traffic was stable, CPU was idle, but p99 latency spiked to 2s. The PostgreSQL server looked healthy. The culprit wasn't t…
I built a Supabase-style query client that talks directly to Postgres
I like the Supabase JS client. .from('todos').select('id, task').eq('done', false) reads like what I mean, and { data, error } means I'm not wrappin…
Reengineering Family Finance: Building Financial Integrity Into Kith
Families manage money and responsibilities in ways that often resemble small organizations. They coordinate recurring contributions, fund shared pro…
Mastering PostgreSQL Connection Pooling in Node.js and TypeScript Services
Most database crashes in Node.js apps don’t happen because of heavy queries. They happen because of unmanaged connection pools. When your TypeScript…
Similarity search and a time range, in one Postgres hypertable
Operator notes are time-series data. Each one has a timestamp, a site, a temperature, and a sentence about what happened. Searching them by meaning…
RAG Tenant Isolation Inside the Vector Index
Put the user filter inside the vector search itself. If you search everything and remove other people’s chunks afterwards, those chunks still use up…
Idempotency keys done right: exactly-once effects over at-least-once networks
Why "just retry" creates duplicate payments, and a PostgreSQL-backed design for idempotency keys that survives double clicks, timeouts, crashes and…
Postgres Retrieval Architecture: Multi-Tenant SaaS Help Center Schema Design
Short answer: use a staged retrieval design with explicit collections, bounded queries, and traceable source context, then make index cost a schema…
Do Cardano's governance vote rationales still resolve? Measuring it with db-sync and a blake2b-256 check
Under CIP-1694, a Cardano governance vote can carry an anchor : a URL to a document that explains the vote, plus a blake2b-256 hash of that document…
Building Resilient REST APIs with TypeScript, Node.js, and PostgreSQL
Most backend bottlenecks don’t happen because of poor hardware. They happen because of unindexed database queries, sloppy async error handling, and…
PostgreSQL Token Cleanup for REST APIs
Verification tokens are usually designed as if the only important event is a successful click. In a real REST API, the harder work happens around th…
Our widening setting is on by default, and the only way to store that is to store nothing
A Nakodo campaign can run out. Every keyword it was given has been searched, the new angles it generated have had their turn, and the brand still wa…