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.
MySQL vs MongoDB - Visual Design with Real Data Models
roxana_haidiner profile

MySQL vs MongoDB - Visual Design with Real Data Models

#mysql #mongodb #sql #nosql
11
Comments 2
5 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
Beginner’s Guide to Designing a Relational Database Schema
roxana_haidiner profile

Beginner’s Guide to Designing a Relational Database Schema

#database #sql #schema #mysql
13
Comments 5
4 min read
From Natural Language to SQL: A Deep Dive with Ollama and Granite
aairom profile

From Natural Language to SQL: A Deep Dive with Ollama and Granite

#llm #granite #ollama #sql
1
Comments 2
8 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
#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
👋 Sign in for the ability to sort posts by relevant, latest, or top.