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.
Design Your Database with dbdiagram.io (Beginner to Pro)

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

12
Comments
3 min read
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

Database optimization best practices

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

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

Comments
1 min read
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

How to Design a Relational Database Schema in 2025

17
Comments 1
8 min read
Spark Augmented Reality (AR) Filter Engagement Metrics

Spark Augmented Reality (AR) Filter Engagement Metrics

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

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

12
Comments
3 min read
N+1 Query Problem

N+1 Query Problem

8
Comments
1 min read
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
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
Best Oracle Database Design Tools in 2025

Best Oracle Database Design Tools in 2025

13
Comments 8
7 min read
How to Document a PostgreSQL Schema in 2025

How to Document a PostgreSQL Schema in 2025

13
Comments 1
4 min read
Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40

Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40

11
Comments 3
2 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.