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.
# 揭秘Proof of SQL:让数据验证变得高效又安全

# 揭秘Proof of SQL:让数据验证变得高效又安全

Comments
1 min read
Зоопарк Hibernate: N+1 запросов или как накормить жадного бегемота

Зоопарк Hibernate: N+1 запросов или как накормить жадного бегемота

1
Comments
2 min read
3 Hot Trends In Database Reliability

3 Hot Trends In Database Reliability

Comments
4 min read
Creational Design Patterns

Creational Design Patterns

Comments
2 min read
Entity Relationship Diagram[ERD]

Entity Relationship Diagram[ERD]

Comments
2 min read
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
5 Essential SQL Skills Learned from a Decade of Experience

5 Essential SQL Skills Learned from a Decade of Experience

18
Comments 3
4 min read
ROLLUP

ROLLUP

Comments
2 min read
How to remove duplicates in Postgres SQL

How to remove duplicates in Postgres SQL

Comments
4 min read
How We Built 🔧🦾 the SQL Autocomplete Framework ⚙️🧱 with ANTLR4

How We Built 🔧🦾 the SQL Autocomplete Framework ⚙️🧱 with ANTLR4

5
Comments
10 min read
Building a Secure, Scalable Learning Platform with RBAC Features 🎓🔒📚

Building a Secure, Scalable Learning Platform with RBAC Features 🎓🔒📚

Comments
6 min read
SQL Window functions: Understanding PARTITION BY

SQL Window functions: Understanding PARTITION BY

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

How to use variables in SQL raiserror

Comments
1 min read
Database Sharding: Simplifying Data Scalability

Database Sharding: Simplifying Data Scalability

Comments
7 min read
Database Normalization

Database Normalization

2
Comments
4 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?

29
Comments 4
4 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
The Prisma ORM: A Brief Overview and Introduction

The Prisma ORM: A Brief Overview and Introduction

3
Comments
9 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
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

2
Comments
3 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
Populating a Vertica Database with Random Data

Populating a Vertica Database with Random Data

Comments
4 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? 😤

25
Comments 8
13 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
loading...