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.
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

23
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

10
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

4
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
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
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
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
Get started with MySQL | Mini-Guide

Get started with MySQL | Mini-Guide

10
Comments
14 min read
Designing Schemas for Relational Databases

Designing Schemas for Relational Databases

11
Comments
4 min read
Comparing aggregated data to unaggregated data in SQL

Comparing aggregated data to unaggregated data in SQL

3
Comments
5 min read
Watch OVER your WINDOW of opportunities

Watch OVER your WINDOW of opportunities

8
Comments
3 min read
SQL Dump in Docker

SQL Dump in Docker

6
Comments
1 min read
Serverless REST API with Azure Functions, Node, JSON and Azure SQL

Serverless REST API with Azure Functions, Node, JSON and Azure SQL

64
Comments
6 min read
MySQL Command Notes

MySQL Command Notes

4
Comments
1 min read
A new way of tokenization of Chinese or How to make Chinese full-text search

A new way of tokenization of Chinese or How to make Chinese full-text search

23
Comments 3
5 min read
Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – Sep 9, 2020

Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – Sep 9, 2020

6
Comments 1
5 min read
What is a Database Query? SQL and NoSQL queries explained

What is a Database Query? SQL and NoSQL queries explained

17
Comments
7 min read
Guide to Cyber Security: learn how to defend your systems

Guide to Cyber Security: learn how to defend your systems

17
Comments
10 min read
How to find SQL Server database Restore and Recovery time ?

How to find SQL Server database Restore and Recovery time ?

6
Comments
1 min read
Database Version Control With Liquibase

Database Version Control With Liquibase

6
Comments
4 min read
SQL Server Service Broker for Asynchronous Applications

SQL Server Service Broker for Asynchronous Applications

8
Comments
7 min read
Synchronize Databases with Only Five Lines of Code

Synchronize Databases with Only Five Lines of Code

59
Comments 3
2 min read
Replicating Azure SQL DB Instances on the fly for SaaS apps

Replicating Azure SQL DB Instances on the fly for SaaS apps

1
Comments
2 min read
The Easy Way to Find Customers Likely to Churn

The Easy Way to Find Customers Likely to Churn

23
Comments
4 min read
Important TIPs for SQL Database Design

Important TIPs for SQL Database Design

7
Comments 2
7 min read
Practical Azure SQL Database for Modern Developers

Practical Azure SQL Database for Modern Developers

14
Comments
4 min read
How to Measure Cohort Retention using BigQuery

How to Measure Cohort Retention using BigQuery

9
Comments
5 min read
Postgres concat_ws() function

Postgres concat_ws() function

1
Comments
1 min read
[PT-BR] Join SQL, quando usar?

[PT-BR] Join SQL, quando usar?

51
Comments 12
2 min read
SQL Tips & Tricks: Counting Rows

SQL Tips & Tricks: Counting Rows

5
Comments
5 min read
Machete MySQL(Cheatsheet) level 1

Machete MySQL(Cheatsheet) level 1

6
Comments
3 min read
Reading a datetime with miliseconds into an Oracle DATE

Reading a datetime with miliseconds into an Oracle DATE

6
Comments
2 min read
MySQL Commands You Need To Know To Create A New User

MySQL Commands You Need To Know To Create A New User

10
Comments 1
2 min read
SQL Practice Problem to Help You Pass Your Interview

SQL Practice Problem to Help You Pass Your Interview

18
Comments 5
3 min read
Switching the offset for a UTC date in SQL Server

Switching the offset for a UTC date in SQL Server

2
Comments
2 min read
Reports performance improvement

Reports performance improvement

7
Comments
1 min read
First impressions of PopSQL’s collaborative SQL editor

First impressions of PopSQL’s collaborative SQL editor

44
Comments 1
4 min read
Getting to know SQL Server Extended Events

Getting to know SQL Server Extended Events

26
Comments
7 min read
Code-First ORM For Go: GORM

Code-First ORM For Go: GORM

9
Comments
3 min read
Distributed SQL Tips and Tricks – Aug 17, 2020

Distributed SQL Tips and Tricks – Aug 17, 2020

2
Comments
4 min read
SQL Cheatsheet - Most Common Commands

SQL Cheatsheet - Most Common Commands

18
Comments 1
13 min read
How to ace coding interviews. The ultimate guide.

How to ace coding interviews. The ultimate guide.

80
Comments
14 min read
Don't ever use LIMIT again!!!

Don't ever use LIMIT again!!!

6
Comments 1
5 min read
Convince me to use SQL

Convince me to use SQL

29
Comments 17
1 min read
Alembic: setting a column to nullable=False if it already has data in it

Alembic: setting a column to nullable=False if it already has data in it

6
Comments 1
2 min read
Doing the Impossible, using ASSISTANT to make a SQL Linter (and how you can make it lint whatever you want)

Doing the Impossible, using ASSISTANT to make a SQL Linter (and how you can make it lint whatever you want)

48
Comments 1
7 min read
Azure SQL for Beginners - Video Playlist

Azure SQL for Beginners - Video Playlist

28
Comments
1 min read
SQL Server Profiler, underused and undervalued

SQL Server Profiler, underused and undervalued

8
Comments
5 min read
Why SQLite is simple to use!

Why SQLite is simple to use!

6
Comments 2
2 min read
DataGrip: Exporting Data as SQL Batch Inserts (and more)

DataGrip: Exporting Data as SQL Batch Inserts (and more)

8
Comments
2 min read
Version Control for Distributed SQL Databases with Flyway

Version Control for Distributed SQL Databases with Flyway

3
Comments
6 min read
Should I Take the Data Engineer Nano Degree?

Should I Take the Data Engineer Nano Degree?

4
Comments 2
3 min read
loading...