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.
How to Write a SQL Subquery with Drizzle ORM

How to Write a SQL Subquery with Drizzle ORM

Comments
2 min read
Unveiling the Potential of the COUNT Function in SQL

Unveiling the Potential of the COUNT Function in SQL

1
Comments
3 min read
Import data from Excel to SQL Server or Azure SQL Database | Convert Excel Files to Databases Quickly

Import data from Excel to SQL Server or Azure SQL Database | Convert Excel Files to Databases Quickly

1
Comments 1
1 min read
How to Create a database in SQL Server 2022?

How to Create a database in SQL Server 2022?

5
Comments
1 min read
The Basics of SQL Joins

The Basics of SQL Joins

Comments
2 min read
SQL - Efficiently Paginate Query Results

SQL - Efficiently Paginate Query Results

Comments
1 min read
How to Create a Front End for a SQL Server Database in 4 Steps

How to Create a Front End for a SQL Server Database in 4 Steps

Comments
21 min read
How I can see what queries run in my mssql server once I exeture them via eloquent model?

How I can see what queries run in my mssql server once I exeture them via eloquent model?

Comments
2 min read
Corrected Code: List Typo

Corrected Code: List Typo

Comments
1 min read
MikroORM 6: Polished

MikroORM 6: Polished

Comments
16 min read
5 Database Index tips you may find (extremely) helpful

5 Database Index tips you may find (extremely) helpful

6
Comments
3 min read
Implementing nested loop joins in MySQL for performance

Implementing nested loop joins in MySQL for performance

1
Comments
2 min read
Introduction to SQL Injection Attacks

Introduction to SQL Injection Attacks

Comments
4 min read
A Practical Example of Using SQL Self Joins

A Practical Example of Using SQL Self Joins

4
Comments
4 min read
Free SQL Database Schema Generator

Free SQL Database Schema Generator

2
Comments 2
1 min read
Isolation Levels - part XIII: Explicit Locking with SELECT (FOR UPDATE) intention

Isolation Levels - part XIII: Explicit Locking with SELECT (FOR UPDATE) intention

6
Comments
12 min read
SQL Database Index Basics

SQL Database Index Basics

5
Comments 6
10 min read
Order-based Group Operations (I)

Order-based Group Operations (I)

5
Comments
6 min read
Relational Database Design with DBML

Relational Database Design with DBML

3
Comments
2 min read
PostgreSQL vs MariaDB [Complete Comparison]

PostgreSQL vs MariaDB [Complete Comparison]

1
Comments
9 min read
How To Connect a Form to a Database

How To Connect a Form to a Database

Comments
7 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
INDEX of DATA WORLD JOURNEY.

INDEX of DATA WORLD JOURNEY.

1
Comments 1
4 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
Understanding the Fundamentals of Database Programming Languages

Understanding the Fundamentals of Database Programming Languages

9
Comments 1
9 min read
SQL Key-words with the examples

SQL Key-words with the examples

5
Comments
19 min read
SQL Puzzles

SQL Puzzles

24
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
Finding the best SQL query for the task.

Finding the best SQL query for the task.

Comments
4 min read
A SQL function in PostgreSQL

A SQL function in PostgreSQL

Comments
8 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 !!!!

8
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

15
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

97
Comments 66
2 min read
SQL Cheat Sheet: A Comprehensive Guide to SQL Commands and Queries

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

3
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

8
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

3
Comments
11 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

11
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

41
Comments 4
3 min read
How the Relational Database Came to Be

How the Relational Database Came to Be

Comments
5 min read
Sequelize CLI & Typescript

Sequelize CLI & Typescript

37
Comments 6
7 min read
Unit of Work pattern in Go

Unit of Work pattern in Go

19
Comments
8 min read
loading...