Tag

#sql

9 posts

Backend DevelopmentJuly 2, 202614 min
Postgres MERGE RETURNING: Old and New Values (2026)
Postgres 18 lets MERGE RETURNING return old and new row values in one query. See merge_action(), the xmax alternative, and verified Node.js/TypeScript code.
AI & Machine LearningApril 9, 202610 min
SQL with AI Assistants: The New Era of Data Querying
SQL with AI assistants: Snowflake Copilot, dbForge AI, and SQLAI.ai translate plain English into optimized queries. What works, what still needs review.
Backend DevelopmentJanuary 22, 202611 min
Mastering Right Joins: Practical Applications and Real-World Insights
SQL RIGHT JOIN mastered: when to use it over LEFT JOIN, real reporting examples, edge cases in Postgres/MySQL/SQLite, and why it's rarely the right default.
Architecture & DesignDecember 30, 20259 min
Designing Robust Database Architectures: A Complete Guide
A deep dive into database architecture design — from core principles and performance tuning to real-world scaling strategies used by major tech companies.
Architecture & DesignDecember 20, 202510 min
Mastering Database Migration Strategies: Zero Downtime to Success
Database migration strategies: blue-green, shadow reads, dual-writes, and expand-contract. Zero-downtime playbooks that survive real production traffic.
Backend DevelopmentSeptember 26, 202511 min
SQL vs NoSQL Databases: Choosing the Right Data Backbone
SQL vs NoSQL in 2026: PostgreSQL, MySQL, MongoDB, Cassandra, DynamoDB. Consistency, schema flexibility, scaling, and when each actually fits your workload.
Backend DevelopmentSeptember 18, 202510 min
The Complete Guide to SQL: From Basics to Advanced Queries
SQL from beginner to advanced queries: CRUD, JOINs, subqueries, CTEs, Window Functions, indexes — covering Postgres, MySQL, and SQLite (most examples are portable; vendor-specific differences are noted where they apply).
Backend DevelopmentJanuary 15, 202311 min
Easy Hands on Guide how to get Started With SQL
SQL from zero — SELECT, JOIN, GROUP BY, window functions, CTEs. Hands-on exercises using real tables; works in Postgres, modern SQLite, and MySQL 8.0+.
Backend DevelopmentJanuary 15, 20236 min
Practical SQL Guide an Overview of Where to Start With SQL
Practical SQL guide: where to start, what to learn first, and the core query patterns every developer uses. Core SQL is portable across Postgres, SQLite, and MySQL; vendor-specific extensions (JSONB, etc.) are flagged as such.

Every post in #sql (9)