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.
The Interview Study Guide For Software Engineers

The Interview Study Guide For Software Engineers

2392
Comments 92
12 min read
Database 101: Data Consistency for Beginners

Database 101: Data Consistency for Beginners

435
Comments 43
7 min read
1 SQL Query You Should Stop Using

1 SQL Query You Should Stop Using

369
Comments 43
3 min read
How to set up a free PostgreSQL database on Heroku

How to set up a free PostgreSQL database on Heroku

366
Comments 13
3 min read
Improving PostgreSQL queries

Improving PostgreSQL queries

232
Comments 6
23 min read
Data Science Interview Study Guide

Data Science Interview Study Guide

231
Comments 2
12 min read
Entity Relationship Diagrams explained by Sonic the Hedgehog

Entity Relationship Diagrams explained by Sonic the Hedgehog

226
Comments 11
2 min read
When to choose NoSQL over SQL?

When to choose NoSQL over SQL?

210
Comments 22
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

209
Comments 31
2 min read
Tips on Designing a Million Dollar Dashboard

Tips on Designing a Million Dollar Dashboard

203
Comments 9
7 min read
A mini-guide — Build a REST API as a Go microservice together with MySQL

A mini-guide — Build a REST API as a Go microservice together with MySQL

199
Comments 4
4 min read
Database GUIs in JavaScript

Database GUIs in JavaScript

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

Should I use SQLite, PostgreSQL, or MySQL?

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

Your Old Laptop Is Your New Database Server

165
Comments 12
8 min read
Top 5 Online Courses to Learn SQL and Database for Beginners - Best of Lot

Top 5 Online Courses to Learn SQL and Database for Beginners - Best of Lot

164
Comments 5
10 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 1
9 min read
Flutter database inspector storage_view

Flutter database inspector storage_view

145
Comments 8
2 min read
Why ORMs Aren't Always a Great Idea

Why ORMs Aren't Always a Great Idea

138
Comments 48
9 min read
SQL injection for developers

SQL injection for developers

128
Comments 5
12 min read
How to ace coding interviews; and scaling tips from Netflix & Shopify

How to ace coding interviews; and scaling tips from Netflix & Shopify

123
Comments
2 min read
🚀 The Missing SQL Basics Crash Course

🚀 The Missing SQL Basics Crash Course

116
Comments 11
12 min read
Learn Web Development for Free

Learn Web Development for Free

115
Comments 6
8 min read
What exactly does Indexing in a Database do?

What exactly does Indexing in a Database do?

114
Comments 4
2 min read
SQL Joins without the Venn diagrams

SQL Joins without the Venn diagrams

111
Comments 5
3 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

108
Comments 29
14 min read
Translating Database Queries

Translating Database Queries

108
Comments 3
3 min read
Dynamically generating SQL queries using Node.js

Dynamically generating SQL queries using Node.js

104
Comments 26
6 min read
SQL Basics for Beginners

SQL Basics for Beginners

100
Comments 4
3 min read
I built my own VS Code Syntax Highlighter from scratch and here's what I learned.

I built my own VS Code Syntax Highlighter from scratch and here's what I learned.

100
Comments 15
4 min read
Creating a Simple Contacts List with Go and PostgreSQL

Creating a Simple Contacts List with Go and PostgreSQL

100
Comments
10 min read
Data Engineering 101: Automating Your First Data Extract

Data Engineering 101: Automating Your First Data Extract

99
Comments
7 min read
SQL is (almost) always superior to NoSQL

SQL is (almost) always superior to NoSQL

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

PostgreSQL Tutorial for beginners to Advance level.

95
Comments 2
18 min read
Learn SQL Injection by hacking a bank app

Learn SQL Injection by hacking a bank app

94
Comments 4
7 min read
Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

92
Comments 6
12 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
Secret To Optimizing SQL Queries - Understand The SQL Execution Order 🚀

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

91
Comments 2
5 min read
Simplify Complex SQL Queries with Common Table Expressions (CTEs)

Simplify Complex SQL Queries with Common Table Expressions (CTEs)

89
Comments 16
2 min read
Preventing SQL Injection with Golang

Preventing SQL Injection with Golang

87
Comments 7
8 min read
TypeORM - Query Builder with Subquery

TypeORM - Query Builder with Subquery

87
Comments 5
6 min read
HarperDB vs. MongoDB vs. PostgreSQL

HarperDB vs. MongoDB vs. PostgreSQL

85
Comments 7
6 min read
The Top 10 GitHub Repositories Making Waves 🌊📊

The Top 10 GitHub Repositories Making Waves 🌊📊

84
Comments 8
4 min read
Conway's game of life...in pure SQL [Postgres]! 💪🏼🤯

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

83
Comments 19
9 min read
Programming Paradigm

Programming Paradigm

83
Comments 9
4 min read
Understanding SQL Server Deadlocks

Understanding SQL Server Deadlocks

82
Comments 1
5 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

81
Comments 7
29 min read
Fuzzy Searching with PostgreSQL

Fuzzy Searching with PostgreSQL

80
Comments 4
6 min read
How to ace coding interviews. The ultimate guide.

How to ace coding interviews. The ultimate guide.

80
Comments
14 min read
Design your SQL database visually

Design your SQL database visually

78
Comments
3 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
Creating a SQL generator app with ChatGPT, PostgreSQL, and ToolJet

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

78
Comments 17
7 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: Outer Joins

SQL: Outer Joins

76
Comments 10
4 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
🚀 3 Tools To Scale and Grow Your Side Projects

🚀 3 Tools To Scale and Grow Your Side Projects

73
Comments 11
3 min read
Airbnb’s Airflow Versus Spotify’s Luigi

Airbnb’s Airflow Versus Spotify’s Luigi

73
Comments
7 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

72
Comments 66
2 min read
AlaSQL in Action: The JavaScript SQL Database

AlaSQL in Action: The JavaScript SQL Database

71
Comments
3 min read
loading...