menu

Recent posts tagged postgres

Level UI • 1 day • in Articles • 9 min read
An MCP server is not a new API. It is a thin layer over the one you already have
Somewhere in the last year, "do we need an MCP server?" joined the list of questions that arrive in a brief before anyone has said what the thing is for. It is usually framed as MCP vs API, as though the Model Context Protocol were a newer kind of AP...
post-cover-33074
  • ai
  • api
  • webdev
  • security
9 Reactions 7 Comments
Anusha Renangi • 2 days • in Articles • 18 min read
Database Transactions - ACID Properties
Introduction Yesterday, I went to a restaurant with my friends. We ordered some food, finished eating, and asked the waiter for the bill. While the waiter was preparing the bill, I started thinking about how the billing system works behind the sce...
  • database
  • postgres
  • systemdesign
3 Reactions 1 Comments
Mhamd Ghanoum • 2 days • in Articles • 2 min read
Cancel or send: one winner. An order flow on Prisma Postgres and Compute
> Werbung / Disclosure: Prisma gave me a coupon for two months of a paid plan for free and said it will add free credits, so I could try Prisma Postgreshttps://www.prisma.io/postgres and Compute for this project. All results below come from my own ru...
  • prisma
  • postgres
  • testing
  • nestjs
0 Reactions 2 Comments
EmmeKappa23 • 3 days • in Articles • 3 min read
A week of green runs, and the pipeline was waiting for me
On 1 September at 10:57 UTC the monthly ingest ran. It opened issue number 3 of the magazine, picked the vertical from the source registry, wrote 19 candidate sources into Postgres with stage = 'discovery', and opened a GitHub issue telling me it was...
post-cover-32698
  • devops
  • automation
  • monitoring
  • postgres
2 Reactions 0 Comments
gerald-mathew • Oct 14 • in Articles • 4 min read
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 wrapping every query in try/catch. What I don't always want is the stuff around it: a project URL, an anon key, an...
post-cover-31116
  • postgres
  • node
  • typescript
  • opensource
4 Reactions 2 Comments
firatcelik • Oct 9 • in Articles • 21 min read
Kafka Just Learned to Be a Queue. Postgres Has Been One All Along.
Originally published on DEV.tohttps://dev.to/firfircelik/kafka-just-learned-to-be-a-queue-postgres-has-been-one-all-along-2i9g. On February 17, 2026, Apache Kafka 4.2 shipped with this line in the release announcementhttps://kafka.apache.org/blog/20...
  • postgres
  • kafka
  • go
  • python
0 Reactions 0 Comments
Pires Aurelio • Oct 1 • in Articles • 2 min read
Building a Resilient Job Queue in Go: Postgres, Worker Pool and Graceful Shutdown
Building a Resilient Job Queue in Go: Postgres, Worker Pool and Graceful Shutdown I am Pires Aurélio, Go Backend Engineer from Luanda, Angola. I build production systems in public. For two years I built scrapers and simple REST APIs. I got tired of...
post-cover-29442
  • go
  • backend
  • postgres
  • architecture
4 Reactions 1 Comments
umohsg • Sep 26 • in Articles • 15 min read
Horizontally Scaling PostgreSQL: Database Sharding with Citus
> A practical guide to scaling your database infrastructure horizontally. Learn how to shard your data, optimize query routing, and build a distributed multi-tenant architecture using Postgres, Citus and Docker. Prerequisites What do you need to fo...
  • backend
  • database
  • postgres
  • sharding
0 Reactions 1 Comments
Onkar K • Sep 9 • in Launches • 1 min read
Next.js Full-Stack Auth Template
I built an open-source starter template combining Next.js, B...
  • nextjs
  • betterauth
  • postgres
6 Reactions 2 Comments
Michelle Wiginton • Aug 25 • in Articles • 6 min read
I Moved My Next.js Dashboard Logic Into Postgres. My Frontend Got Boring (And That's the Point).
My dashboard had a useMemo doing arithmetic it had no business doing. It was a Pokémon TCG Pocket collection tracker, but that part doesn't matter. What matters is that the home page needed to show three things: overall completion, completion per se...
post-cover-25362
  • supabase
  • postgres
  • nextjs
  • database
20 Reactions 7 Comments
wadethomasttverified • Aug 6 • in Articles • 5 min read
Directus + Coolify: Should You Decouple Postgres & Redis?
> This is Part 2 of the Directus + Coolify series. If you're new here, start with "Secure Your VPS Before Hackers Do" and the first Directus + Coolify post — the bundled, single-Compose-file setup — before following along with this one. Introduction...
post-cover-24235
  • coolify
  • directus
  • postgres
  • redis
3 Reactions 2 Comments
fazal_mansuri_ • Jul 17 • in Articles • 3 min read
🚀 UUIDv4 vs UUIDv7 in PostgreSQL
Why Switching UUID Versions Can Boost Performance at Scale Many teams choose UUIDs as primary keys to support distributed systems and avoid ID collisions. But not all UUIDs are equal. Some teams have seen 10×–50× performance improvements simply by...
  • database
  • performance
  • postgres
  • systemdesign
2 Reactions 0 Comments
abdulrdeveloper • Jul 2 • in Articles • 8 min read
Chai aur SQL — A Beginner's Journey into Databases
title: Chai aur SQL — A Beginner's Journey into Databases published: true canonicalurl: https://blog.abdulrdeveloper.me/chai-aur-sql-a-beginner-s-journey-into-databases tags: sql, postgresql, database, backend SQL stands for Structured Query Langu...
  • sql
  • postgres
  • database
  • backend
2 Reactions 0 Comments
Tom Smithverified • Jun 15 • in Articles • 4 min read
When Your Database Is On Fire at 2 AM, Ellie Shows Up
Most database problems don't announce themselves in advance. They show up at 2 AM, when systems are down and the clock is running. And the DBA who knew this environment best left the company six months ago. That's the reality Dave Page, CTO of pgEdg...
post-cover-20660
  • postgres
  • databasemanagement
  • aiagents
  • opensource
4 Reactions 2 Comments
Jane49-cloud • Jun 3 • in Articles • 8 min read
Building LifeFast: A Solo Founder's Deep Dive into Fasting App Architecture
title: Building LifeFast: A Solo Founder's Deep Dive into Fasting App Architecture published: true tags: reactnative, postgres, expo, healthapp There's a specific kind of frustration that comes from using a health app that feels like it was built ...
post-cover-19608
  • reactnative
  • postgres
  • expo
  • healthapp
6 Reactions 2 Comments
Jayson kibet • May 17 • in Articles • 7 min read
Full Sales Data Analysis: From Raw Data to Interactive Business Dashboard
Introduction Anybody can be a data analyst,but what separates a good data analyst from a great one is what you can do and present.In this article i will be giving step by step guidelines from turning a raw data to an interactive business dashboards a...
  • tutorial
  • python
  • postgres
  • analytics
9 Reactions 4 Comments
rvneto • May 10 • in Articles • 2 min read
The Heart of B3: Building the Matching Engine with RabbitMQ, Redis and Spring Boot
Hello everyone! Continuing the My Broker B3 series, we've reached one of the most anticipated components of the ecosystem: the B3 Matching Engine API. In the previous post, we built b3-market-sync-api which synchronizes real prices from brapi.dev a...
  • java
  • spring
  • postgres
  • rabbitmq
0 Reactions 0 Comments
braeson • May 10 • in Articles • 2 min read
Understanding Logic, Reusability and Integrity On SQL ; Procedures, Functions and Transactions.
SQL is widely known for data querying and manipulation but systems do grow; data becomes larger; processes become repetitive and operations become sensitive. SQL has some features which enables it to be considered a fully fledged programming language...
post-cover-17301
  • sql
  • postgres
  • data
  • analytics
15 Reactions 3 Comments
pelumi • May 5 • in Articles • 3 min read
From Aiven to Railway: Our Database Migration
I didn't plan a migration. I just noticed we were paying for two databases. This whole thing started with a very unglamorous realization: > We were paying for Aiven Postgres… > and also paying for Railway. At some point I opened the Railway dashb...
post-cover-16741
  • webdev
  • postgres
  • productivity
  • startup
2 Reactions 1 Comments
Damaris C • May 4 • in Articles • 4 min read
How to Connect Power BI to a SQL (PostgreSQL) Database and Build a Unified Dashboard
Introduction Power BI is a business intelligence BI and data visualization tool from Microsoft. It enables analysts and business users to transform raw data into interactive dashboards and reports. Companies use Power BI to analyze sales, customer ...
  • discuss
  • database
  • postgres
  • dataengineering
4 Reactions 0 Comments
braeson • Apr 28 • in Articles • 3 min read
Sub-queries vs Window Functions vs Common Table Expressions: Which Should You Use in SQL?
SQL is the most used tool for data manipulation but what happens when there are some concepts that seem to work towards the same ultimate outputs. As queries become more complex, developers often encounter different techniques that appear to produce...
post-cover-16078
  • sql
  • data
  • postgres
  • analytics
7 Reactions 2 Comments
Page:
chevron_left
🔥 21 posts • 👩‍💻 20 active writers
✨ Want to write in this topic?
Share your learning. Get discovered. Build your profile.
Join CoderLegion
💡 Why developers use CoderLegion
Track learning • Share posts • Get ranked publicly
Create your profile