sql5 févr. 2026SQL Window Functions: The Feature That Changed How I Write Every QueryWindow functions are the single most underused SQL feature. Running totals, rankings, moving averages, gap analysis, and session detection — all without subqueries. Real examples from production databases.postgresqldatabaseperformancebackendLire la suite SQL Window Functions: The Feature That Changed How I Write Every Query
sql16 janv. 2026SQL Cheat Sheet 2026: Essential Queries Every Developer NeedsMaster SQL with this comprehensive cheat sheet. Learn essential queries, JOINs, subqueries, window functions, and optimization tips with practical examples.databasedeveloper-toolscheat-sheetLire la suite SQL Cheat Sheet 2026: Essential Queries Every Developer Needs
database16 sept. 2025Conception de schéma de base de données : des patterns qui vieillissent bienRègles de normalisation, conventions de nommage, soft deletes, audit trails, patterns multi-tenancy, stratégies de versioning et les décisions de schéma que j'ai regrettées. Orienté PostgreSQL.postgresqlarchitecturebackendsqlLire la suite Conception de schéma de base de données : des patterns qui vieillissent bien