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.
PostgreSQL Connection Pooling vs No Pooling: Benchmark Analysis

PostgreSQL Connection Pooling vs No Pooling: Benchmark Analysis

Comments
3 min read
When and Why to Use JSON Columns in SQL Databases

When and Why to Use JSON Columns in SQL Databases

Comments
3 min read
Top 20+ Full-stack Projects For Beginners in C#, ASP.NET , .NET CORE

Top 20+ Full-stack Projects For Beginners in C#, ASP.NET , .NET CORE

1
Comments
3 min read
ROLLUP

ROLLUP

Comments
2 min read
Validatorian

Validatorian

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
7 min read
Access Controls for Users and Roles in SQL

Access Controls for Users and Roles in SQL

Comments
6 min read
The Prisma ORM: A Brief Overview and Introduction

The Prisma ORM: A Brief Overview and Introduction

3
Comments
9 min read
Preventing SQL Injection (SQLi) in React.js Apps

Preventing SQL Injection (SQLi) in React.js Apps

Comments
3 min read
Entendo a ordem de execução de uma query SQL

Entendo a ordem de execução de uma query SQL

Comments
2 min read
Postgres can do that? No surprise Postgres is everywhere

Postgres can do that? No surprise Postgres is everywhere

Comments
9 min read
On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL

On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL

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

Preventing SQL Injection (SQLi) Attacks in Drupal

Comments
3 min read
GrowthBook Version 3.3

GrowthBook Version 3.3

Comments
2 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
How to use variables in SQL raiserror

How to use variables in SQL raiserror

Comments
1 min read
True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?

26
Comments 3
4 min read
Database Sharding: Simplifying Data Scalability

Database Sharding: Simplifying Data Scalability

Comments
7 min read
Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤

Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤

23
Comments 8
13 min read
ChartDB: New Functionalities Unlocked! 🎉

ChartDB: New Functionalities Unlocked! 🎉

10
Comments
2 min read
Understanding SQL Subqueries and Common Table Expressions (CTEs)

Understanding SQL Subqueries and Common Table Expressions (CTEs)

2
Comments
4 min read
Something Would Free Data Scientists from Heavy Coding Work

Something Would Free Data Scientists from Heavy Coding Work

6
Comments
9 min read
Understanding and Using Window Functions in SQL

Understanding and Using Window Functions in SQL

Comments
1 min read
SQL Server Execution Plans

SQL Server Execution Plans

8
Comments
5 min read
How indexes power your database

How indexes power your database

3
Comments
4 min read
Top 🐘👀 Postgres Monitoring Tools 🧰 and Best Practices in 2024 🔝

Top 🐘👀 Postgres Monitoring Tools 🧰 and Best Practices in 2024 🔝

5
Comments
4 min read
These 10+ comparisons cover entire SQL concepts, Is it?

These 10+ comparisons cover entire SQL concepts, Is it?

Comments
6 min read
Advanced Paradigms in Data Ingestion: Integrating Big Data Ecosystems with Linux, SQL

Advanced Paradigms in Data Ingestion: Integrating Big Data Ecosystems with Linux, SQL

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

SQL Injection (SQLi) Vulnerabilities in WordPress: Prevention Tips

Comments
3 min read
SQL Server: Usare l'Istruzione LIKE all'Interno di una WHERE

SQL Server: Usare l'Istruzione LIKE all'Interno di una WHERE

Comments
3 min read
SQL Indexes

SQL Indexes

Comments
3 min read
Split a Huge CSV File into Multiple Smaller CSV Files #eg69

Split a Huge CSV File into Multiple Smaller CSV Files #eg69

6
Comments 1
1 min read
My journey learning Apache Spark

My journey learning Apache Spark

Comments
2 min read
Introduction to DBMS

Introduction to DBMS

Comments
4 min read
SQL "SELECT INTO" vs "INSERT INTO SELECT" statements.

SQL "SELECT INTO" vs "INSERT INTO SELECT" statements.

Comments
1 min read
How Pipe Syntax Fix SQL Design Problems

How Pipe Syntax Fix SQL Design Problems

Comments
5 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

3
Comments
4 min read
I'm looking for a FullStack Software Developer Role

I'm looking for a FullStack Software Developer Role

Comments
2 min read
Why Doesn't Postgres Use My Index

Why Doesn't Postgres Use My Index

Comments
16 min read
Data Hunter Game

Data Hunter Game

1
Comments 2
3 min read
What else can Stream&Kotlin evolve into?

What else can Stream&Kotlin evolve into?

6
Comments
6 min read
Technical Interview Questions - Part 4 - Git + SQL vs noSQL

Technical Interview Questions - Part 4 - Git + SQL vs noSQL

8
Comments
3 min read
How to Query CSV Files with SQLite

How to Query CSV Files with SQLite

Comments
8 min read
What Are Stored Procedures?

What Are Stored Procedures?

Comments
8 min read
SQL Leetcode Questions

SQL Leetcode Questions

27
Comments 2
3 min read
Populating a Vertica Database with Random Data

Populating a Vertica Database with Random Data

Comments
4 min read
Exploring Microsoft SQL Server: Powering Enterprise Data Management

Exploring Microsoft SQL Server: Powering Enterprise Data Management

Comments
10 min read
Relational vs. Document Databases: Key Differences, Use Cases, and Performance

Relational vs. Document Databases: Key Differences, Use Cases, and Performance

Comments
3 min read
How to connect and query multiple databases with a single REST API

How to connect and query multiple databases with a single REST API

Comments
3 min read
Dynamic SQL in PL/SQL

Dynamic SQL in PL/SQL

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

Intro to SQL using Apache Iceberg and Dremio

2
Comments
22 min read
How to Secure Web Applications: Top Security Practices

How to Secure Web Applications: Top Security Practices

Comments
3 min read
Indexes Under The Hood

Indexes Under The Hood

1
Comments
14 min read
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
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
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
loading...