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.
I built a 57-line asyncpg wrapper because SQLAlchemy was driving me insane
kernz profile
kernz

I built a 57-line asyncpg wrapper because SQLAlchemy was driving me insane

#sql #python #sqlalchemy #postgres
5
Comments
2 min read
I Analyzed 10 Million Records in 47 Seconds Using Python + DuckDB (No Spark, No Cloud)
dattasable profile

I Analyzed 10 Million Records in 47 Seconds Using Python + DuckDB (No Spark, No Cloud)

#sql #python #dataengineering #tutorial
2
Comments 1
3 min read
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
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
Does ClickHouse Support UPDATEs? A 2026 Data Analysis
manveer_chawla_64a7283d5a profile

Does ClickHouse Support UPDATEs? A 2026 Data Analysis

#database #analytics #dataengineering #sql
6
Comments 1
25 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.