HHuzaifa Khan38m ago · 12 min readThree reader fixes for my $0 RAG chatbot, measured before and afterI recently compared two ways to run a RAG chatbot on a personal site for $0. Two readers left suggestions, one on Hashnode and one on dev.to, and they were good enough that I built them instead of jusitshuzaifa.hashnode.dev
MMuhammad Ahmad8h ago · 3 min readChatGPT Serves 800 Million Users From One Postgres Primary. Here's How.800 million people use ChatGPT, and every write still lands on one PostgreSQL primary. No sharding. When I read OpenAI's post Scaling PostgreSQL to power 800 million ChatGPT users by Bohan Zhang, I co1mahmad.hashnode.dev
PPipeline Whiteboard3h ago · 9 min readThe Silent CDC Bug: Data Loss With No ErrorsEvery dashboard is green. The connector says RUNNING, capture lag is under a second, and the warehouse is missing 4,812 orders. Nobody gets paged, because nothing failed. This is Part 3 of CDC in Prodpipelinewhiteboard.hashnode.dev
PPipeline Whiteboard3h ago · 10 min readDebezium Postgres to Kafka: Every Setting ExplainedAbout fifteen lines of JSON. That's all it takes to stream every insert, update and delete from Postgres into Kafka with Debezium. And two of the defaults hiding in those lines will hurt you in producpipelinewhiteboard.hashnode.dev
BBuiltSafely5h ago · 4 min readinfinite recursion detected in policy for relation (42P17)If your Supabase queries suddenly fail with "infinite recursion detected in policy for relation", the cause is almost always a row-level security policy that ends up checking itself. The tempting shorbuiltsafely.hashnode.dev
ZZenith Eclipse Co11h ago · 4 min readTrace a Repacked Commodity Lot with a Graph, Not a Single Parent ColumnA lot is split into two packing runs. One run later includes material from another incoming lot. A database with one parent_lot_id now has an awkward choice: discard one origin or put several identifizenitheclipse.hashnode.dev
WWaqas Shahid12h ago · 3 min readPostgreSQL Explained: The Database You Default ToIntroduction Ask experienced developers which database to pick for a new project, and one answer comes up more than any other: PostgreSQL, usually called Postgres. It is free, open source, battle-testpracticaldevblog.hashnode.dev
SSnapDeploy15h ago · 10 min readPostgres, MySQL, MariaDB or MongoDB next to your container: how the managed add-ons workTL;DR: SnapDeploy runs PostgreSQL, MySQL, MariaDB and MongoDB as add-ons next to your containers. Pick an engine and a tier (Mini $29, Standard $49, Pro $89 a month, or a $1 DB Sprint Pack for 12 hoursnapdeploy.hashnode.dev
Vvinhtoan9xdn16h ago · 5 min readFormatting Complex BigQuery & PostgreSQL CTEs Directly in the Browser (With Zero Data Leakage)Every backend and data engineer has been there: you pull a massive, unformatted 200-line SQL query out of a production log, an ORM debug trace, or a legacy stored procedure. It is a single-line wall ojoytools.hashnode.dev
CCloudHike Team1d ago · 6 min readI built CloudHike: a backend your AI coding agent can set up over MCPMy AI agent can write a whole Next.js app in an afternoon. Then it stops and hands the hard part back to me: make a Postgres database, set up a storage bucket, find a Redis instance, add auth, pick ancloudhike.hashnode.dev