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.
Don't store null bits

Don't store null bits

7
Comments
4 min read
N + What? (Or: a brief introduction to n + 1 queries and how to avoid them)

N + What? (Or: a brief introduction to n + 1 queries and how to avoid them)

10
Comments
5 min read
What is database indexing and how it works

What is database indexing and how it works

6
Comments 1
2 min read
The Complexity of Active Record Transactions

The Complexity of Active Record Transactions

9
Comments 2
7 min read
Common SQL Injections to Watch Out For

Common SQL Injections to Watch Out For

8
Comments
2 min read
Django ORM Optimization Tips #3 aggregation

Django ORM Optimization Tips #3 aggregation

10
Comments 1
3 min read
SQL Join

SQL Join

8
Comments 1
3 min read
Django ORM Optimization Tips #2 prefetch_related

Django ORM Optimization Tips #2 prefetch_related

14
Comments 1
2 min read
Django ORM Optimization Tips #1 select_related

Django ORM Optimization Tips #1 select_related

9
Comments 2
1 min read
Node.js with SQLite

Node.js with SQLite

8
Comments 3
3 min read
Node js Left Join with limit and offset Mysql

Node js Left Join with limit and offset Mysql

5
Comments
1 min read
7 rules for designing your first database schema or data model

7 rules for designing your first database schema or data model

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

91
Comments 7
29 min read
TodoMVC Full Stack with Azure Static WebApps, Node and Azure SQL

TodoMVC Full Stack with Azure Static WebApps, Node and Azure SQL

23
Comments
9 min read
SQLAlchemy Table Relationships

SQLAlchemy Table Relationships

22
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.