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 NL2SQL Tools Like Chat2DB Simplify Data

How NL2SQL Tools Like Chat2DB Simplify Data

Comments
11 min read
SQL Injection คืออะไร? และวิธีการป้องกัน

SQL Injection คืออะไร? และวิธีการป้องกัน

Comments
1 min read
Cost Comparison: Neon vs. Azure Database for PostgreSQL Flexible Server

Cost Comparison: Neon vs. Azure Database for PostgreSQL Flexible Server

5
Comments
7 min read
Trees in SQL

Trees in SQL

Comments
9 min read
SQL 101 | Chapter 1: Understanding SQL and Databases

SQL 101 | Chapter 1: Understanding SQL and Databases

1
Comments
3 min read
Trees in SQL (part 2)

Trees in SQL (part 2)

Comments
5 min read
3 Things You Need To Take Control Of Your Database

3 Things You Need To Take Control Of Your Database

Comments
3 min read
SSIS for Modern Data Integration

SSIS for Modern Data Integration

Comments
3 min read
How To Use Materialized Views

How To Use Materialized Views

Comments
5 min read
SQL Filtering and Sorting with Real-life Examples

SQL Filtering and Sorting with Real-life Examples

Comments
4 min read
Reading Parallel Plans Correctly

Reading Parallel Plans Correctly

Comments
5 min read
Simplify SQL Server Integration with ADONet Sql Server Tools for .NET

Simplify SQL Server Integration with ADONet Sql Server Tools for .NET

Comments
2 min read
How PostgreSQL Powers the Future of Data-Driven Applications

How PostgreSQL Powers the Future of Data-Driven Applications

Comments
1 min read
PostgreSQL vs. Other Databases: Why It’s the Top Choice for Modern Applications

PostgreSQL vs. Other Databases: Why It’s the Top Choice for Modern Applications

Comments
1 min read
T-SQL avanzato: tecniche da ricordare

T-SQL avanzato: tecniche da ricordare

Comments
3 min read
Front-End to Full-Stack Journey: SQL & SQLite

Front-End to Full-Stack Journey: SQL & SQLite

Comments
3 min read
Day13 ---->SQL Quers and simple example:

Day13 ---->SQL Quers and simple example:

Comments
1 min read
Find high dead_tuples

Find high dead_tuples

Comments
1 min read
Check Table size in Postgresql Database

Check Table size in Postgresql Database

Comments
1 min read
Reasons for Index Invalidity in Databases

Reasons for Index Invalidity in Databases

Comments
4 min read
Bringing PostgreSQL Query Issues to Light with Insightful Visuals

Bringing PostgreSQL Query Issues to Light with Insightful Visuals

Comments
3 min read
Como criar um projeto iniciante em análise de dados

Como criar um projeto iniciante em análise de dados

Comments
6 min read
They Stopped Using Load Tests - And Here Is Why

They Stopped Using Load Tests - And Here Is Why

Comments
3 min read
Top 5 Text2SQL Tools for Effortless SQL Generation

Top 5 Text2SQL Tools for Effortless SQL Generation

Comments
7 min read
Time-saver: This IDEA plugin can help you write FlinkSQL faster

Time-saver: This IDEA plugin can help you write FlinkSQL faster

Comments
1 min read
2024.2: Faster with Shared Memory Between PostgreSQL and TServer Layers

2024.2: Faster with Shared Memory Between PostgreSQL and TServer Layers

Comments
4 min read
Top AI Tools for Generating SQL in 2024

Top AI Tools for Generating SQL in 2024

Comments
8 min read
Migrating from Azure Database for PostgreSQL to Neon

Migrating from Azure Database for PostgreSQL to Neon

9
Comments
7 min read
How to detect query which holds the lock in Postgres?

How to detect query which holds the lock in Postgres?

Comments
1 min read
Database Tools 🛢️🔧 in 2024: A Year in Review 🗓️

Database Tools 🛢️🔧 in 2024: A Year in Review 🗓️

44
Comments 2
3 min read
How to Reset a Forgotten MariaDB User Password

How to Reset a Forgotten MariaDB User Password

Comments
1 min read
SQL database projects intro

SQL database projects intro

Comments
5 min read
Query optimization in MySQL is crucial for improving database performance, especially when dealing with large datasets

Query optimization in MySQL is crucial for improving database performance, especially when dealing with large datasets

Comments
2 min read
Rust-Based Reimagining of SQLite: Leading Asynchronous I/O and Contemporary Improvements

Rust-Based Reimagining of SQLite: Leading Asynchronous I/O and Contemporary Improvements

Comments
2 min read
SQL in CouchDB: Get SQS for FREE and Celebrate Our Birthday

SQL in CouchDB: Get SQS for FREE and Celebrate Our Birthday

Comments
3 min read
Technical Interview Questions - Part 6 - SQL 2

Technical Interview Questions - Part 6 - SQL 2

Comments
3 min read
Multi combination condition grouping and aggregation #eg93

Multi combination condition grouping and aggregation #eg93

7
Comments
1 min read
The Importance of Minimizing Database Queries in Backend Development

The Importance of Minimizing Database Queries in Backend Development

Comments
1 min read
"Тайны Pawsgresville: Дело об исчезнувших данных". Идексы Postgres.

"Тайны Pawsgresville: Дело об исчезнувших данных". Идексы Postgres.

1
Comments
2 min read
Front-End to Full-Stack Journey: Part #1

Front-End to Full-Stack Journey: Part #1

Comments
4 min read
Data Engineer as a Real-Time Algo Trader – Turning Pipelines into Profit (or at Least Trying)!

Data Engineer as a Real-Time Algo Trader – Turning Pipelines into Profit (or at Least Trying)!

Comments
13 min read
How I Completed My First SQL Project (And What I Learned)

How I Completed My First SQL Project (And What I Learned)

2
Comments
3 min read
Simple SQL Statements Only Exist in Coursebooks and Training Courses

Simple SQL Statements Only Exist in Coursebooks and Training Courses

6
Comments
7 min read
DBA Considered Harmful

DBA Considered Harmful

Comments
4 min read
Improve Your SQL Server Database Design and Management in 2025 with a GUI Tool

Improve Your SQL Server Database Design and Management in 2025 with a GUI Tool

3
Comments 1
6 min read
Sql Resumo

Sql Resumo

Comments
2 min read
BigQuery SQL

BigQuery SQL

Comments
3 min read
SQL Query basicos.

SQL Query basicos.

Comments
4 min read
Introduction to SQL: Day 1 - A Beginner's Guide to Databases

Introduction to SQL: Day 1 - A Beginner's Guide to Databases

Comments
3 min read
Connect to multiple databases, make or generate SQL queries, analyze or visualize.

Connect to multiple databases, make or generate SQL queries, analyze or visualize.

Comments
3 min read
SQL 101 | Summary of Most Used SQL Syntax for Data Analysis

SQL 101 | Summary of Most Used SQL Syntax for Data Analysis

Comments
2 min read
SQL (Structured Query Language)

SQL (Structured Query Language)

Comments
4 min read
SQL Exercicios.

SQL Exercicios.

1
Comments
9 min read
The Justin Beiber database problem!

The Justin Beiber database problem!

1
Comments
1 min read
Designing a Production-Grade Database for High-Traffic Applications on AWS RDS MySQL

Designing a Production-Grade Database for High-Traffic Applications on AWS RDS MySQL

Comments
4 min read
Entity Framework Core | Object Relation Mapping | C# | A Beginner's Guide : Mastering

Entity Framework Core | Object Relation Mapping | C# | A Beginner's Guide : Mastering

7
Comments
3 min read
Advancing Data Access with Text to SQL Technology

Advancing Data Access with Text to SQL Technology

Comments
5 min read
SQL Quick Reference: Simplifying Database Management

SQL Quick Reference: Simplifying Database Management

Comments
4 min read
LIBRARY MANAGEMENT SYSTEM USING JAVA AND SQL

LIBRARY MANAGEMENT SYSTEM USING JAVA AND SQL

Comments
1 min read
SQL: Recursive calculation of tree like hierarchical structure #eg83

SQL: Recursive calculation of tree like hierarchical structure #eg83

6
Comments
2 min read
loading...