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.
Why Snowflake Column-Level Masking Outshines Traditional Tokenization

Why Snowflake Column-Level Masking Outshines Traditional Tokenization

Comments
3 min read
Clean SQL with Comments: Syntax and Practices for All Engines

Clean SQL with Comments: Syntax and Practices for All Engines

Comments
1 min read
.NET EF Core: When to Use (or don't) .AsSplitQuery()

.NET EF Core: When to Use (or don't) .AsSplitQuery()

Comments
4 min read
From Natural Language to SQL: A Deep Dive with Ollama and Granite

From Natural Language to SQL: A Deep Dive with Ollama and Granite

Comments 2
8 min read
Slow SQL? Diagnose & Fix Bottlenecks Fast!

Slow SQL? Diagnose & Fix Bottlenecks Fast!

Comments
6 min read
What Is DBT? A No-Fluff Guide for Data Engineers and Analysts

What Is DBT? A No-Fluff Guide for Data Engineers and Analysts

Comments
3 min read
$lookup: more than just a SQL join (understand performance)

$lookup: more than just a SQL join (understand performance)

8
Comments 1
5 min read
Some Tips on SQL Usage in Spring

Some Tips on SQL Usage in Spring

1
Comments 1
4 min read
How Excel is Used in Real-World Data Analysis

How Excel is Used in Real-World Data Analysis

4
Comments 2
2 min read
Integration testing tRPC and in memory MySQL database.

Integration testing tRPC and in memory MySQL database.

1
Comments
5 min read
Which LLM writes the best SQL?

Which LLM writes the best SQL?

Comments
10 min read
Create Columns from Distinct Values of a Column — From SQL to SPL #26

Create Columns from Distinct Values of a Column — From SQL to SPL #26

6
Comments 1
1 min read
How to Speed Up Associations between Large Primary and Sub Tables with esProc

How to Speed Up Associations between Large Primary and Sub Tables with esProc

7
Comments 1
4 min read
Solving One-to-Many Update Issues in Status Tracking Systems

Solving One-to-Many Update Issues in Status Tracking Systems

3
Comments 5
1 min read
Kapper 1.5: Celebrating Java's 30th Birthday with Blazing Fast Record Mapping

Kapper 1.5: Celebrating Java's 30th Birthday with Blazing Fast Record Mapping

Comments 1
4 min read
Substring from a Column of Strings — From SQL to SPL #25

Substring from a Column of Strings — From SQL to SPL #25

5
Comments 1
2 min read
🛡️ Examining the Database in SQL Injection Attacks

🛡️ Examining the Database in SQL Injection Attacks

Comments 1
4 min read
Total under Recursive Relationship — From SQL to SPL #33

Total under Recursive Relationship — From SQL to SPL #33

7
Comments 1
2 min read
How to install PostgreSQL on macOS: Step-by-Step Instructions

How to install PostgreSQL on macOS: Step-by-Step Instructions

Comments
1 min read
Building a Robust SQLite Query Builder in TypeScript: Lessons from an Arabic Dictionary App

Building a Robust SQLite Query Builder in TypeScript: Lessons from an Arabic Dictionary App

2
Comments
4 min read
Isolation — The Trickiest ACID Pillar (And Why It Matters More Than You Think)

Isolation — The Trickiest ACID Pillar (And Why It Matters More Than You Think)

Comments
7 min read
How to Handle Millions of Rows in SQL Without Killing Performance

How to Handle Millions of Rows in SQL Without Killing Performance

29
Comments 1
2 min read
Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference

Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference

5
Comments 1
4 min read
Open-source Node.js blogging engine with newsletter functionality

Open-source Node.js blogging engine with newsletter functionality

1
Comments
1 min read
DuckDB 1.20 Released! Exploring the New Features

DuckDB 1.20 Released! Exploring the New Features

Comments
4 min read
loading...