Forem

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.
La Trampa de la Sobre-Normalización

La Trampa de la Sobre-Normalización

4
Comments 2
9 min read
How to Document SQL Server Schemas Visually in 2025
Cover image for How to Document SQL Server Schemas Visually in 2025

How to Document SQL Server Schemas Visually in 2025

12
Comments 1
4 min read
Design Your Database with dbdiagram.io (Beginner to Pro)
Cover image for Design Your Database with dbdiagram.io (Beginner to Pro)

Design Your Database with dbdiagram.io (Beginner to Pro)

7
Comments
3 min read
SQL vs NoSQL? Why Not Both?

SQL vs NoSQL? Why Not Both?

Comments 1
2 min read
PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 1
Cover image for PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 1

PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 1

16
Comments
12 min read
Database optimization best practices
Cover image for Database optimization best practices

Database optimization best practices

Comments
3 min read
What’s the Difference Between IS NULL and = NULL in a MySQL WHERE Clause?

What’s the Difference Between IS NULL and = NULL in a MySQL WHERE Clause?

2
Comments 2
1 min read
SQL COALESCE Explained: Simplify NULL Handling in Queries

SQL COALESCE Explained: Simplify NULL Handling in Queries

Comments
3 min read
ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools
Cover image for ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools

ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools

Comments
2 min read
จัดการข้อมูล Mac Address ให้อยู่หมัดด้วย PostgreSQL
Cover image for จัดการข้อมูล Mac Address ให้อยู่หมัดด้วย PostgreSQL

จัดการข้อมูล Mac Address ให้อยู่หมัดด้วย PostgreSQL

Comments
1 min read
A COMPREHENSIVE LOOK INTO SQL : - What a Beginner can learn
Cover image for A COMPREHENSIVE LOOK INTO SQL : - What a Beginner can learn

A COMPREHENSIVE LOOK INTO SQL : - What a Beginner can learn

2
Comments
5 min read
How to Design a Relational Database Schema in 2025
Cover image for How to Design a Relational Database Schema in 2025

How to Design a Relational Database Schema in 2025

17
Comments 1
8 min read
Automating SQL Reports Without Power BI or SSRS: A Lightweight Alternative
Cover image for Automating SQL Reports Without Power BI or SSRS: A Lightweight Alternative

Automating SQL Reports Without Power BI or SSRS: A Lightweight Alternative

4
Comments 3
4 min read
OUTPUT Clause — Log, Sync, and Debug Like a Pro

OUTPUT Clause — Log, Sync, and Debug Like a Pro

Comments
6 min read
SQL Server String Aggregation: FOR XML PATH vs. STRING_AGG Performance Comparison and Optimization
Cover image for SQL Server String Aggregation: FOR XML PATH vs. STRING_AGG Performance Comparison and Optimization

SQL Server String Aggregation: FOR XML PATH vs. STRING_AGG Performance Comparison and Optimization

Comments
4 min read
Segmented Accumulation by Condition — From SQL to SPL #30
Cover image for Segmented Accumulation by Condition — From SQL to SPL #30

Segmented Accumulation by Condition — From SQL to SPL #30

6
Comments 1
1 min read
Memelang: Hybrid graph-relational query language for RAG

Memelang: Hybrid graph-relational query language for RAG

Comments
4 min read
Spark Augmented Reality (AR) Filter Engagement Metrics
Cover image for Spark Augmented Reality (AR) Filter Engagement Metrics

Spark Augmented Reality (AR) Filter Engagement Metrics

1
Comments
3 min read
PawSQL Community Edition: A Free & Self-Hosted Enterprise-Grade SQL Optimizer, Now Available to Individual Developers
Cover image for PawSQL Community Edition: A Free & Self-Hosted Enterprise-Grade SQL Optimizer, Now Available to Individual Developers

PawSQL Community Edition: A Free & Self-Hosted Enterprise-Grade SQL Optimizer, Now Available to Individual Developers

2
Comments
3 min read
MySQL — Removendo Full Only Group By no MacOS X

MySQL — Removendo Full Only Group By no MacOS X

Comments 1
1 min read
🔷 Top 20+ .NET & OOPs Interview Questions (Easy Guide for Freshers)
Cover image for 🔷 Top 20+ .NET & OOPs Interview Questions (Easy Guide for Freshers)

🔷 Top 20+ .NET & OOPs Interview Questions (Easy Guide for Freshers)

4
Comments
3 min read
Query YAML Like a Database — Why I Built YamlQL (And How It Works)
Cover image for Query YAML Like a Database — Why I Built YamlQL (And How It Works)

Query YAML Like a Database — Why I Built YamlQL (And How It Works)

3
Comments
4 min read
What is SQL and Why Does It Matter

What is SQL and Why Does It Matter

Comments
2 min read
Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41
Cover image for Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41

Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41

10
Comments 3
2 min read
Query Optimization Isn’t Optional—It’s Profit

Query Optimization Isn’t Optional—It’s Profit

Comments
3 min read
loading...