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.
Postgres can do that? No surprise Postgres is everywhere

Postgres can do that? No surprise Postgres is everywhere

1
Comments
9 min read
UUID 🪪 or Auto Increment Integer / Serial ⚙️ as the Database Primary Key?

UUID 🪪 or Auto Increment Integer / Serial ⚙️ as the Database Primary Key?

10
Comments
3 min read
SQL Leetcode Questions

SQL Leetcode Questions

37
Comments 2
3 min read
Preventing SQL Injection (SQLi) Attacks in Drupal

Preventing SQL Injection (SQLi) Attacks in Drupal

Comments
3 min read
Concurrency Issues in SQL and Distributed Systems

Concurrency Issues in SQL and Distributed Systems

Comments
25 min read
SQL Injection (SQLi) Vulnerabilities in WordPress: Prevention Tips

SQL Injection (SQLi) Vulnerabilities in WordPress: Prevention Tips

3
Comments 2
3 min read
Database Sharding: Simplifying Data Scalability

Database Sharding: Simplifying Data Scalability

Comments
7 min read
Top 5 SQL questions asked in interviews

Top 5 SQL questions asked in interviews

5
Comments
4 min read
Dynamic SQL in PL/SQL

Dynamic SQL in PL/SQL

7
Comments 1
2 min read
CPU SIMULATOR

CPU SIMULATOR

1
Comments 4
1 min read
Intro to SQL using Apache Iceberg and Dremio

Intro to SQL using Apache Iceberg and Dremio

4
Comments
22 min read
Technical Interview Questions - Part 3 - SQL

Technical Interview Questions - Part 3 - SQL

2
Comments
5 min read
Layer 4 vs Layer 7 Load Balancer

Layer 4 vs Layer 7 Load Balancer

7
Comments 1
4 min read
How to Access Databases using One SQL Statement #eg71

How to Access Databases using One SQL Statement #eg71

6
Comments
1 min read
VACUUM In Postgres Demystified

VACUUM In Postgres Demystified

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