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

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

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

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
🔍 Mastering Blind SQL Injection with Out-of-Band (OAST) Techniques

🔍 Mastering Blind SQL Injection with Out-of-Band (OAST) Techniques

Comments
1 min read
SQL Injection: All Concepts, All Payloads, All In One

SQL Injection: All Concepts, All Payloads, All In One

12
Comments 4
8 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
📚 Error-Based SQL Injection – A Deep Dive! 🎓🔍

📚 Error-Based SQL Injection – A Deep Dive! 🎓🔍

Comments
4 min read
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.