Articles by Tag #sql
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
Nested Loop and Hash Join for MongoDB $lookup
SQL databases offer several join algorithms. The query planner selects the most efficient one by...
SQL Restaurant Kitchen ---Indexes and Partitions
The Night Everything Broke It was 2 AM on a Friday when my phone exploded with alerts. Our...
SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird
Up until now, SQL felt very… solid. Numbers are numbers. Strings are strings. GROUP BY either works...
Querying & Filtering in Oracle Databases: What Actually Clicked for Me As a Beginner
Today felt like one of those quiet but important SQL days. No new tables. No fancy joins. Just...
Columns & Data Types in Oracle: What Actually Stuck on Day 2 (As a Beginner)
Day 2 of learning Oracle SQL was less about writing fancy queries and more about understanding what...
SQL vs NoSQL: Choosing the Right Database Before It Chooses Your Fate
SQL or NoSQL - the debate isn’t just about databases, it’s about how your application will think,...
Join Data from Anywhere: The Streaming SQL Engine That Bridges Databases, APIs, and Files
Have you ever needed to join data from a MySQL database with a PostgreSQL database, a MongoDB...
📝 Fixing BigInt Serialization Error in Node.js + Express (A Beginner-Friendly Explanation)
Hey everyone! 👋 I’m a Node.js backend developer who worked mostly with MongoDB. Recently I shifted to...
Dear Developer: Your Database Isn't a File Cabinet!
Hey guys! I’m an Engineering Manager, and I’m sharing some notes deep from the development trenches....
Hacktoberfest 2025 — Advancing SQL Tooling in Draw.io
Updates to Draw.io plugins for SQL import/export and schema visualization during Hacktoberfest 2025
When ANALYZE Isn't Enough: Debugging Bad Row Estimation in PostgreSQL
As backend developers, we’ve all been there: a query that usually runs instantly suddenly hangs, or a...
How I Automated 90% of Data Requests Using LLM-Powered SQL Generation
How I Automated 90% of Data Requests Using LLM-Powered SQL...
TypedSql: Turning the C# Type System into a High-Performance SQL Query Engine
0. Introduction TypedSql started from a very practical annoyance. Most of the time when I...
Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins
Hey folks, if you've ever stared at your terminal in horror as Laravel cheerfully deletes half a...
How to Read SQL Server Execution Plans: 7 Things That Matter
A practical SQL Server execution plan tutorial. These seven patterns reveal 90% of performance...
I Almost Let an LLM Delete My Database. Here's What I Built to Prevent It.
Everyone's building "chat with your data" apps right now. Connect an LLM to your database, let it...
When Your Database Became a Library: Guide to PostgreSQL Indexes
Tags: #postgresql #database #performance #sql Meta Description: Discover PostgreSQL indexes through...
The Six Failures of Text-to-SQL (And How to Fix Them with Agents)
I’ve written countless SQL queries over the years. Unfortunately, like my golf game, I don’t write...
Understanding SQLite PRAGMA (And How better-sqlite3 Makes It Nicer)
Hello, I'm Maneshwar. I'm working on FreeDevTools online currently building **one place for all dev...
Hackerrank - SQL - Average Population of Each Continent
Problem Description Given the CITY and COUNTRY tables, query the names of all the...
How SQL JOINs Finally Clicked for Me (and How They Can for You Too)
Today's post is not a “perfect” explanation of SQL joins. It’s the explanation I wish I had when...
🗄️DB Performance 101: A Practical Deep Dive into Backend Database Optimization⚡
Introduction If you’ve ever watched your backend performance graph nosedive as production...
Learning .NET from Beginner to Advanced Level's
Here's a comprehensive syllabus for learning .NET from beginner to advanced levels: .NET...
Introducing StackQL - Manage Your Cloud Services & Interact with APIs using SQL 🧑💻🔥
In the fast-paced digital age, modern cloud stacks have become more complex, meaning users often have...
Associações polimórficas no Rails: como fazer, prós e contras
Recentemente, me deparei com uma situação no trabalho em que precisava implementar uma tabela que se...
Databases & SQL Basics As A Beginner: A Practical Introduction
Databases & SQL Basics: What I Learned on Day One Today I officially started my...
PART 5 — The Rise of Network SQL (N-SQL)
SECTION 1 — The Past: The Origin Story of SQL Before we talk about a new query language for...
SQL for Data Professionals: From Basics to Advanced Analytics
SQL (Structured Query Language) remains the backbone of data retrieval and manipulation in the world...
Why AI Analytics Tools Are Solving the Wrong Problem
TLDR: The AI analytics industry is obsessed with building better query engines - using LLMs to turn...
🧠 ClickHouse LEFT JOINs: Why join_use_nulls Matters
🧠 Understanding join_use_nulls in ClickHouse ClickHouse is famous for being blazing fast —...