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.
$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
#34 50 Advanced SQL Queries Every Developer Should Know
flnzba profile

#34 50 Advanced SQL Queries Every Developer Should Know

#sql #database #dataengineering
2
Comments
7 min read
Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24
judith677 profile

Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24

#programming #database #sql #esprocspl
6
Comments 1
3 min read
Identifying Stored Procedures Created or Modified Within a Date Range in SQL Server
seanmdrew profile

Identifying Stored Procedures Created or Modified Within a Date Range in SQL Server

#sqlserver #sql
1
Comments 2
2 min read
Stop Forcing Time Windows on Bursty User Behavior - Try This Instead
risingwavelabs profile

Stop Forcing Time Windows on Bursty User Behavior - Try This Instead

#news #datascience #database #sql
Comments 1
4 min read
Oracle 21c Enhancements for TTS Export/Import
vahidusefzadeh profile

Oracle 21c Enhancements for TTS Export/Import

#devops #linux #database #sql
Comments
2 min read
IoT monitoring with Kafka and Tinybird
tbperegrine profile

IoT monitoring with Kafka and Tinybird

#analytics #eventdriven #programming #sql
1
Comments
9 min read
The Best Tools to Design Database Schemas Visually in 2025
roxana_haidiner profile

The Best Tools to Design Database Schemas Visually in 2025

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