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.
SQL Key-words with the examples

SQL Key-words with the examples

1
Comments
19 min read
SQL Puzzles

SQL Puzzles

1
Comments
17 min read
SQL - Handle NULL Values Safely in Queries

SQL - Handle NULL Values Safely in Queries

2
Comments
1 min read
Summary of results

Summary of results

1
Comments
2 min read
The Top 10 GitHub Repositories Making Waves 🌊📊

The Top 10 GitHub Repositories Making Waves 🌊📊

84
Comments 8
4 min read
Reading Postgres Execution Plans doesn't have to be so complicated

Reading Postgres Execution Plans doesn't have to be so complicated

1
Comments
6 min read
Efficiently Managing Data with SELECT During INSERT Queries

Efficiently Managing Data with SELECT During INSERT Queries

1
Comments
2 min read
Learn SQL Quickly & Join Data Easily, With This Simple Method & Get into 11 New Professions !!!!

Learn SQL Quickly & Join Data Easily, With This Simple Method & Get into 11 New Professions !!!!

4
Comments
4 min read
High Availability in SQL: A Guide to High Availability Databases

High Availability in SQL: A Guide to High Availability Databases

Comments
5 min read
Could Batched Nested Loop improve PostgreSQL like it does for YugabyteDB?

Could Batched Nested Loop improve PostgreSQL like it does for YugabyteDB?

Comments
24 min read
Here comes big data technology that rivals clusters on a single machine

Here comes big data technology that rivals clusters on a single machine

6
Comments
6 min read
Understanding PostgreSQL and MongoDB Databases: Know When to Use Each

Understanding PostgreSQL and MongoDB Databases: Know When to Use Each

4
Comments 3
3 min read
Web Vulnerabilities: SQL Injections

Web Vulnerabilities: SQL Injections

1
Comments 4
3 min read
MySQL: Everything You Need To Know

MySQL: Everything You Need To Know

11
Comments
2 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
WEREWOLF WEED

WEREWOLF WEED

1
Comments
1 min read
SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries

SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries

Comments 1
2 min read
Surrogate Key vs Primary Key: What's the Difference?

Surrogate Key vs Primary Key: What's the Difference?

1
Comments
11 min read
How to store and calculate historical big data with lower usage frequency

How to store and calculate historical big data with lower usage frequency

6
Comments
4 min read
`OR` Filter on Two Tables, and Batched Nested Loops

`OR` Filter on Two Tables, and Batched Nested Loops

1
Comments
6 min read
Communicate with Microsoft SQL Server that works on Flutter app compiled for multiple platforms

Communicate with Microsoft SQL Server that works on Flutter app compiled for multiple platforms

Comments
7 min read
Simple Database Software For MySQL

Simple Database Software For MySQL

Comments
8 min read
Isolation Levels - part XII: To go further

Isolation Levels - part XII: To go further

Comments 2
2 min read
Slash Slow Queries by Rewriting OR to UNION

Slash Slow Queries by Rewriting OR to UNION

Comments 1
3 min read
How To Execute A Query In SQL: Using Queries And Data Views

How To Execute A Query In SQL: Using Queries And Data Views

Comments
5 min read
Importing Data From Multiple MS Access Files To SQL Server

Importing Data From Multiple MS Access Files To SQL Server

1
Comments
5 min read
SQL to Python Pandas: A SQL User's Quick Guide

SQL to Python Pandas: A SQL User's Quick Guide

2
Comments
11 min read
Use SQL without Databases

Use SQL without Databases

18
Comments 8
9 min read
Distributed PostgreSQL without sharding constraint for SQL joins

Distributed PostgreSQL without sharding constraint for SQL joins

Comments
4 min read
My "solution" to integrate ChatGPT into any database

My "solution" to integrate ChatGPT into any database

4
Comments
2 min read
SQL - Use Subqueries for Complex Data Retrieval

SQL - Use Subqueries for Complex Data Retrieval

Comments
1 min read
SQL Stored Procedures - Na visĂŁo de um estudante.

SQL Stored Procedures - Na visĂŁo de um estudante.

Comments
6 min read
Alembic with Async SQLAlchemy

Alembic with Async SQLAlchemy

7
Comments 3
3 min read
How the Relational Database Came to Be

How the Relational Database Came to Be

Comments
5 min read
Unit of Work pattern in Go

Unit of Work pattern in Go

14
Comments
8 min read
Sequelize CLI & Typescript

Sequelize CLI & Typescript

17
Comments 5
7 min read
DB2 Cheat Sheet

DB2 Cheat Sheet

1
Comments
1 min read
Isolation Levels - part XI: Read Uncommitted

Isolation Levels - part XI: Read Uncommitted

Comments 2
1 min read
Understan How Sql works

Understan How Sql works

1
Comments
2 min read
A Beginner's Guide to SQLite: The Lightweight Database Solution

A Beginner's Guide to SQLite: The Lightweight Database Solution

Comments
4 min read
Isolation Levels - part X: Non-Transactional Writes

Isolation Levels - part X: Non-Transactional Writes

1
Comments
2 min read
How Metis Detects Too Many Open Connections on Postgres

How Metis Detects Too Many Open Connections on Postgres

Comments
3 min read
Dominando JOINs no SQL: Guia Completo

Dominando JOINs no SQL: Guia Completo

1
Comments
4 min read
Relational Algebra Is the Root of SQL Problems

Relational Algebra Is the Root of SQL Problems

12
Comments 2
5 min read
ON CONFLICT DO NOTHING in YugabyteDB

ON CONFLICT DO NOTHING in YugabyteDB

Comments
4 min read
PostgreSQL. How to list the most IOPs-intensive queries?

PostgreSQL. How to list the most IOPs-intensive queries?

3
Comments
1 min read
MongoDB and PostgreSQL - Key Difference Between Databases

MongoDB and PostgreSQL - Key Difference Between Databases

Comments
2 min read
Understanding Pluggable Storage In Postgresql And Its Benefits

Understanding Pluggable Storage In Postgresql And Its Benefits

1
Comments 1
8 min read
Even a Better Index 🍃 for The Most Annoying Postgres Optimizer Fail

Even a Better Index 🍃 for The Most Annoying Postgres Optimizer Fail

Comments
6 min read
Implementing UUIDs and Auto Incrementing IDs in SQL and Azure SQL: Our Beginners Guide

Implementing UUIDs and Auto Incrementing IDs in SQL and Azure SQL: Our Beginners Guide

Comments
3 min read
SQL - Optimizing Queries with Indexing

SQL - Optimizing Queries with Indexing

Comments
1 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
Extended Statistics and pg_hint_plan /*+ Rows() */

Extended Statistics and pg_hint_plan /*+ Rows() */

2
Comments 2
7 min read
Group By, Grouping Sets, Cube, and Rollup Queries in SQL

Group By, Grouping Sets, Cube, and Rollup Queries in SQL

Comments
5 min read
SQL and NoSQL databases: What are the types and ideal use cases

SQL and NoSQL databases: What are the types and ideal use cases

1
Comments 1
6 min read
A laravel-like database management library for nodejs

A laravel-like database management library for nodejs

1
Comments
3 min read
Pagination with an OFFSET is better without OFFSET

Pagination with an OFFSET is better without OFFSET

1
Comments
5 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
The Most Annoying Optimizer Fail in Postgres ✅ Best index solved it.

The Most Annoying Optimizer Fail in Postgres ✅ Best index solved it.

10
Comments 1
9 min read
SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper

SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper

1
Comments
8 min read
loading...