cutting N+1 queries in Next.js API routes with Supabase RPC
when a dashboard starts pulling relational data from Supabase, the naive approach is to fire a separate select per row. the result is a classic N+1…
Tech news from the best sources
when a dashboard starts pulling relational data from Supabase, the naive approach is to fire a separate select per row. the result is a classic N+1…
Fetch the Nakodo home page with curl and the header offers you "Sign in" and "Start free". Open the same URL in a browser where you are signed in an…
Munchable's marketing site and its 373 generated answer pages are statically rendered, and they still run a function on every request, because the h…
Introduction: The Headline That Made My Stomach Drop Almost every week, we see another headline about a major tech company or hot startup suffering…
A schema diff can be technically valid and still remove data you meant to keep. That is why switching an existing Supabase project to Declarative Sc…
Lovable Cloud is the backend Lovable switches on for you the first time your app needs to save something. Ask for a login page or a table of orders…
Every AI agent SaaS I've built needed the same foundation before a customer could pay for it. I rebuilt it several times before I stopped. Here's th…
Let me start with a confession: I don't really know what I'm doing. I'm not a Rust developer. I've never written a database backend. I run a small S…
The least-privilege pattern for Supabase RPCs is well documented: don't let postgres own your SECURITY DEFINER function — create a dedicated NOLOGIN…
Four prompt-to-app tools compared on stack, deployment, code ownership and pricing model, with recommendations by scenario rather than a single winn…
Row level security compares auth.uid() with the row's owner. When the request carries no JWT, auth.uid() is null, every comparison is false, inserts…
Welcome to our weekly log for the Supabase .NET SDK 🎉 Sorry for being a little late on this one. Like I said last week, I spent more time working on…
This is not row level security. The database role your app uses ( anon or authenticated ) has no privilege on the table at all, so Postgres refuses…
Most Lovable Cloud to Supabase migration guides stop at "dump the database, restore it, change two env vars." That part takes an afternoon. The bugs…
You built the app in Lovable or Bolt. Now you've found a developer or agency to take it further, and their first message is: "Can you send me access…
Setting up a backend database traditionally meant provisioning virtual machines, managing port forwarding, and writing manual SQL schemas before wri…
A restore test on a real 105-table Supabase database failed a few weeks ago. The tool doing it restores in a strict mode, so it stopped on the first…
OPENING PARAGRAPH: We built a production command center for Quiet Hours Valet that orchestrates 8 concurrent AI voice agents, 8 automation scenarios…
The short version Supabase uses IPv6 by default. Most local dev environments and many hosting providers don't support IPv6, so DNS resolution fails…
58 of 154 public Supabase apps had a working service_role key in git. Here's what that means for yours. If you build with Lovable, Bolt, Cursor, or…
Разбираю несколько инженерных решений из небольшого браузерного проекта: бинго на шахматных задачах Lichess без собственного сервера. Как получить о…
С помощью AI сегодня каждый может навайбкодить приложение за считанные часы. Но чтобы превратить его в рабочий PoC, нужно решить ряд архитектурных,…
Чтобы человек навёл камеру на пачку гречки и получил название, вес и калории, нужна база штрихкодов российских продуктов. Я был уверен, что она где-…
Not every market has easy access to Stripe. In a lot of places the real payment rails are bank transfer and mobile wallets, confirmed by a human. Th…
I don't know if anyone else here has ever used Blender or tried their hand at 3D animation, but if you have, you know it's hard. Like really hard. I…
9 September 2026 · Luc Richelet. Every number below comes from a real execution log, under real PostgreSQL login roles, on two clean databases. Noth…
TL;DR: My entire mobile stack costs $0 a month. Expo builds the app. Supabase holds data and auth. Render runs background jobs. Vercel hosts the lan…
TL;DR: GitHub login in my Expo app broke three separate times. A deep link that went nowhere. A PKCE flow I wired backwards. A redirect URL with a t…
I built Moka-fi as a cozy online café where friends can study, talk, play and spend time together. One of the newest rooms is Watch Together, where…
A "download all" button sounds simple until it has to combine private files, survive a slow connection, and deliver the same export twice. For Supab…