DevRadar

Database

Auto-aggregated global tech articles · 23 posts

Database

I picked MongoDB on day one. By month eight I needed Postgres.

The decision took about nine minutes. It was the start of a new product — VirtualRx, a business-management app for small retailers in Lagos. Point of sale, inventory, invoices, the lot. I needed a database, I had a schema roughly in my head, and MongoDB let me start writing code that afternoon inst

DEV Community
Database

Stop Building AI Agents. Start Building AI Systems.

There's a phrase I keep seeing everywhere in AI development: "We need an AI agent." Need to analyze documents? Build an agent. Need to automate a workflow? Build an agent. Need to interact with APIs? Build an agent. Need to write code? Build an agent. At some point, I started asking a diff

DEV Community
Database

GitHub - eznix86/laravel-analytics: Data Build Tool the eloquent way

At work, I kept writing the same thing: a few analytics tables, a cron job to rebuild them, and the same SQL copy-pasted into three models. Change one definition, forget to update one copy, and suddenly two dashboards quietly disagree. There’s `dbt`, which solves this problem for data teams, but it

Reddit r/php
Database

MERGE/SPLIT PARTITION reverted again

#​663 — September 2, 2026 Web Version Postgres Weekly Read Your Own Writes Off the Primary: WAIT FOR Measured — Last week, we shared an item explaining what Postgres 19's WAIT FOR is. Now, Radim puts it to the test: naive replica reads were stale 992 times out of 1,000 even o

PostgreSQL Weekly
Database

28 CVEs and a GROUP BY ALL U-turn

#​662 — August 26, 2026 Web Version 🏖️ After a week of being Disneyed-out, I return tired, but more ready than ever to dive back into the (far less humid) waters of Postgres!__Your editor, Peter Cooper Postgres Weekly Eight Years of Postgres Advice, Re-Checked Against Postgr

PostgreSQL Weekly
Database

A gofmt-style formatter for SQL

#​661 — August 12, 2026 Web Version 🏖️ We're taking a summer break next week, so the next issue will be on August 26.__Your editor, Peter Cooper Postgres Weekly Introducing sqlfmt: An SQL gofmt-Style Formatter — Postgres contributor Dimitri has developed his own way to style

PostgreSQL Weekly
Database

What if Claude were your Postgres server?

#​660 — August 5, 2026 Web Version Lots of videos from this year's PGConf.dev are now on YouTube and I've rounded up some highlights at the end of the issue!__Your editor, Peter Cooper Postgres Weekly COUNT(DISTINCT) Too Slow? A Guide to Fast Approximations — A thorough, han

PostgreSQL Weekly
Database

A 15-Second Health Check for Your Heroku Connect Data Pipeline

Heroku Connect is a fully managed, bidirectional data sync service between Salesforce and Heroku Postgres that lets developers read and write Salesforce data using standard SQL. The sync is straightforward to set up and operates smoothly in the background, but when a field does not update as expecte

Heroku Blog