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

2
Comments
2 min read
PostgreSQL Optimizer Hints Discussion

PostgreSQL Optimizer Hints Discussion

3
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
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!

5
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

5
Comments
12 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
Exploring MS SQL Server Triggers

Exploring MS SQL Server Triggers

1
Comments 1
2 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
5 criteria for data quality and how to test for them

5 criteria for data quality and how to test for them

Comments
6 min read
PostgreSQL : Prepared statement

PostgreSQL : Prepared statement

4
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
Understanding Query Processing in PostgreSQL: Part 1

Understanding Query Processing in PostgreSQL: Part 1

1
Comments
3 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
Connect ChatGPT to your SQL Database

Connect ChatGPT to your SQL Database

23
Comments 8
2 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 示例)

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

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

REST API with Go, Chi, SQL Server and sqlx

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

Approximate Count Distinct in YugabyteDB (and PostgreSQL) with HyperLogLog

1
Comments
6 min read
Exploring the Fundamentals of Database Cluster, Databases, Tables, and Internal Layout in PostgreSQL

Exploring the Fundamentals of Database Cluster, Databases, Tables, and Internal Layout in PostgreSQL

Comments
4 min read
More String Functions in SQLite

More String Functions in SQLite

1
Comments
3 min read
Quickly testing an extension from docker image

Quickly testing an extension from docker image

Comments
2 min read
Designing SQL Database for a blog application

Designing SQL Database for a blog application

1
Comments
2 min read
SQL: triggers & views

SQL: triggers & views

3
Comments 1
2 min read
Demystifying the Internals of PostgreSQL - Chapter 5

Demystifying the Internals of PostgreSQL - Chapter 5

Comments
5 min read
Introducing DataLang - Ask questions to your Database in Natural Language

Introducing DataLang - Ask questions to your Database in Natural Language

Comments
2 min read
Oracle MERGE to UPDATE SQL

Oracle MERGE to UPDATE SQL

Comments
3 min read
Enhancing Database Performance with PostgreSQL Indexing Techniques

Enhancing Database Performance with PostgreSQL Indexing Techniques

2
Comments
2 min read
Group by Year, Month, or Day in PostgreSQL

Group by Year, Month, or Day in PostgreSQL

8
Comments
4 min read
Why Are There So Many Snapshot Tables in BI Systems?

Why Are There So Many Snapshot Tables in BI Systems?

5
Comments
9 min read
Demystifying the Data Product Lifecycle: From Inception to Retirement

Demystifying the Data Product Lifecycle: From Inception to Retirement

8
Comments
4 min read
Demystifying the Internals of PostgreSQL - Chapter 3

Demystifying the Internals of PostgreSQL - Chapter 3

Comments
5 min read
How to Select the First Row of Each Set of Grouped Rows Using GROUP BY

How to Select the First Row of Each Set of Grouped Rows Using GROUP BY

1
Comments
1 min read
Maximising Database Performance: Tips and Techniques for PostgreSQL Optimisation

Maximising Database Performance: Tips and Techniques for PostgreSQL Optimisation

3
Comments
2 min read
SQL Case Study 2: Human Resources

SQL Case Study 2: Human Resources

Comments
4 min read
SQL Query in Spring Boot

SQL Query in Spring Boot

Comments
1 min read
Don't underestimate SQL

Don't underestimate SQL

10
Comments 4
2 min read
Order by random Optimization

Order by random Optimization

Comments
5 min read
loading...