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.
Relational vs. Document Databases: Key Differences, Use Cases, and Performance

Relational vs. Document Databases: Key Differences, Use Cases, and Performance

Comments
3 min read
Зоопарк Hibernate: N+1 запросов или как накормить жадного бегемота

Зоопарк Hibernate: N+1 запросов или как накормить жадного бегемота

8
Comments
2 min read
How We Built 🔧🦾 the SQL Autocomplete Framework ⚙️🧱 with ANTLR4

How We Built 🔧🦾 the SQL Autocomplete Framework ⚙️🧱 with ANTLR4

10
Comments
10 min read
Database Normalization

Database Normalization

3
Comments
4 min read
Building a Secure, Scalable Learning Platform with RBAC Features 🎓🔒📚

Building a Secure, Scalable Learning Platform with RBAC Features 🎓🔒📚

Comments
6 min read
Indexes Under The Hood

Indexes Under The Hood

1
Comments
14 min read
The Prisma ORM: A Brief Overview and Introduction

The Prisma ORM: A Brief Overview and Introduction

7
Comments
9 min read
Part 10: SQL Injection Series - The Psychology of Attackers and SQL Injection in Larger Attack Strategies

Part 10: SQL Injection Series - The Psychology of Attackers and SQL Injection in Larger Attack Strategies

5
Comments 1
3 min read
Top 20+ Full-stack Projects For Beginners in C#, ASP.NET , .NET CORE

Top 20+ Full-stack Projects For Beginners in C#, ASP.NET , .NET CORE

97
Comments 1
3 min read
Part 7: SQL Injection Series: Advanced SQL Injection Techniques

Part 7: SQL Injection Series: Advanced SQL Injection Techniques

5
Comments 1
4 min read
ChartDB: New Functionalities Unlocked! 🎉

ChartDB: New Functionalities Unlocked! 🎉

12
Comments
2 min read
🚀 Go-ing Full-Stack: Building Dynamic Web Apps with Go 🐹, PostgreSQL 🐘, Docker 🐳, and HTTP Servers 🌐

🚀 Go-ing Full-Stack: Building Dynamic Web Apps with Go 🐹, PostgreSQL 🐘, Docker 🐳, and HTTP Servers 🌐

38
Comments 3
6 min read
How to Detect and Defend Against SQL Injection Attacks - Part 2

How to Detect and Defend Against SQL Injection Attacks - Part 2

7
Comments 1
4 min read
Using ON DUPLICATE KEY UPDATE and NOT EXISTS in MySQL

Using ON DUPLICATE KEY UPDATE and NOT EXISTS in MySQL

Comments
1 min read
My Data Analyst Interview Journey and What I Learned

My Data Analyst Interview Journey and What I Learned

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