#Database.
Database tutorials covering SQL, NoSQL, data modeling, migrations, and database management systems.
How to Install PostgreSQL & pgAdmin 4 on Ubuntu & Linux (2026)
Step-by-step guide to installing PostgreSQL 16/17 and pgAdmin 4 on Ubuntu 24.04/22.04 LTS via official PPA with remote access and security configuration.
How to Install Redis Server & Redis CLI on Ubuntu & Linux (2026)
Step-by-step guide to installing Redis Server and Redis CLI on Ubuntu 24.04/22.04 LTS via official APT repository with security, password, and systemd setup.
10 MCP Servers Every Developer Should Know in 2026
The best MCP servers for GitHub, databases, Slack, browsers, and more. Official references, community-maintained servers, and custom builds — tested across Claude Code, Cursor, and Windsurf.
Drizzle ORM Schema & Queries Cheatsheet: The Complete Reference
A comprehensive reference for Drizzle ORM schemas, relationships, query builder APIs, and advanced migrations.
PostgreSQL Performance Tuning: Indexing, Queries, and Configuration
Practical PostgreSQL performance guide for developers. Indexing strategies, query optimization with EXPLAIN ANALYZE, memory tuning, and connection pooling. PostgreSQL 18 benchmarks included.
AWS DynamoDB Single-Table Design Cheatsheet: The Complete Reference
Model relational data in NoSQL: DynamoDB single-table design, partition keys, sort keys, Global Secondary Indexes (GSIs), and transactional patterns.
ClickHouse Cheat Sheet: Commands, Schema Design & Performance
Complete ClickHouse reference — SELECT patterns, aggregations, array functions, window functions, schema design, materialized views, row-level security, and performance tuning in 2026.
Install and Configure PostgreSQL on Ubuntu 26.04
Complete guide to install PostgreSQL 18 on Ubuntu 26.04. Set up roles, databases, remote access, authentication methods, and security hardening.
Install and Secure MySQL on Ubuntu 26.04
Complete guide to install and harden MySQL on Ubuntu 26.04. Run mysql_secure_installation, create users and databases, configure remote access with firewall rules.
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 deep 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
Master Laravel 12 migrations with unsigned columns. Learn foreignId(), unsignedBigInteger(), and best practices for foreign key constraints in modern PHP applications.
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
Find solutions and explanations for common HackerRank SQL practice problems, covering basic SELECT queries, JOINs, subqueries, and aggregate functions.
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
Learn how to configure and allow remote access to your MySQL database server. Step-by-step guide for enabling network connections, configuring bind addresses, and setting up user permissions for remote clients.
Related Topics
Discover more topics that complement what you've been reading about.