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.
🚀 Understanding Indexing in Oracle (B-Tree, B+ Tree, Hash Cluster) Indexes are one of the most important concepts in databases.

🚀 Understanding Indexing in Oracle (B-Tree, B+ Tree, Hash Cluster) Indexes are one of the most important concepts in databases.

Comments
3 min read
📝 Understanding Transactions, Deadlocks & Log-Based Recovery in SQL 💾

📝 Understanding Transactions, Deadlocks & Log-Based Recovery in SQL 💾

1
Comments
2 min read
Understanding PL/SQL Collections: Associative Arrays, Nested Tables, and VARRAYs

Understanding PL/SQL Collections: Associative Arrays, Nested Tables, and VARRAYs

1
Comments
3 min read
isql

isql

Comments
1 min read
База Данных 5 Views

База Данных 5 Views

Comments
3 min read
Building a Hybrid Site Generator with Go + SQLite

Building a Hybrid Site Generator with Go + SQLite

1
Comments
1 min read
Simple Tweaks That Make SQLite Lookup Faster – Part 1

Simple Tweaks That Make SQLite Lookup Faster – Part 1

6
Comments
4 min read
Practical SQL Observability for Forge Apps with forge-sql-orm

Practical SQL Observability for Forge Apps with forge-sql-orm

2
Comments
8 min read
Data Analyst Checklist

Data Analyst Checklist

7
Comments
1 min read
Is SQL Injection dead in 2025? Finding Critical Bugs in Item Pagination

Is SQL Injection dead in 2025? Finding Critical Bugs in Item Pagination

1
Comments
2 min read
From 40% to 100% SQL Generation Accuracy: Why Local AI Needs Self-Correction, Not Perfect Prompts

From 40% to 100% SQL Generation Accuracy: Why Local AI Needs Self-Correction, Not Perfect Prompts

2
Comments
4 min read
Free SQL courses for beginners in 2026

Free SQL courses for beginners in 2026

1
Comments
4 min read
Clean Code in ETL:How Python, Go, and SQL Each Teach You to Think Differently

Clean Code in ETL:How Python, Go, and SQL Each Teach You to Think Differently

2
Comments
3 min read
Understanding MySQL Backup Consistency: A Practical Example

Understanding MySQL Backup Consistency: A Practical Example

Comments
2 min read
Diving Deeper into SQL: Advanced Queries and Real-World Applications

Diving Deeper into SQL: Advanced Queries and Real-World Applications

1
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.