Auto-aggregated global tech articles · 71 posts
Vacuum - a PostgreSQL monitoring and tuning dashboard for Laravel (with an optional Filament plugin). It reads what Postgres already knows about itself (pgstat*, pg_class, pg_stat_statements) and turns it into a page that tells you what's wrong, what it's costing you, and the exact SQL that would fi
Every booking product is the same product underneath. A padel club, a dental practice, a co-working space, a boat rental, a photo studio: different words on the interface, the same eight problems under it. What is free right now. Who gets the slot when two people ask at the same instant. What happen
The Free Cold Outreach Tool Every Small Business Needs Whether you run a local marketing agency, a boutique consulting firm, or you're just trying to get some PR for your new startup, you already know the truth: cold outreach works. But there's a catch. Sending emails manually is exhausting, and
NULL Is Not Zero, Not an Empty String, and Not False This single idea explains most NULL-related surprises: NULL represents an unknown or missing value — not zero, not an empty string, not boolean false. It's a placeholder meaning "there is no value here to compare," and that has real consequences f
When a setting changes unexpectedly, engineers need three answers: what changed, who changed it, and what was there before? Recent investigations and older compliance queries have different latency and cost needs. This article presents a generic design using two short-lived online tables and a long-
SQL Functions Commonly Used Functions Window Functions examples include, (Row_number, Rank). This function is used to retrieve single records out of a repeating table . Row_number: This gives each row a unique number in sequential order within a group. For example, Number transactions by custo
SUBQUERIES Subquery is a query inside a query and is used when one statement needs a result from another. It is usually inside a clause like 'where' : 'from' or 'select'. CTE A CTE(Common Table Expression) is a temporary named result set that one can reference within single query to reuse
A join is how you ask one question across two tables. The database keeps patients in one table and appointments in another, because storing the patient's name on every appointment row would mean fixing it in ten places when it's misspelled. A join puts them back together for the length of one query.
How to Design a Database for an E-commerce App: A Step-by-Step Guide to Building an online store sounds exciting, but behind every smooth checkout button lies a powerful database structure. As a 2nd-year BCA student currently diving deep into Database Management Systems (DBMS), I realized that te
From a Synthetic AHP Event to a Real Base Sepolia Anchor Today we completed the first end-to-end blockchain anchoring test for MyZubster’s AHP traceability layer. The goal is to prove the integrity and timestamp of a circular-economy pilot event without placing personal or health data on-chain.
#664 — September 9, 2026 Web Version Postgres Weekly The Scary Postgres 19 Patch Contest — It’s not even Halloween yet, but in this fascinating thread on the pgsql-hackers list Robert Haas set out with Claude to “evaluate which v19 patches were the scariest”. One of them, SQ
As applications scale from hundreds of thousands to millions of records, poorly optimized database queries quickly become the primary bottleneck of modern web architectures. While hardware has gotten faster, an unindexed query forcing a full table scan across millions of rows will easily exhaust ser
An agent that can read your database answers questions you'd otherwise open a SQL editor for. "Why did signups drop on Tuesday?" "Which orders have been stuck in pending for more than an hour?" "What's actually in the events table?" With a query capability the model answers in seconds; without one i
Hey Everyone! At Major League Hacking (MLH), our mission is to empower student developers worldwide by providing organizers and hackers with the resources, mentorship, and support they need to build incredible tech communities. We partner directly with hackathons to guide organizers through the pla
Introduction One morning, while going through the latest batch of Postgres commits, I saw this: commit bd8d9c9bdfa0c2168bb37edca6fa88168cacbbaa Author: Heikki Linnakangas heikki.linnakangas@iki.fi Date: Tue Dec 9 13:53:03 2025 +0200 Widen MultiXactOffset to 64 bits This eliminates MultiXactOf
Every NestJS project has this moment. Sign-up and sign-in work. Password hashing works. A JWT gets issued, a guard checks it, and everyone moves on to the parts of the product that actually matter. Then, a few months in, someone asks for Google sign-in, or that users need to be able to change or res
If your pipeline isn't idempotent, it isn't production-ready; it’s just a fragile script waiting to ruin your weekend. Most engineers treat "idempotency" as an academic concept for distributed systems papers, but in the trenches of fintech and healthcare, it’s the difference between a minor blip and
I maintain Chron, an MCP server that writes an audit log of AI coding sessions to a local SQLite database. Every message gets a timestamp, and every session records which tool produced it: Claude, Cursor, Codex. A while back I opened the history and found Claude messages and Cursor messages interle
During university I was sending photo sets to clients most weeks. I'd zip them up, upload them to Google Drive and send a link. It worked for me for the most part. But my client files sat in the same drive as everything personal I owned, and the link I sent looked like nothing that had to do with m
Someone asked this on the official forum (t/13660, July 31st): Do different workflows run concurrently, interleaved with each other? I have several workflows that query the same table, compute something, and then update it. Could it happen that A queries, then B queries, and then A's update makes
21–40 / 71
