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 Leetcode Questions

SQL Leetcode Questions

32
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
Top 5 SQL questions asked in interviews

Top 5 SQL questions asked in interviews

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

7+ Free PostgreSQL Hosting Platforms for Developers in 2024

39
Comments 1
4 min read
Dynamic SQL in PL/SQL

Dynamic SQL in PL/SQL

8
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

1
Comments
5 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
Be careful with join type typos

Be careful with join type typos

2
Comments
1 min read
SQL Interview Questions: A Comprehensive Guide for Developers

SQL Interview Questions: A Comprehensive Guide for Developers

17
Comments 2
3 min read
VACUUM In Postgres Demystified

VACUUM In Postgres Demystified

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

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

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

Uma breve introdução ao Hibernate

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
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
SQL Tutorial in a Fascinating way

SQL Tutorial in a Fascinating way

1
Comments 2
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
My journey learning Apache Spark

My journey learning Apache Spark

1
Comments
2 min read
SQL-92 in TPC Benchmarks: Are They Still Relevant?

SQL-92 in TPC Benchmarks: Are They Still Relevant?

7
Comments
10 min read
What Is a NoSQL Database and When Should You Use It?

What Is a NoSQL Database and When Should You Use It?

7
Comments 4
6 min read
Podman - Create A FHIR-Server & SQL Server

Podman - Create A FHIR-Server & SQL Server

10
Comments
2 min read
Pragma Autonomous Transaction in Oracle PL/SQL | Complete Overview

Pragma Autonomous Transaction in Oracle PL/SQL | Complete Overview

5
Comments
4 min read
Indexes in SQL | Clustered and Non Clustered Index

Indexes in SQL | Clustered and Non Clustered Index

4
Comments
2 min read
Procedure vs Function | PLSQL

Procedure vs Function | PLSQL

1
Comments
2 min read
Mastering Databases: From Optimizing Queries to Distributed Systems — Hoài Nhớ

Mastering Databases: From Optimizing Queries to Distributed Systems — Hoài Nhớ

33
Comments 8
4 min read
Normalisation | 2 NF

Normalisation | 2 NF

5
Comments
2 min read
Normalization | 1 NF

Normalization | 1 NF

5
Comments
1 min read
loading...