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

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

Count(*) vs Count(1) in SQL

399
Comments 18
3 min read
1 SQL Query You Should Stop Using

1 SQL Query You Should Stop Using

369
Comments 43
3 min read
Advanced SQL: Mastering Query Optimization and Complex Joins

Advanced SQL: Mastering Query Optimization and Complex Joins

262
Comments 19
7 min read
Database Naming Standards

Database Naming Standards

247
Comments 20
6 min read
How to set up a free PostgreSQL database on Heroku

How to set up a free PostgreSQL database on Heroku

233
Comments 13
3 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
When to choose NoSQL over SQL?

When to choose NoSQL over SQL?

210
Comments 22
2 min read
PostgreSQL 16 Installation on Ubuntu 22.04

PostgreSQL 16 Installation on Ubuntu 22.04

194
Comments 12
2 min read
Database GUIs in JavaScript

Database GUIs in JavaScript

188
Comments 13
5 min read
Should I use SQLite, PostgreSQL, or MySQL?

Should I use SQLite, PostgreSQL, or MySQL?

169
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
Mastering SQL: Comprehensive Guide To Structured Query Language

Mastering SQL: Comprehensive Guide To Structured Query Language

165
Comments 6
5 min read
8 New SQL Tools That Will Change How You Work in 2020

8 New SQL Tools That Will Change How You Work in 2020

163
Comments 7
6 min read
Database Design Tutorial

Database Design Tutorial

158
Comments 2
9 min read
Flutter database inspector storage_view

Flutter database inspector storage_view

148
Comments 8
2 min read
Guide To Choose A Database For Your Next Design

Guide To Choose A Database For Your Next Design

136
Comments 5
5 min read
Improving Performance of PostgreSQL queries

Improving Performance of PostgreSQL queries

134
Comments 15
4 min read
SQL injection for developers

SQL injection for developers

128
Comments 5
12 min read
Learn Web Development for Free

Learn Web Development for Free

121
Comments 6
8 min read
TypeORM - Query Builder with Subquery

TypeORM - Query Builder with Subquery

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

🚀 The Missing SQL Basics Crash Course

116
Comments 11
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
How to Install Oracle SQL Developer on Ubuntu 20.04

How to Install Oracle SQL Developer on Ubuntu 20.04

110
Comments 36
4 min read
Translating Database Queries

Translating Database Queries

110
Comments 3
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
Preventing SQL Injection with Golang

Preventing SQL Injection with Golang

105
Comments 7
8 min read
[PT-BR] Funcionalidades do DBeaver

[PT-BR] Funcionalidades do DBeaver

102
Comments 6
2 min read
Data Engineering 101: Automating Your First Data Extract

Data Engineering 101: Automating Your First Data Extract

101
Comments
7 min read
SQL Basics for Beginners

SQL Basics for Beginners

100
Comments 4
3 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

98
Comments 66
2 min read
Awesome SQL Code Review Tools for Developers

Awesome SQL Code Review Tools for Developers

98
Comments 6
4 min read
Secret To Optimizing SQL Queries - Understand The SQL Execution Order 🚀

Secret To Optimizing SQL Queries - Understand The SQL Execution Order 🚀

97
Comments 2
5 min read
Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

96
Comments 6
12 min read
SQL is (almost) always superior to NoSQL

SQL is (almost) always superior to NoSQL

96
Comments 29
4 min read
Learn SQL Injection by hacking a bank app

Learn SQL Injection by hacking a bank app

95
Comments 4
7 min read
PostgreSQL Tutorial for beginners to Advance level.

PostgreSQL Tutorial for beginners to Advance level.

95
Comments 2
18 min read
How SQL Query works? SQL Query Execution Order for Tech Interview

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

95
Comments 4
9 min read
4 SQL Tips For Data Scientists And Data Analysts

4 SQL Tips For Data Scientists And Data Analysts

91
Comments 4
7 min read
Simplify Complex SQL Queries with Common Table Expressions (CTEs)

Simplify Complex SQL Queries with Common Table Expressions (CTEs)

90
Comments 16
2 min read
Creating a SQL generator app with ChatGPT, PostgreSQL, and ToolJet

Creating a SQL generator app with ChatGPT, PostgreSQL, and ToolJet

88
Comments 17
7 min read
Beginner's guide to using MySQL database in a Node.js app

Beginner's guide to using MySQL database in a Node.js app

87
Comments 7
29 min read
Conway's game of life...in pure SQL [Postgres]! 💪🏼🤯

Conway's game of life...in pure SQL [Postgres]! 💪🏼🤯

85
Comments 20
9 min read
HarperDB vs. MongoDB vs. PostgreSQL

HarperDB vs. MongoDB vs. PostgreSQL

85
Comments 7
6 min read
Programming Paradigm

Programming Paradigm

85
Comments 9
4 min read
The Top 10 GitHub Repositories Making Waves 🌊📊

The Top 10 GitHub Repositories Making Waves 🌊📊

85
Comments 8
4 min read
Using migrations with Golang

Using migrations with Golang

81
Comments
5 min read
How to export and import data in DBeaver

How to export and import data in DBeaver

81
Comments 2
1 min read
How to ace coding interviews. The ultimate guide.

How to ace coding interviews. The ultimate guide.

80
Comments
14 min read
Fuzzy Searching with PostgreSQL

Fuzzy Searching with PostgreSQL

80
Comments 4
6 min read
Why You Shouldn't Use OFFSET and LIMIT For Your Pagination

Why You Shouldn't Use OFFSET and LIMIT For Your Pagination

78
Comments 26
5 min read
Big Data from the Ground up

Big Data from the Ground up

78
Comments 2
7 min read
Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service

Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service

76
Comments 29
14 min read
YEStifications: Exploring how users engage with notification prompts in the Chrome UX Report

YEStifications: Exploring how users engage with notification prompts in the Chrome UX Report

76
Comments 6
6 min read
SQL JOIN explained

SQL JOIN explained

74
Comments 4
13 min read
How to build a Data Pipeline for the first time

How to build a Data Pipeline for the first time

74
Comments 10
5 min read
Join Elimination - Advanced SQL tuning

Join Elimination - Advanced SQL tuning

73
Comments 1
3 min read
🚀 3 Tools To Scale and Grow Your Side Projects

🚀 3 Tools To Scale and Grow Your Side Projects

73
Comments 11
3 min read
AlaSQL in Action: The JavaScript SQL Database

AlaSQL in Action: The JavaScript SQL Database

72
Comments
3 min read
Resolvendo problema de performance no PostgreSQL com CTE

Resolvendo problema de performance no PostgreSQL com CTE

72
Comments 6
4 min read
loading...