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.
Types of SQL statements

Types of SQL statements

Comments
1 min read
MongoDB vs PostgreSQL JSONB: A Deep Dive into Performance and Use Cases

MongoDB vs PostgreSQL JSONB: A Deep Dive into Performance and Use Cases

Comments 1
2 min read
Rove : Straight up PostgreSQL migration.

Rove : Straight up PostgreSQL migration.

1
Comments
2 min read
Oracle PL/SQL - Basic Terms

Oracle PL/SQL - Basic Terms

Comments
1 min read
Best Oracle Database Design Tools in 2025
Cover image for Best Oracle Database Design Tools in 2025

Best Oracle Database Design Tools in 2025

13
Comments 8
7 min read
How to Document a PostgreSQL Schema in 2025
Cover image for How to Document a PostgreSQL Schema in 2025

How to Document a PostgreSQL Schema in 2025

13
Comments 1
4 min read
Why is Your MyBatis Slow? One Line of Config Can Double Its Performance!

Why is Your MyBatis Slow? One Line of Config Can Double Its Performance!

1
Comments
5 min read
Introducing gq-to-sql: Convert Graph-Style URL Queries into SQL

Introducing gq-to-sql: Convert Graph-Style URL Queries into SQL

4
Comments 3
1 min read
Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40
Cover image for Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40

Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40

11
Comments 3
2 min read
The LIMIT offset, count Trap: Why Large Offsets Slow Down MySQL?

The LIMIT offset, count Trap: Why Large Offsets Slow Down MySQL?

Comments
5 min read
Find Consecutive Alphabetical Characters in String — From SQL to SPL #28
Cover image for Find Consecutive Alphabetical Characters in String — From SQL to SPL #28

Find Consecutive Alphabetical Characters in String — From SQL to SPL #28

8
Comments 1
2 min read
How to Create a New MySQL User and Grant All Permissions

How to Create a New MySQL User and Grant All Permissions

Comments
2 min read
Where to Learn SQL for Free: Best Platforms and Resources

Where to Learn SQL for Free: Best Platforms and Resources

Comments
5 min read
Web Scraping to SQL: How to Effectively Store and Analyze Your Scraped Data
Cover image for Web Scraping to SQL: How to Effectively Store and Analyze Your Scraped Data

Web Scraping to SQL: How to Effectively Store and Analyze Your Scraped Data

Comments
5 min read
Smarter Databases with SQL Views and Triggers

Smarter Databases with SQL Views and Triggers

Comments
5 min read
EXPLAIN It! Your Fast Track to Fixing Slow SQL

EXPLAIN It! Your Fast Track to Fixing Slow SQL

Comments
8 min read
How to Self-Host PostgreSQL (with Monitoring)
Cover image for How to Self-Host PostgreSQL (with Monitoring)

How to Self-Host PostgreSQL (with Monitoring)

Comments
2 min read
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
Cover image for 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)
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
loading...