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

2
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

1
Comments
3 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
TIL: joining with LIKE

TIL: joining with LIKE

2
Comments
1 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
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
Getting members according to primary key values #eg63

Getting members according to primary key values #eg63

7
Comments
1 min read
Understanding SQL Queries: A Beginner’s Guide pt1

Understanding SQL Queries: A Beginner’s Guide pt1

Comments
4 min read
Criando um Simulador de Banco de Dados em Rust: Parsing, Compilação e Execução de Consultas SQL

Criando um Simulador de Banco de Dados em Rust: Parsing, Compilação e Execução de Consultas SQL

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

SQL Injection (SQLi) Vulnerabilities in WordPress: Prevention Tips

1
Comments 2
3 min read
SQL 101: Introduction to Structured Query Language

SQL 101: Introduction to Structured Query Language

1
Comments
3 min read
7+ Free PostgreSQL Hosting Platforms for Developers in 2024

7+ Free PostgreSQL Hosting Platforms for Developers in 2024

54
Comments 2
4 min read
Top 5 SQL questions asked in interviews

Top 5 SQL questions asked in interviews

5
Comments
4 min read
loading...