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.
Translating Database Queries

Translating Database Queries

108
Comments 3
3 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
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
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
Awesome SQL Code Review Tools for Developers

Awesome SQL Code Review Tools for Developers

67
Comments 6
4 min read
CRUD and SQL - the basics!

CRUD and SQL - the basics!

61
Comments 9
5 min read
How Modern SQL Databases Are Changing Web Development - #4 Into the AI Era

How Modern SQL Databases Are Changing Web Development - #4 Into the AI Era

57
Comments
5 min read
Introduction to SQL for Absolute Beginners!

Introduction to SQL for Absolute Beginners!

54
Comments 11
4 min read
18 GitHub Repositories You Need to Star Right Now! 🌟🔥

18 GitHub Repositories You Need to Star Right Now! 🌟🔥

54
Comments 5
4 min read
My Favorite Free Courses to Learn Data Science in Depth

My Favorite Free Courses to Learn Data Science in Depth

51
Comments 3
15 min read
API completa em Golang - Parte 7

API completa em Golang - Parte 7

49
Comments 5
22 min read
UUID in PostgreSQL

UUID in PostgreSQL

43
Comments 7
5 min read
Exploring Advanced and Modern Concepts in SQL with Practical Examples.

Exploring Advanced and Modern Concepts in SQL with Practical Examples.

40
Comments 13
4 min read
Difference between WHERE vs HAVING Clause in SQL

Difference between WHERE vs HAVING Clause in SQL

40
Comments 1
3 min read
How Modern SQL Databases Are Changing Web Development - #2 New Ways to Program

How Modern SQL Databases Are Changing Web Development - #2 New Ways to Program

38
Comments 1
5 min read
Garanta a Eficiência: Escolhendo entre tipos String no SQL

Garanta a Eficiência: Escolhendo entre tipos String no SQL

35
Comments 7
4 min read
SQL Injection Isn't Dead Yet

SQL Injection Isn't Dead Yet

35
Comments 1
6 min read
🏁🐘Winning Race Conditions With PostgreSQL

🏁🐘Winning Race Conditions With PostgreSQL

34
Comments 2
10 min read
ORM vs Pure SQL: Which to Choose?

ORM vs Pure SQL: Which to Choose?

33
Comments 18
1 min read
Transform Your Data Like a Pro With dbt (Data Build Tool)

Transform Your Data Like a Pro With dbt (Data Build Tool)

32
Comments
4 min read
Go ORMs Compared

Go ORMs Compared

30
Comments 3
5 min read
Tudo que você precisa saber sobre SQL

Tudo que você precisa saber sobre SQL

30
Comments 3
21 min read
25 SQL tricks for beginners.

25 SQL tricks for beginners.

26
Comments 2
2 min read
Mastering SQL Queries: A Comprehensive Guide for Beginners

Mastering SQL Queries: A Comprehensive Guide for Beginners

25
Comments 5
2 min read
How Modern SQL Databases Are Changing Web Development - #3 Better Developer Experience

How Modern SQL Databases Are Changing Web Development - #3 Better Developer Experience

24
Comments
6 min read
Connect ChatGPT to your SQL Database

Connect ChatGPT to your SQL Database

23
Comments 8
2 min read
Adding sequence duplicate records in MySQL without a window function

Adding sequence duplicate records in MySQL without a window function

21
Comments
3 min read
Understanding SQL Types of Indexes: A Beginner's Guide

Understanding SQL Types of Indexes: A Beginner's Guide

21
Comments 2
3 min read
SQL, NoSql, and 5 DB types you'll never need

SQL, NoSql, and 5 DB types you'll never need

19
Comments 3
3 min read
SQL Data Types: A Comprehensive Overview

SQL Data Types: A Comprehensive Overview

19
Comments 4
2 min read
SQL Assistant: Text-to-SQL Application in Streamlit 🤖

SQL Assistant: Text-to-SQL Application in Streamlit 🤖

19
Comments
6 min read
SQL or Java, Which is Faster for Data Operation?

SQL or Java, Which is Faster for Data Operation?

19
Comments 5
15 min read
Simplifying ETL Pipelines with SQL: Three Tips for Data Processing

Simplifying ETL Pipelines with SQL: Three Tips for Data Processing

18
Comments
3 min read
Use SQL without Databases

Use SQL without Databases

18
Comments 8
9 min read
Sequelize CLI & Typescript

Sequelize CLI & Typescript

17
Comments 5
7 min read
Getting Started with SQL: A Beginners Hands-On Guide!

Getting Started with SQL: A Beginners Hands-On Guide!

17
Comments
7 min read
Integrate sqlite with Nodejs ! 🔥

Integrate sqlite with Nodejs ! 🔥

17
Comments 1
2 min read
👨🏻‍💻Securing Your Web Applications from SQL Injection with SQLMap

👨🏻‍💻Securing Your Web Applications from SQL Injection with SQLMap

17
Comments 4
6 min read
Joins in DBMS

Joins in DBMS

17
Comments 2
3 min read
What is SQL?: A Detailed Guide with Examples

What is SQL?: A Detailed Guide with Examples

16
Comments 6
4 min read
Soft Delete: Dealing With Unique Constraint in Real-World Case

Soft Delete: Dealing With Unique Constraint in Real-World Case

16
Comments
2 min read
Understanding SQL Query Execution Plan Before Creating Indexes to Optimize Costs

Understanding SQL Query Execution Plan Before Creating Indexes to Optimize Costs

16
Comments
3 min read
Using migrations with Golang

Using migrations with Golang

15
Comments
5 min read
The difficulty of SQL stems from relational algebra

The difficulty of SQL stems from relational algebra

15
Comments 1
6 min read
SQL vs NoSQL: Which to Choose?

SQL vs NoSQL: Which to Choose?

14
Comments
1 min read
Tenha controle sobre seu SQL com Golang e SQLC

Tenha controle sobre seu SQL com Golang e SQLC

14
Comments
11 min read
5 useful SQL functions to take your SQL skills to the next level

5 useful SQL functions to take your SQL skills to the next level

14
Comments
6 min read
Unit of Work pattern in Go

Unit of Work pattern in Go

14
Comments
8 min read
O problema de SQL que quase me enlouqueceu

O problema de SQL que quase me enlouqueceu

14
Comments
5 min read
LIMIT vs. FETCH in SQL

LIMIT vs. FETCH in SQL

14
Comments 1
2 min read
Usando migrations com Golang

Usando migrations com Golang

14
Comments
5 min read
Exporting a large PostgreSQL table using Python

Exporting a large PostgreSQL table using Python

13
Comments 1
2 min read
Is SQL a declarative language

Is SQL a declarative language

13
Comments 5
5 min read
Terraforming AWS RDS : A practical guide with Postgres

Terraforming AWS RDS : A practical guide with Postgres

13
Comments
5 min read
6 useful SQL queries for web developers (MySQL)

6 useful SQL queries for web developers (MySQL)

13
Comments
5 min read
How To Create Many-to-Many Relationships in SQL

How To Create Many-to-Many Relationships in SQL

13
Comments 2
21 min read
Multi-Tenant SaaS Architecture with Entity Framework

Multi-Tenant SaaS Architecture with Entity Framework

13
Comments 2
10 min read
loading...