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.
Database 101: Data Consistency for Beginners

Database 101: Data Consistency for Beginners

467
Comments 44
7 min read
Count(*) vs Count(1) in SQL

Count(*) vs Count(1) in SQL

399
Comments 18
3 min read
Database Naming Standards

Database Naming Standards

324
Comments 20
6 min read
Advanced SQL: Mastering Query Optimization and Complex Joins

Advanced SQL: Mastering Query Optimization and Complex Joins

264
Comments 19
7 min read
PostgreSQL 16 Installation on Ubuntu 22.04

PostgreSQL 16 Installation on Ubuntu 22.04

234
Comments 14
2 min read
SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev

SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev

211
Comments 32
2 min read
Database GUIs in JavaScript

Database GUIs in JavaScript

189
Comments 13
5 min read
Mastering SQL: Comprehensive Guide To Structured Query Language

Mastering SQL: Comprehensive Guide To Structured Query Language

173
Comments 7
5 min read
Should I use SQLite, PostgreSQL, or MySQL?

Should I use SQLite, PostgreSQL, or MySQL?

172
Comments 26
5 min read
Your Old Laptop Is Your New Database Server

Your Old Laptop Is Your New Database Server

166
Comments 12
8 min read
Flutter database inspector storage_view

Flutter database inspector storage_view

149
Comments 8
2 min read
Improving Performance of PostgreSQL queries

Improving Performance of PostgreSQL queries

147
Comments 15
4 min read
Guide To Choose A Database For Your Next Design

Guide To Choose A Database For Your Next Design

137
Comments 5
5 min read
Preventing SQL Injection with Golang

Preventing SQL Injection with Golang

130
Comments 7
8 min read
Using migrations with Golang

Using migrations with Golang

122
Comments 1
5 min read
TypeORM - Query Builder with Subquery

TypeORM - Query Builder with Subquery

121
Comments 5
6 min read
🚀 The Missing SQL Basics Crash Course

🚀 The Missing SQL Basics Crash Course

116
Comments 12
12 min read
What exactly does Indexing in a Database do?

What exactly does Indexing in a Database do?

114
Comments 4
2 min read
Translating Database Queries

Translating Database Queries

110
Comments 3
3 min read
Database Tools 🛢️🔧 in 2024: A Year in Review 🗓️

Database Tools 🛢️🔧 in 2024: A Year in Review 🗓️

106
Comments 4
3 min read
5-Week Data Career Boot Camp: Orientation and Foundations.

5-Week Data Career Boot Camp: Orientation and Foundations.

106
Comments 1
3 min read
Awesome SQL Code Review Tools for Developers

Awesome SQL Code Review Tools for Developers

104
Comments 6
4 min read
Why you should never use an UUID as the primary key in SQL Databases

Why you should never use an UUID as the primary key in SQL Databases

104
Comments 66
2 min read
How SQL Query works? SQL Query Execution Order for Tech Interview

How SQL Query works? SQL Query Execution Order for Tech Interview

101
Comments 4
9 min read
Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

100
Comments 6
12 min read
loading...