#Database.
Database tutorials covering SQL, NoSQL, data modeling, migrations, and database management systems.
PostgreSQL Performance Tuning: Query Plans & Connection Pooling
Practical PostgreSQL tuning guide: read EXPLAIN ANALYZE, fix slow queries, use PgBouncer for pooling, and optimize autovacuum for high-performance databases.
Database Indexing: B-trees, Composite Indexes & Performance
Learn how database indexes work, from B-trees to partial indexes. Understand composite index order and how to use EXPLAIN ANALYZE for better performance.
AI-Assisted Eloquent: Database Design with Laravel Boost
Leverage Laravel Boost and AI to generate migrations, design Eloquent relationships, and optimize database schemas. A complete Laravel 13 AI development guide.
PostgreSQL JSONB: Query Patterns & Performance Optimization
Master PostgreSQL JSONB — operators, indexing, querying nested data, aggregation, and performance tuning. Real-world patterns for modern applications.
SQL Cheat Sheet: Queries, Joins, Aggregates & CTEs
The ultimate SQL reference for SELECT syntax, JOINs, subqueries, and window functions. Master CTEs, transactions, and constraints for any relational database.
Run PostgreSQL Locally with Docker in Under 2 Minutes
Learn to run PostgreSQL locally using Docker. Includes persistent volumes, docker-compose setup, GUI client access, and essential dump or restore commands.
How to Debug a Slow SQL Query in PostgreSQL
Step-by-step: find slow queries with pg_stat_statements, read EXPLAIN ANALYZE output, identify missing indexes, fix N+1 queries, and diagnose lock contention.
Unsigned Columns in Laravel Migrations
How to declare unsigned integer columns in Laravel migrations using unsignedBigInteger(), foreignId(), and the unsigned() modifier. Updated for Laravel 12.
PostgreSQL Cheat Sheet: SQL, Indexes, EXPLAIN & psql
Complete PostgreSQL reference — psql commands, CRUD queries, joins, indexes, EXPLAIN ANALYZE, CTEs, window functions, JSONB operators, and admin queries.
Nested Eager Loading in Laravel Eloquent Explained
Reduce database queries in Laravel using nested eager loading. Learn the syntax, conditional loading, and how to optimize deeply related Eloquent models.
Update a Laravel Record Without Touching Timestamps
Update Laravel records without changing updated_at using four methods: the timestamps property, saveQuietly(), withoutTimestamps(), or the query builder.
MySQL - List all Databases
Learn how to list and filter databases in MySQL using SHOW DATABASES, LIKE clauses, and the information_schema. Simple tutorial with practical code examples.
Introduction to SQL
In this article we look into intro about SQL aka **Structured Query Language**. Used by numerous big giant tech companies & by widely popular applications.
HackerRank SQL Practice Solutions
Solutions to common SQL practice problems on HackerRank.
Laravel Eloquent whereTime() Method Explained
Filter Laravel records by time using the whereTime() method. Learn syntax, operators, and practical examples for precise time-based Eloquent queries.
Laravel Eloquent whereDate() Method Explained
Filter Laravel records by date while ignoring time using whereDate(). Learn the syntax, comparison operators, and why raw where() calls often fail for dates.
Laravel firstOrCreate(): Find or Create a Record
Find the first matching record or create a new one automatically with Laravel's firstOrCreate(). Learn syntax, parameters, and how it differs from firstOrNew().
How to Use Laravel firstOrNew() to Find or Prepare Records
Learn how Laravel's firstOrNew() finds a matching record or returns a new instance. Compare it with firstOrCreate() and see real-world examples for your app.
Move Records Between Tables in Laravel
How to move a database record from one table to another in Laravel using replicate(), setTable(), and DB::transaction() to keep the operation atomic and safe.
Drop Composite Indexes in Laravel Migrations
Drop composite indexes in Laravel migrations using dropIndex() with column arrays or named strings. Updated for the latest Laravel 12 anonymous class syntax.
Create Composite Indexes in Laravel Migrations
How to create composite (multi-column) indexes in Laravel migrations using anonymous migration syntax. Covers naming, column order rules, and how to drop them.
Create Database Indexes in Laravel Migrations
How to add single, unique, full-text, and primary key indexes in Laravel migrations. Includes naming, dropping, and when each index type makes sense.
Change Laravel Model Timestamp Column Names
Rename created_at and updated_at in Laravel using model constants. Learn how to customize timestamp names, disable them, or change date formats easily.
SQL - CREATE TABLE Statement
Learn how to use the SQL CREATE TABLE statement to define database structures. Includes data types, constraints, and practical examples for beginners.
How to allow remote access to MySQL database server
How to allow remote access to MySQL database server