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.
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
Taxi Drivers Efficiency Analysis with SQL & Tableau

Taxi Drivers Efficiency Analysis with SQL & Tableau

2
Comments
3 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
ORM vs ODM: What's the Difference and When to Use Them?

ORM vs ODM: What's the Difference and When to Use Them?

6
Comments
1 min read
$lookup: more than just a SQL join

$lookup: more than just a SQL join

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
MySQL vs MongoDB - Visual Design with Real Data Models

MySQL vs MongoDB - Visual Design with Real Data Models

6
Comments 1
5 min read
What’s a database anyway?? A blog post for kids

What’s a database anyway?? A blog post for kids

Comments
14 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
🛡️ Understanding and Exploiting Blind SQL Injection

🛡️ Understanding and Exploiting Blind SQL Injection

Comments 1
3 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
NoSQL vs. SQL: Which One to Use

NoSQL vs. SQL: Which One to Use

Comments
3 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
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
loading...