Tech news from the best sources
Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: Use the pattern PostgreSQL alrea…
A hospital database rarely stores every useful detail in one table. Patient details may be stored separately from visit records. Doctor, department,…
Introduction While working on my hospital dataset, I realised that SQL is not just about retrieving data. It can also help me compare hospital visit…
This is a submission for the Hacktoberfest Open-Source AI Challenge Week 2: Side Hustle What I Built CreatorDesk is a self-hosted, open-source tool…
You get a call: last night's batch failed, the transaction rolled back, and now someone asks "what happened?" You open your log table. It's empty. I…
Joins are one of those topics where everyone nods along when you explain them, then freezes up the moment they have to write one on the spot, in fro…
Reading the CVSS 9.8 score of CVE-2026-108474 without overreading it Vulnerability overview CVE-2026-108474 carries a CVSS v3 score of 9.8 and is cl…
PostgreSQL EXPLAIN ANALYZE: What I Actually Look At in Query Plans Every slow query I have ever chased started the same way: someone guessing. "Prob…
Marketing wanted a list. Every customer who had never placed an order. The query was short and read like English. Select from customers where id is…
Medical device catalogues have a recurring design problem: one product, many size variants. A ureteral stent might come in six diameters, a dozen le…
The Python Institute PCAD-31-02 exam has 48 items, and 30 of them come from two syllabus blocks: Data Acquisition and Pre-Processing (14) and Progra…
What if you could build complete, production-grade ETL pipelines in Pure SQL… without Jinja templates, without a database server, and without heavy…
Window functions are the most common SQL topic in data engineering interviews, and most candidates know the syntax. The follow-up questions are wher…
If you’ve ever mixed up WHERE and HAVING, you’re not alone. They both filter data, so it feels like you should be able to use either one. But they f…
Merging Two Messy CSVs: The Key Problems Excel Formulas Hide From You You have two spreadsheets. One is your export, one is the client's. Someone sa…
Hello, I’m Arthur. One problem developers often face is that an application works perfectly when it has a few hundred records, but starts slowing do…
Problem Description The stock table records the daily closing prices of many stocks, with the fields CODE (stock code), DT (trading date) and CL (cl…
Fix It in the Model or Fix It in the Source? The first compile error in a converted CA 2E program forces a decision most teams never make on purpose…
Stored Procedures A deep-dive walkthrough of stored procedures — covering parameters and output parameters, plan caching and recompilation specific…
If a unique index suddenly tolerates duplicates, or WHERE email = ... misses a row that a sequential scan finds, the index is sorted by collation ru…
In this article I'll show you how a dbt incremental model that looked perfectly reasonable wiped out three months of finance data, why none of our c…
I had written a stock market analysis program before. One of its tables had a SMALLINT column. When I tested LogCarver against that table, every row…
Tables, indexes, constraints, sequences, partitions and rows, in one go. 1. Overview SqlJam : Move tables across databases. Schema, data and all. A…
Imagine asking an AI assistant for the average order value in a 12 GB sales export. It finds an amount column and suggests AVG(line_amount) . The qu…
A text-to-SQL agent sees table and column names. It does not know that "revenue" in your company means billing_invoice.total_net , only for invoices…
Imagine a table with ten million users. You need one person, and all you have is an email address. Without a useful index, the database may have to…
Data is everywhere — but turning data into meaningful insights is a skill I’m excited to build. As an AI & Data Science student, I’m exploring t…
You connect an AI agent to your shop's database and ask a simple question: "How many active customers do we have?" The agent looks at the tables: cu…
LIMIT 20 OFFSET ... makes the next page of a list easy to express. But deeper pages require skipping more rows without returning them. Using an inde…
Imagine an inventory table for an e-commerce flash sale: Item: Nintendo Switch (Stock: 1) Two customers (Alice and Bob) click "Buy Now" at the exact…