Forem

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.
$lookup: more than just a SQL join (understand performance)
Cover image for $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
🧪 Exploiting Blind SQL Injection by Triggering Time Delays
Cover image for 🧪 Exploiting Blind SQL Injection by Triggering Time Delays

🧪 Exploiting Blind SQL Injection by Triggering Time Delays

Comments 1
3 min read
PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup
Cover image for PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup

PostgreSQL Practical Labs: Error Handling, Advanced Data Types & Kali Linux Setup

Comments
3 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?
Cover image for 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
Cover image for 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
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
Why Transactional Databases Matter: Concepts, Use Cases, and Examples

Why Transactional Databases Matter: Concepts, Use Cases, and Examples

2
Comments 2
3 min read
Kapper 1.5: Celebrating Java's 30th Birthday with Blazing Fast Record Mapping
Cover image for 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
Cover image for 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
Cover image for 🛡️ 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
Cover image for 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
Cover image for 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
Open-source Node.js blogging engine with newsletter functionality
Cover image for Open-source Node.js blogging engine with newsletter functionality

Open-source Node.js blogging engine with newsletter functionality

1
Comments
1 min read
Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference
Cover image for Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference

Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference

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

DuckDB 1.20 Released! Exploring the New Features

Comments
4 min read
#34 50 Advanced SQL Queries Every Developer Should Know
Cover image for #34 50 Advanced SQL Queries Every Developer Should Know

#34 50 Advanced SQL Queries Every Developer Should Know

2
Comments
7 min read
Oracle 23ai: Direct Joins for UPDATE and DELETE Statements

Oracle 23ai: Direct Joins for UPDATE and DELETE Statements

Comments
1 min read
The Hidden Costs of GCP Data Engineering: Are Idle Resources Draining Your Budget?

The Hidden Costs of GCP Data Engineering: Are Idle Resources Draining Your Budget?

Comments
2 min read
Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24
Cover image for Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24

Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24

6
Comments 1
3 min read
loading...