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.
DynamoDB or PostgreSQL???

DynamoDB or PostgreSQL???

4
Comments 1
1 min read
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
IT Staff Augmentation Services- Enhance Your Business Growth With the Top Class Tech Talent

IT Staff Augmentation Services- Enhance Your Business Growth With the Top Class Tech Talent

6
Comments 2
4 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
Normality for a Flexible World

Normality for a Flexible World

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

Common SQL Injections to Watch Out For

8
Comments
2 min read
Should I use SQL Views With ORM frameworks?

Should I use SQL Views With ORM frameworks?

3
Comments 1
1 min read
Prevent Hibernate from doing N+1 selects with constructor expression

Prevent Hibernate from doing N+1 selects with constructor expression

2
Comments
6 min read
Vaccines for Common SQL Injection Bugs

Vaccines for Common SQL Injection Bugs

4
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
Se conectando ao PostgreSQL usando Golang

Se conectando ao PostgreSQL usando Golang

29
Comments 4
11 min read
Django ORM Optimization Tips #2 prefetch_related

Django ORM Optimization Tips #2 prefetch_related

14
Comments 1
2 min read
Relative calculations 1: LAG and LEAD

Relative calculations 1: LAG and LEAD

5
Comments
5 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
SQL: comandos básicos

SQL: comandos básicos

6
Comments
4 min read
On why wasting 0.000005 seconds is still bad idea

On why wasting 0.000005 seconds is still bad idea

27
Comments 1
5 min read
loading...