Skip to content

Forem

select * from SQL

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

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Cover image for PostgreSQL vs MySQL in 2026: Performance, Features and When to Use Each

Philip McClarence

Mar 1

PostgreSQL vs MySQL in 2026: Performance, Features and When to Use Each

#database #performance #postgres #sql

10 min read

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

Mar 11

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

#sql #data #analytics #database

6 min read

Matt Rueedlinger

Feb 6

Databricks SQL Essentials - CTE

#beginners #dataengineering #sql #tutorial

3 min read

Mar 11

SQL Joins & Window Functions

#sql #postgres #postgressql

2 min read

Ayush Shrivastav

Mar 11

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

#architecture #database #sql #systemdesign

8 min read

Abdelrahman Adnan

Feb 9

Part 2: BigQuery Deep Dive 🔍

#beginners #database #googlecloud #sql

4 min read

Abdelrahman Adnan

Feb 9

Part 3: Partitioning & Clustering for Performance 🚀

#dataengineering #googlecloud #performance #sql

7 min read

Cover image for PostgreSQL vs MySQL vs MongoDB: The Definitive Database Comparison

Philip McClarence

Mar 11

PostgreSQL vs MySQL vs MongoDB: The Definitive Database Comparison

#database #mongodb #postgres #sql

15 min read

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

Mar 4

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

#ai #mcp #sql

9 min read

Cover image for Day 2: Advanced SQL Preparation Guide

Feb 5

Day 2: Advanced SQL Preparation Guide

#dataengineering #sql

6 min read

Mar 8

Understanding `GROUP BY` in SQL

#sql

6 min read

Mar 10

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

#database #security #sql #tutorial

1 min read

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

Ajit Kumar

Feb 4

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

#django #python #sql #redis

17 min read

Cover image for How to Turn Slow Queries into Actionable Reliability Metrics with OpenTelemetry

Severin Neumann for Causely

Feb 4

How to Turn Slow Queries into Actionable Reliability Metrics with OpenTelemetry

#opentelemetry #sql #postgres

11 min read

Mar 10

Guide to Connecting Power BI to SQL Databases: Local & Cloud Workflows

#database #microsoft #sql #tutorial

5 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.