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.
Mastering the Art of Optimizing Complex SQL Queries

Mastering the Art of Optimizing Complex SQL Queries

Comments
2 min read
[sqlx-ts] compile-time checked queries without DSL in Typescript

[sqlx-ts] compile-time checked queries without DSL in Typescript

2
Comments
4 min read
Query Execution Plan inside SQL Server

Query Execution Plan inside SQL Server

2
Comments
4 min read
Is Your Latest Data Really the Latest? Check the Data Update Mechanism of Your Database

Is Your Latest Data Really the Latest? Check the Data Update Mechanism of Your Database

2
Comments 1
6 min read
Função COALESCE no SQL: Lidando com Valores NULL

Função COALESCE no SQL: Lidando com Valores NULL

Comments
2 min read
Batch rename BigQuery tables with SQL

Batch rename BigQuery tables with SQL

1
Comments
3 min read
Triggers in SQL Server: Unlocking the Power of Automation

Triggers in SQL Server: Unlocking the Power of Automation

Comments
3 min read
ORM: Object Relational Mapping with Ruby

ORM: Object Relational Mapping with Ruby

Comments
6 min read
Creating a SQL Database Context in a .NET WinForm Application with EntityFramework

Creating a SQL Database Context in a .NET WinForm Application with EntityFramework

4
Comments 1
3 min read
How to avoid performance bottlenecks when using JSONB in PostgreSQL

How to avoid performance bottlenecks when using JSONB in PostgreSQL

5
Comments
6 min read
SQL Common Table Expressions and Window functions

SQL Common Table Expressions and Window functions

11
Comments 1
7 min read
The performance problems of data warehouse and solutions

The performance problems of data warehouse and solutions

Comments
14 min read
Exploratory Data Analysis With SQL

Exploratory Data Analysis With SQL

2
Comments
21 min read
Exploring the Process and Memory Architecture of PostgreSQL: Chapter 2

Exploring the Process and Memory Architecture of PostgreSQL: Chapter 2

Comments
4 min read
Use of WHERE clause in PostgreSQL

Use of WHERE clause in PostgreSQL

1
Comments
2 min read
An Introduction to DBMS_XMLPARSE in Oracle PL/SQL

An Introduction to DBMS_XMLPARSE in Oracle PL/SQL

1
Comments
3 min read
maximum salary of the employee in each department

maximum salary of the employee in each department

5
Comments
1 min read
Another funny benchmark: "hugedbbench"

Another funny benchmark: "hugedbbench"

1
Comments
3 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
What are Multi-Model Databases?

What are Multi-Model Databases?

7
Comments
6 min read
Safeguarding Data Integrity with pg-safeupdate in PostgreSQL and Supabase

Safeguarding Data Integrity with pg-safeupdate in PostgreSQL and Supabase

3
Comments
3 min read
Navigating the Database Landscape: Overview of SQL, MySQL, PostgreSQL, and NoSQL

Navigating the Database Landscape: Overview of SQL, MySQL, PostgreSQL, and NoSQL

5
Comments
15 min read
SQL for low code applications: SQLPage

SQL for low code applications: SQLPage

4
Comments
2 min read
PostgreSQL Optimizer Hints Discussion

PostgreSQL Optimizer Hints Discussion

18
Comments
5 min read
Unir tablas en SQL con JOIN

Unir tablas en SQL con JOIN

Comments
4 min read
Never forget ACID again!!

Never forget ACID again!!

7
Comments
4 min read
Advanced SQL Queries in PostgreSQL

Advanced SQL Queries in PostgreSQL

Comments
3 min read
SQL::Inserter for faster/multi-row inserting

SQL::Inserter for faster/multi-row inserting

1
Comments
4 min read
Powering Rapid Data Applications Using Your Data Warehouse With VulcanSQL

Powering Rapid Data Applications Using Your Data Warehouse With VulcanSQL

2
Comments
5 min read
Real-time Data Processing Pipeline With MongoDB, Kafka, Debezium And RisingWave

Real-time Data Processing Pipeline With MongoDB, Kafka, Debezium And RisingWave

7
Comments
6 min read
Beginner's Guide to Using Sql to Create Databases

Beginner's Guide to Using Sql to Create Databases

3
Comments
4 min read
Sampling in PostgreSQL with BERNOULLI Function

Sampling in PostgreSQL with BERNOULLI Function

3
Comments
3 min read
Database Normalisation: Efficient Database Design

Database Normalisation: Efficient Database Design

2
Comments
2 min read
Vacuum Processing in PostgreSQL: Chapter 6

Vacuum Processing in PostgreSQL: Chapter 6

Comments
3 min read
Getting Started with Apache AGE: Step-by-Step Guide to Database Implementation

Getting Started with Apache AGE: Step-by-Step Guide to Database Implementation

2
Comments
3 min read
Want to Boost Database SQL Performance? This JetBrains Plugin Has You Covered!

Want to Boost Database SQL Performance? This JetBrains Plugin Has You Covered!

8
Comments 2
5 min read
DevOps: Database Change Management with MariaDB

DevOps: Database Change Management with MariaDB

Comments
6 min read
esProc SPL, the challenger of SQLite

esProc SPL, the challenger of SQLite

6
Comments
12 min read
Trabalhando com Datas em SQL: Funções Úteis e Exemplos

Trabalhando com Datas em SQL: Funções Úteis e Exemplos

Comments
2 min read
Generating an Access Token for Azure SQL Database Using Service Principal and Client Secret using PowerShell

Generating an Access Token for Azure SQL Database Using Service Principal and Client Secret using PowerShell

Comments
2 min read
Using MySQL Variables

Using MySQL Variables

2
Comments
6 min read
Comando SELECT em SQL

Comando SELECT em SQL

Comments
2 min read
Demystifying SQL: An Introduction to SQL Using SQL Server

Demystifying SQL: An Introduction to SQL Using SQL Server

1
Comments
4 min read
Modern Data Stack: A Hands-on Guide with Airbyte, Snowflake, and dbt(data build tool)

Modern Data Stack: A Hands-on Guide with Airbyte, Snowflake, and dbt(data build tool)

9
Comments
3 min read
Exploring MS SQL Server Triggers

Exploring MS SQL Server Triggers

1
Comments 1
2 min read
PostgreSQL : Prepared statement

PostgreSQL : Prepared statement

6
Comments
4 min read
SQL vs NoSQL Databases: Unraveling the Age-Old Debate

SQL vs NoSQL Databases: Unraveling the Age-Old Debate

Comments
3 min read
Prescrição SQL: A Linguagem SQL Ajudando na Gestão Hospitalar

Prescrição SQL: A Linguagem SQL Ajudando na Gestão Hospitalar

Comments
3 min read
Data warehouse running on file system

Data warehouse running on file system

Comments
9 min read
AgensSQL: Unleashing the Power of Graph Databases with SQL Compatibility

AgensSQL: Unleashing the Power of Graph Databases with SQL Compatibility

Comments
2 min read
SQL Recipe: Compare with Neighbors

SQL Recipe: Compare with Neighbors

1
Comments
3 min read
Functions for manipulating data in PostgreSQL

Functions for manipulating data in PostgreSQL

Comments
10 min read
Databases simplified

Databases simplified

6
Comments
1 min read
Structured Query Language (SQL)| Full Explanation (Definition, usage, structure and example with MySQL)

Structured Query Language (SQL)| Full Explanation (Definition, usage, structure and example with MySQL)

4
Comments
3 min read
结构化查询语言(SQL)| 完整解释(定义、用法、结构和 MySQL 示例)

结构化查询语言(SQL)| 完整解释(定义、用法、结构和 MySQL 示例)

1
Comments
1 min read
Linguagem de consulta estruturada (SQL) | Explicação Completa (Definição, uso, estrutura e exemplo com MySQL)

Linguagem de consulta estruturada (SQL) | Explicação Completa (Definição, uso, estrutura e exemplo com MySQL)

Comments
3 min read
Structured Query Language (SQL)| Explicación Completa (Definición, uso, estructura y ejemplo con MySQL)

Structured Query Language (SQL)| Explicación Completa (Definición, uso, estructura y ejemplo con MySQL)

Comments
3 min read
Book review: Mastering PostgreSQL 15

Book review: Mastering PostgreSQL 15

6
Comments
5 min read
REST API with Go, Chi, SQL Server and sqlx

REST API with Go, Chi, SQL Server and sqlx

3
Comments
8 min read
Approximate Count Distinct in YugabyteDB (and PostgreSQL) with HyperLogLog

Approximate Count Distinct in YugabyteDB (and PostgreSQL) with HyperLogLog

2
Comments
6 min read
loading...