sql Archives - ITNotes

Querying PostgreSQL, MySQL, and MinIO with Trino: A Single SQL Interface for Multi-Source Data Analysis

August 24, 2026

Learn how to use Trino to run federated SQL queries across PostgreSQL, MySQL, and MinIO S3. This guide covers setup, configuration, and performance tips for multi-source data analysis without ETL.

Database

Deploying QuestDB on Docker: A Guide to High-Velocity Time-Series Data

August 2, 2026

Scale your IoT or Fintech data with QuestDB on Docker. This guide covers high-speed ingestion, SQL optimization, and a direct comparison with InfluxDB and TimescaleDB.

Database

GitOps for Databases: Using Bytebase to Automate SQL Reviews and Prevent Downtime

August 1, 2026

Stop risking production downtime with manual SQL scripts. Learn how to implement a GitOps workflow using Bytebase to automate database reviews, linting, and deployments.

Stop Fighting Regex: Build an Intelligent ETL with LLMs and Pydantic

July 28, 2026

Ditch fragile Regex. Learn how to build a modern ETL pipeline that converts messy, unstructured text into clean, validated SQL data using Python, GPT-4o, and Pydantic.

Database

Time Travel in SQL: Using Temporal Tables in MariaDB and PostgreSQL

July 12, 2026

Don't let accidental updates ruin your night. Discover how to implement 'Time Travel' queries in MariaDB and PostgreSQL to recover data instantly and automate your audit trails.

Security

Building a Self-Hosted EDR with osquery on Linux: Monitor Processes, Network, and File Changes Using SQL

June 30, 2026

osquery lets you query your Linux system like a database — every process, network socket, and file event becomes a SQL row. After six months running it in production as a self-hosted EDR, here is a complete setup guide covering installation, scheduled monitoring queries, file integrity detection, and a simple alert pipeline.

Database

PostgreSQL pg_trgm: Build Fuzzy Search, Typo-Tolerant Queries, and Autocomplete with Trigram Indexes

June 28, 2026

Learn how to use PostgreSQL's pg_trgm extension to build fuzzy search that handles typos, powers autocomplete, and accelerates LIKE queries with trigram indexes. Includes practical GIN index setup, similarity threshold tuning, and hybrid search patterns.

Machine Learning Directly in PostgreSQL: Train and Predict Using SQL

June 25, 2026

Stop moving data. Learn how to train and deploy XGBoost and Scikit-learn models directly inside PostgreSQL using PostgresML and standard SQL queries.

Database

ERD Design with dbdiagram.io: From Concept to Auto-Generated SQL

June 24, 2026

Jumping straight into SQL without a plan leads to messy schemas that are painful to refactor later. This guide walks through designing an ERD with dbdiagram.io using DBML syntax, then automatically exporting production-ready SQL — no boilerplate required.

Database

SQLFluff on Linux: Automate SQL Linting and Code Standards in Your CI/CD Pipeline

June 15, 2026

SQLFluff is a SQL linter and auto-formatter for Linux that catches style inconsistencies, enforces keyword casing, and integrates cleanly into GitHub Actions and GitLab CI pipelines. This guide walks through installation, configuration for MySQL/PostgreSQL dialects, CI/CD setup, and practical tips for rolling it out to an existing codebase.