SQL Basics: Talking to a Database for the First Time
Every company you will ever work for stores its data in a database. Not CSV files. Not Excel sheets. A database. Tables of users. Tables of transactio…
Open Source
⚑ Report a ProblemLatest Open Source news from Tech News
All topics
AI
agents
ai
api
architecture
automation
aws
beginners
career
claude
database
devchallenge
devops
discuss
javascript
linux
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
rust
security
showdev
tutorial
typescript
webdev
You Want To Learn SQL? Here Is What I know So far...
SQL: What is it? First of all, it stands for Structured Query language. It is one of the programming languages used to communicate with relational dat…
SQL Course for Analysts: Pick, Learn, Apply Fast
Hiring managers don’t care that you “know SQL” — they care that you can answer business questions quickly and correctly. If you’re searching for a sql…
PostgreSQL Index Usage and Optimization
PostgreSQL Index Usage and Optimization Indexing is the single biggest lever in SQL performance, and it is also the category where most of the bad adv…
archery-cli: Connect AI Tools to Your SQL Audit Platform
At my company, we use Archery for SQL audit and read-only queries against our databases. Archery has a nice web UI, but our AI tools (Claude Code, Cur…
6 Essential SQL Concepts Every Beginner Should Master
Introduction. Starting your journey with SQL can feel like staring at a massive wall of syntax. But here’s a secret: you don’t need to know everything…
SQL Injection Explained: How Hackers Bypass Login Forms (and How to Stop Them)
Even today, a single poorly written SQL query can allow an attacker to bypass authentication or expose sensitive data. And the scary part? It often co…
The Five Most Important Columns to Add to Every Database Table
Let me tell you about one of the worst days of my career. A client called me, furious. Corrupted records, no idea who changed what, no idea when anyth…
SQL Server Running Slow? Here's What Actually Fixes It.
Every growing business hits this wall at some point. The application that worked perfectly six months ago now takes forever to load. Users start compl…
Finding a Practical Analytics Format for Structured JSON Logs
Structured JSON logs are easy to produce and hard to analyze at scale. They carry useful context, but that context is nested, optional, inconsistent, …
Subqueries vs CTEs: When, Why, How.
With a background in Python programming, Learning SQL started feeling like a step back, every line is independent of the next and so far nothing seeme…
Understanding Subqueries vs CTEs in SQL (With Examples)
When working with SQL, especially in data analysis, you’ll often need to break down complex queries into manageable pieces. Two powerful tools that he…
How I Started Thinking in SQL (Not Just Writing Queries)
When I first started learning SQL, everything felt mechanical. Write a query. Run it. Get results. But something was missing. I wasn’t really understa…
Subqueries and CTEs in SQL
When working with SQL, you eventually run into situations where a single query just isn’t enough. You need to break a problem into parts, compute an i…
SQL Window Functions and CTEs
You can do quite a lot with some of the most popular SQL queries such as SELECT, WHERE, and JOIN. But there exists some question that you cannot answe…
Indexing Strategies for Faster Database Queries
TL;DR Indexes = direct lookups — milliseconds vs full table scans (seconds). B-tree for most queries — Supports = , < , > , BETWEEN , LIKE 'pref…
Mastering SQL Joins: A Practical Guide for beginners.
Introduction SQL joins allow you to combine data from multiple tables based on relationships between them. In this article, we’ll explore different ty…
PostgreSQL INT4RANGE: Enforce non-overlapping zones in SQL
Originally written by Omar Tarek , Software Developer at Stackdrop. Posted here with his permission. When you need to assign geographic zones to recor…
Your Latency Problem Isn't Model Size (It’s Your Routing)
We spent months chasing latency. Bigger GPUs, smaller batch sizes, every optimization trick in the book. Yet, our chatbot still crawled at 3s+ per res…
greatCircleDistance in ClickHouse: Avoiding Full Table Scans
When working with location data, one problem shows up almost immediately: “How do I calculate the distance between two coordinates stored in my databa…
Up down or Down up. Understanding Subqueries and CTEs in SQL: A Comprehensive Guide
Introduction When working with databases, there comes a time when a simple SELECT statement is not enough to answer complex questions. Imagine you nee…
SQL vs NoSQL — A Decision Framework That Actually Works
Every developer argues about SQL vs NoSQL. Most of the advice online is surface-level. Here's a practical decision framework based on how real systems…
5 SQL FUNCTIONS EVERY BEGINNER SHOULD KNOW
"Data is the new oil — and SQL is the refinery." — Anonymous Data Engineer Image: A developer working with databases — the everyday environment of an …
Mastering the SQL Analytical Toolkit
As a budding data professional, I recently completed an intensive SQL Week 2 Assignment that pushed me from basic queries into more powerful territory…
Coding Cat Oran Ep5, The IT Manager Nobody Hired
Six months at Rust-Belt Manufacturing. The permission system was running. Inventory was live. The approval workflow hadn't broken once. The GM called …
Stop Collapsing Your Data: Why Window Functions Are a Game Changer
If you've been learning SQL for a few weeks, you're probably comfortable with GROUP BY . It's the bread and butter of data analysis. But have you ever…
Level Up Your SQL: Subqueries & CTEs in the Real World
In the first SQL article, you met the basics: tables, data types, simple SELECT s, and filters. Now you’re ready for the point where “one query” quiet…
SQL for Beginners: Essential Concepts Made Simple
SQL stands for Structured Query Language. It is the standard language used to communicate with databases. Think of SQL as the "English" you speak to a…
Subqueries vs CTEs in SQL: A Complete Guide for Beginners
When I first started learning SQL, I kept hearing two terms thrown around: subqueries and CTEs . They seemed to do similar things, and I wasn't sure w…
SQL Functions You Will Actually Use in Data Work
Most SQL tutorials stop at SELECT, WHERE, and GROUP BY. That covers retrieval, but it does not cover the layer of work that happens between raw data a…