sql Archives - ITNotes

SQL Joins in Production: How We Fixed Our 10-Second Query Problem

June 1, 2026

A production-focused guide to SQL Joins. Learn the differences between INNER, LEFT, and FULL OUTER joins, and discover how to optimize query performance using indexing and CTEs based on real-world experience.

Database

Why SurrealDB is the Only Database You Need for Your Next Project

May 30, 2026

Tired of syncing SQL and NoSQL? Learn how SurrealDB combines document, graph, and relational models into one ultra-fast database with built-in auth and real-time queries.

Database

Hardening Multi-tenant Apps: Why You Need PostgreSQL Row Level Security

May 28, 2026

Discover how PostgreSQL Row Level Security (RLS) provides a native, foolproof layer of protection for multi-tenant apps. Stop relying on manual filters and secure your data at the source.

Database

Soft Delete Pattern in Database: Safe Record Deletion, Recovery, and Index Optimization with PostgreSQL and MySQL

May 21, 2026

Soft delete pattern lets you mark records as deleted instead of physically removing them — enabling safe recovery, audit trails, and GDPR-compliant data retention. This guide covers practical implementation in PostgreSQL and MySQL, including partial indexes, unique constraint handling, and cleanup strategies.

Database

Database Testing with pgTAP in PostgreSQL: A Guide to Unit Testing Functions, Triggers, and Schema

May 20, 2026

Learn how to use pgTAP to write native unit tests for PostgreSQL. This guide covers testing database schema, functions, and triggers to ensure your data logic remains robust and bug-free.

Database

Dolt Guide: SQL with Git Powers for Versioned Development

May 8, 2026

Dolt brings Git-like versioning to the SQL world. Learn how to branch, diff, and merge your data to prevent accidental loss and streamline collaborative development.

Database

PostgreSQL Materialized Views: Turning 15-Second Queries into 5ms Snapshots

May 4, 2026

Stop making your users wait for slow dashboards. This guide shows you how to cache complex PostgreSQL queries using Materialized Views, including concurrent refresh tricks and automation.

Database

Querying MySQL, MongoDB, and CSV Directly from PostgreSQL using FDW

May 1, 2026

Tired of ETL? Learn how to use PostgreSQL Foreign Data Wrappers (FDW) to query MySQL, MongoDB, and CSV files as if they were local tables. Real-world performance tips included.

Database

PostgreSQL Stored Procedures and Triggers: Stop Leaking Your Business Logic

April 30, 2026

Stop duplicating business logic across microservices. Learn how to use PostgreSQL Stored Procedures and Triggers to centralize your rules and slash API latency.

Database

PostgreSQL JSONB: Schema Flexibility Without the NoSQL Headache

April 27, 2026

PostgreSQL JSONB offers the best of both worlds: relational integrity and NoSQL flexibility. Learn how to implement it, index it for speed, and avoid common production pitfalls.