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.
Indexes Under The Hood

Indexes Under The Hood

1
Comments
14 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
The Prisma ORM: A Brief Overview and Introduction

The Prisma ORM: A Brief Overview and Introduction

5
Comments
9 min read
SQL Queries Execution Order

SQL Queries Execution Order

Comments
3 min read
PostgreSQL Connection Pooling vs No Pooling: Benchmark Analysis

PostgreSQL Connection Pooling vs No Pooling: Benchmark Analysis

1
Comments
3 min read
When and Why to Use JSON Columns in SQL Databases

When and Why to Use JSON Columns in SQL Databases

4
Comments
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
Working of SQL*Loader

Working of SQL*Loader

5
Comments
2 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

35
Comments 1
3 min read
Mastering SQL Optimization: A Beginner’s Guide to Faster and More Efficient Queries

Mastering SQL Optimization: A Beginner’s Guide to Faster and More Efficient Queries

Comments
3 min read
ChartDB: New Functionalities Unlocked! 🎉

ChartDB: New Functionalities Unlocked! 🎉

12
Comments
2 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
🚀 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 🌐

36
Comments 3
6 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
Connecting SQL Databases to the Cloud: PostgreSQL, MySQL, SQLite, and Cloud Integration Explained

Connecting SQL Databases to the Cloud: PostgreSQL, MySQL, SQLite, and Cloud Integration Explained

Comments 1
7 min read
Technical Interview Questions - Part 4 - Git + SQL vs noSQL

Technical Interview Questions - Part 4 - Git + SQL vs noSQL

3
Comments
3 min read
Access Controls for Users and Roles in SQL

Access Controls for Users and Roles in SQL

Comments
6 min read
Preventing SQL Injection (SQLi) in React.js Apps

Preventing SQL Injection (SQLi) in React.js Apps

2
Comments
3 min read
SQL Server Execution Plans

SQL Server Execution Plans

1
Comments
5 min read
On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL

On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL

5
Comments
3 min read
Entendo a ordem de execução de uma query SQL

Entendo a ordem de execução de uma query SQL

1
Comments
2 min read
SQL for Data Validation: Implementing Business Rules and Constraints

SQL for Data Validation: Implementing Business Rules and Constraints

1
Comments
5 min read
Postgres can do that? No surprise Postgres is everywhere

Postgres can do that? No surprise Postgres is everywhere

1
Comments
9 min read
SQL vs. NoSQL: Key Differences, Use Cases, and Choosing the Right Database for Your Project

SQL vs. NoSQL: Key Differences, Use Cases, and Choosing the Right Database for Your Project

Comments
5 min read
loading...