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.
Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40
judith677 profile

Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40

#programming #database #sql #esprocspl
11
Comments 3
2 min read
Find Consecutive Alphabetical Characters in String — From SQL to SPL #28
judith677 profile

Find Consecutive Alphabetical Characters in String — From SQL to SPL #28

#programming #database #sql #esproc
8
Comments 1
2 min read
SQL Injection: All Concepts, All Payloads, All In One
deoxys profile

SQL Injection: All Concepts, All Payloads, All In One

#programming #tutorial #sql #cybersecurity
15
Comments 4
8 min read
How to Speed Up Associations between Large Primary and Sub Tables with esProc
esproc_spl profile

How to Speed Up Associations between Large Primary and Sub Tables with esProc

#mysql #sql #devops #esproc
7
Comments 1
4 min read
Understanding Query Cost in SQL
samitkapoor profile

Understanding Query Cost in SQL

#sql #database
2
Comments 1
7 min read
.NET EF Core: When to Use (or don't) .AsSplitQuery()
vyavorskyi profile

.NET EF Core: When to Use (or don't) .AsSplitQuery()

#dotnet #sql #efcore #dotnetcore
Comments
4 min read
MySQL Tutorial: A Complete Guide to Mastering Database Management
pythontutorial profile

MySQL Tutorial: A Complete Guide to Mastering Database Management

#mysql #sql #tutorial #mysqltutorial
2
Comments
3 min read
$lookup: more than just a SQL join (understand performance)
franckpachot profile

$lookup: more than just a SQL join (understand performance)

#mongodb #document #database #sql
8
Comments 1
5 min read
Integration testing tRPC and in memory MySQL database.
pietro_palmesi_b8b68ba0f6 profile

Integration testing tRPC and in memory MySQL database.

#t3 #nextjs #vitest #sql
1
Comments
5 min read
Solving One-to-Many Update Issues in Status Tracking Systems
galisetty_priyatham_c1a49 profile

Solving One-to-Many Update Issues in Status Tracking Systems

#java #sql #programming #webdev
3
Comments 5
1 min read
Why Transactional Databases Matter: Concepts, Use Cases, and Examples
rizkytegar profile

Why Transactional Databases Matter: Concepts, Use Cases, and Examples

#sql #database
2
Comments 2
3 min read
Total under Recursive Relationship — From SQL to SPL #33
judith677 profile

Total under Recursive Relationship — From SQL to SPL #33

#programming #database #sql #esprocspl
7
Comments 1
2 min read
Building a Robust SQLite Query Builder in TypeScript: Lessons from an Arabic Dictionary App
aomuiz profile

Building a Robust SQLite Query Builder in TypeScript: Lessons from an Arabic Dictionary App

#webdev #reactnative #react #sql
2
Comments
4 min read
How to Handle Millions of Rows in SQL Without Killing Performance
jhonifaber profile

How to Handle Millions of Rows in SQL Without Killing Performance

#database #sql #performance
29
Comments 1
2 min read
Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference
op3ratordec profile

Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference

#postgres #mysql #sql #database
5
Comments 1
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.