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.
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
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
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
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
SQLite Formal Verification, Postgres FTS with ParadeDB, & Multi-DB Schema Diff
soytuber profile
soy

SQLite Formal Verification, Postgres FTS with ParadeDB, & Multi-DB Schema Diff

#database #sql #sqlite
Comments
3 min read
Acacia DB for VS Code: Map your database usage in source code (1.0.0 1.2.0)
acaciaman profile

Acacia DB for VS Code: Map your database usage in source code (1.0.0 1.2.0)

#vscode #database #sql #productivity
Comments
5 min read
PostgreSQL Aggregate and Window Function Tuning
philip_mcclarence_2ef9475 profile

PostgreSQL Aggregate and Window Function Tuning

#database #performance #postgres #sql
Comments
9 min read
Subqueries vs CTEs in SQL: Master Nested Queries and Write Cleaner, Smarter Code
ephantus_macharia_ profile

Subqueries vs CTEs in SQL: Master Nested Queries and Write Cleaner, Smarter Code

#beginners #database #sql #productivity
Comments
3 min read
We built an enterprise integration stack for .NET from scratch: EAV + DSL + runtime
rinat_kozin_d0a2ef43e7824 profile

We built an enterprise integration stack for .NET from scratch: EAV + DSL + runtime

#dotnet #sql #postgres #architecture
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.