DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Advanced SQL for Data Analytics: Advanced Techniques Every Data Analyst Should Know

Advanced SQL for Data Analytics: Advanced Techniques Every Data Analyst Should Know

1
Comments
6 min read
Databricks SQL Essentials - CTE

Databricks SQL Essentials - CTE

Comments
3 min read
PostgreSQL vs MySQL vs SQL Server: Enterprise Database Decision Guide

PostgreSQL vs MySQL vs SQL Server: Enterprise Database Decision Guide

1
Comments
11 min read
SQL Joins & Window Functions

SQL Joins & Window Functions

2
Comments
2 min read
Why Production Databases Break Normalization (And Why That's Okay)

Why Production Databases Break Normalization (And Why That's Okay)

4
Comments
8 min read
Part 2: BigQuery Deep Dive 🔍

Part 2: BigQuery Deep Dive 🔍

Comments
4 min read
Part 3: Partitioning & Clustering for Performance 🚀

Part 3: Partitioning & Clustering for Performance 🚀

Comments
7 min read
PostgreSQL vs MySQL vs MongoDB: The Definitive Database Comparison

PostgreSQL vs MySQL vs MongoDB: The Definitive Database Comparison

3
Comments
15 min read
Monitoring TimescaleDB in Production: A Complete Checklist

Monitoring TimescaleDB in Production: A Complete Checklist

2
Comments
4 min read
Day 2: Advanced SQL Preparation Guide

Day 2: Advanced SQL Preparation Guide

Comments
6 min read
Understanding `GROUP BY` in SQL

Understanding `GROUP BY` in SQL

8
Comments
6 min read
SQLite as an MCP context saver: stop cramming raw API data into your LLM

SQLite as an MCP context saver: stop cramming raw API data into your LLM

21
Comments 14
9 min read
SQL Injection – querying the database type and version | PortSwigger Lab Note #6

SQL Injection – querying the database type and version | PortSwigger Lab Note #6

6
Comments 1
1 min read
From Zero to Cached: Building a High-Performance Housing Portal with Django, Next.js, and Redis - Part 4 : Optimization Pillars

From Zero to Cached: Building a High-Performance Housing Portal with Django, Next.js, and Redis - Part 4 : Optimization Pillars

Comments
17 min read
DuckDB 1.5.0 Released: New Features and Tools Enhance Performance and Functionality

DuckDB 1.5.0 Released: New Features and Tools Enhance Performance and Functionality

1
Comments 1
9 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.