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.
SQL Data Exploration for BoardGameGeek datasets

SQL Data Exploration for BoardGameGeek datasets

Comments
5 min read
SQL Queries Execution Order

SQL Queries Execution Order

Comments
3 min read
Simplifying SQL View Management in Laravel Migrations

Simplifying SQL View Management in Laravel Migrations

1
Comments
3 min read
VACUUM In Postgres Demystified

VACUUM In Postgres Demystified

2
Comments
8 min read
ChartDB: New Functionalities Unlocked! 🎉

ChartDB: New Functionalities Unlocked! 🎉

10
Comments
2 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
Using ON DUPLICATE KEY UPDATE and NOT EXISTS in MySQL

Using ON DUPLICATE KEY UPDATE and NOT EXISTS in MySQL

2
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 🌐

17
Comments 2
6 min read
My Data Analyst Interview Journey and What I Learned

My Data Analyst Interview Journey and What I Learned

5
Comments
4 min read
Understanding Batch SQL Injection: A Real-World Threat to Data Security

Understanding Batch SQL Injection: A Real-World Threat to Data Security

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

SQL for Data Validation: Implementing Business Rules and Constraints

2
Comments
5 min read
TIL: joining with LIKE

TIL: joining with LIKE

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

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

9
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 101: Introduction to Structured Query Language

SQL 101: Introduction to Structured Query Language

1
Comments
3 min read
Top 5 SQL questions asked in interviews

Top 5 SQL questions asked in interviews

9
Comments
4 min read
7+ Free PostgreSQL Hosting Platforms for Developers in 2024

7+ Free PostgreSQL Hosting Platforms for Developers in 2024

32
Comments 1
4 min read
CPU SIMULATOR

CPU SIMULATOR

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

How to Access Databases using One SQL Statement #eg71

11
Comments
1 min read
Technical Interview Questions - Part 3 - SQL

Technical Interview Questions - Part 3 - SQL

1
Comments
5 min read
Be careful with join type typos

Be careful with join type typos

1
Comments
1 min read
Handling Data in SQL: Signed vs. Unsigned Types

Handling Data in SQL: Signed vs. Unsigned Types

Comments
1 min read
Use Transactions When Manually Accessing SQL Databases

Use Transactions When Manually Accessing SQL Databases

Comments
3 min read
My first CLI.

My first CLI.

Comments
3 min read
Troubleshooting PostgreSQL Low Free Memory

Troubleshooting PostgreSQL Low Free Memory

Comments
11 min read
SQL ain't that Scary

SQL ain't that Scary

Comments
11 min read
Demystifying SQLMap: A Practical Guide to Web and SQL Injection Testing

Demystifying SQLMap: A Practical Guide to Web and SQL Injection Testing

Comments
2 min read
Create your own Event Scheduling API using Express and Supabase

Create your own Event Scheduling API using Express and Supabase

6
Comments
8 min read
sql joins: moving in together

sql joins: moving in together

Comments
3 min read
Speeding Up Foreign Key Constraints During Migrations

Speeding Up Foreign Key Constraints During Migrations

2
Comments
4 min read
Personal Knowledge Graphs in AI RAG on user phone

Personal Knowledge Graphs in AI RAG on user phone

Comments
9 min read
Pagination in raw SQL with OFFSET

Pagination in raw SQL with OFFSET

Comments
5 min read
SQL Injection (SQLi) Defense Strategies for OpenCart Developers

SQL Injection (SQLi) Defense Strategies for OpenCart Developers

2
Comments 1
2 min read
GETTING STARTED WITH SQL AT LUX ACADEMY

GETTING STARTED WITH SQL AT LUX ACADEMY

Comments
1 min read
Employee Management System Using SQL

Employee Management System Using SQL

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

SQL 101: Introduction to Structured Query Language

Comments
4 min read
PostgreSQL Query Performance Tuning Tips

PostgreSQL Query Performance Tuning Tips

4
Comments 4
8 min read
Reading and Interpreting PostgreSQL Query Plans – A Friendly Guide

Reading and Interpreting PostgreSQL Query Plans – A Friendly Guide

6
Comments 1
9 min read
Uma breve introdução ao Hibernate

Uma breve introdução ao Hibernate

Comments
4 min read
MySQL Basics: Understanding Isolation Level and Transaction Anomalies

MySQL Basics: Understanding Isolation Level and Transaction Anomalies

Comments
4 min read
MySQL Basics: Understanding Join and Index with Examples

MySQL Basics: Understanding Join and Index with Examples

Comments
5 min read
Preventing SQL Injection (SQLi) in Symfony: Best Practices with Examples

Preventing SQL Injection (SQLi) in Symfony: Best Practices with Examples

Comments
3 min read
How to Delete Duplicate Data from a MySQL Database

How to Delete Duplicate Data from a MySQL Database

Comments
4 min read
Best Practices for Alembic and SQLAlchemy

Best Practices for Alembic and SQLAlchemy

1
Comments 1
5 min read
Best Tool for Query anything with SQL

Best Tool for Query anything with SQL

10
Comments
1 min read
Essential SQL Database Security Practices to Protect Your Data

Essential SQL Database Security Practices to Protect Your Data

Comments
4 min read
How to Optimize SQL Queries for Better Database Performance?

How to Optimize SQL Queries for Better Database Performance?

1
Comments 1
5 min read
Introduction to sql for data analytics.

Introduction to sql for data analytics.

1
Comments
3 min read
Dicas de SQL para Iniciantes: Consultando Proprietários de Animais de Estimação (Joins)

Dicas de SQL para Iniciantes: Consultando Proprietários de Animais de Estimação (Joins)

Comments 2
7 min read
IntaLink: A New NL2SQL Technology Distinct from Large Models

IntaLink: A New NL2SQL Technology Distinct from Large Models

1
Comments
6 min read
Why does SQLynx perform so well

Why does SQLynx perform so well

Comments
2 min read
Mastering SQL Temporal Tables for Effective Data Versioning

Mastering SQL Temporal Tables for Effective Data Versioning

Comments
4 min read
🚀 Building Permalist: my Journey Through making a Dynamic To-Do List App

🚀 Building Permalist: my Journey Through making a Dynamic To-Do List App

1
Comments 1
3 min read
System design: SQL vs NoSQL Databases: A Deep Dive

System design: SQL vs NoSQL Databases: A Deep Dive

Comments
6 min read
How to get several data count in a single query by applying conditions

How to get several data count in a single query by applying conditions

1
Comments
1 min read
loading...