Anonymous View

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.
Stop Using Subqueries: 3 Advanced SQL CTE Patterns That Saved My Production Database
dattasable profile

Stop Using Subqueries: 3 Advanced SQL CTE Patterns That Saved My Production Database

#sql #database #dataengineering #programming
Comments 1
3 min read
DuckDB 1.5.1, MacBook Benchmarks, & Browser-based Postgres Workspace
soytuber profile
soy

DuckDB 1.5.1, MacBook Benchmarks, & Browser-based Postgres Workspace

#database #sql #sqlite
Comments
3 min read
REDB inside, part 1 — the 13 tables the whole engine runs on (with the actual SQL, and why it's not EAV)
rinat_kozin profile

REDB inside, part 1 — the 13 tables the whole engine runs on (with the actual SQL, and why it's not EAV)

#dotnet #postgres #sql #opensource
2
Comments 2
15 min read
Four Ways to Use AI With Your Database in VS Code
mike_burgh profile

Four Ways to Use AI With Your Database in VS Code

#vscode #database #ai #sql
Comments 1
2 min read
PostgreSQL WHERE Clause Optimization
philip_mcclarence_2ef9475 profile

PostgreSQL WHERE Clause Optimization

#database #performance #postgres #sql
Comments
9 min read
NPI Number Validation: How to Clean and Enrich Provider Data in Your Database
season_mudbhary_7856e4083 profile

NPI Number Validation: How to Clean and Enrich Provider Data in Your Database

#healthcare #sql #dataengineering #database
Comments
6 min read
HCC Risk Adjustment Data Model: Building Accurate Risk Score Pipelines in SQL
season_mudbhary_7856e4083 profile

HCC Risk Adjustment Data Model: Building Accurate Risk Score Pipelines in SQL

#healthcare #sql #dataengineering #database
Comments 1
6 min read
Database Indexing Strategies (Clustered vs Non-clustered)
godofgeeks profile

Database Indexing Strategies (Clustered vs Non-clustered)

#database #performance #sql #tutorial
1
Comments
10 min read
No signup, just boxes and arrows: building a free ER diagram editor
erdiagram profile

No signup, just boxes and arrows: building a free ER diagram editor

#webdev #svelte #sql #sideprojects
1
Comments
5 min read
Turning PostgreSQL Into an Integration Engine
gouranga-das-khulna profile

Turning PostgreSQL Into an Integration Engine

#postgres #sql #database
1
Comments
3 min read
Subqueries and CTEs: SQL Gets Readable
yakhilesh profile

Subqueries and CTEs: SQL Gets Readable

#sql #database #ai #beginners
Comments
6 min read
Why Standard Indexes Fail: The Architecture of the Covering Index
opeyemi_oluwagbemiga_a213 profile

Why Standard Indexes Fail: The Architecture of the Covering Index

#architecture #database #sql #postgres
Comments
4 min read
Joins: Combining Tables Without Losing Your Mind
yakhilesh profile

Joins: Combining Tables Without Losing Your Mind

#sql #ai #beginners #python
Comments
8 min read
Best Database Clients in 2026: Top SQL GUI Tools Compared
dory-nemo profile
Finn

Best Database Clients in 2026: Top SQL GUI Tools Compared

#ai #sql #database #dataengineering
1
Comments
11 min read
The database is where AI agents in production get weird
saluc28 profile

The database is where AI agents in production get weird

#ai #database #sql #llm
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.