Database Index Page 1
IBM DB2 Administration Cheatsheet — Essential Commands (2026)
IBM DB2 LUW quick reference 2026. Commands for start/stop, connect, list databases, backup, users, locks, performance, and common error codes. DB2 11.1, 11.5, 12.x.
Database Index Page 1
db2stop Command Guide — Stop IBM DB2 Safely (db2stop force)
db2stop and db2stop force command reference for IBM DB2 LUW. Stop DB2 gracefully, force stop with active connections, restart, and recover from SQL1032N and SQL1025N errors.
Database Index Page 1
PostgreSQL: Create Database with UTF-8 Encoding [Complete Guide]
Create PostgreSQL database with UTF8 encoding. Fix template encoding errors. Guide covers locale, collation, and encoding conversion.
Database Index Page 1
SQLAlchemy Bulk Insert 2026: 40x Faster with Core & ORM 2.0 Methods
Master SQLAlchemy 2.0 bulk insert for maximum performance. Compare Core insert (40x), ORM 2.0 session.execute (20x), and PostgreSQL COPY (240x) with real benchmarks.
Database Index Page 1
SQL: INNER JOIN vs OUTER JOIN Explained
For beginners when learning JOIN it's a common error to ignore different types of JOIN. Some junior developers could use a wrong JOIN that looks like correct when it's not the case. Make sure you learn differences between LEFT JOIN and RIGHT JOIN
Database Index Page 1
How to Use Golang with PostgreSQL - Complete Guide
Learn how to connect Golang to PostgreSQL, perform CRUD operations, use prepared statements, and handle transactions with the pq driver.
Database Index Page 1
Oracle SQL: How to write a que for filterting Date columns
Oracle SQL date format can be tricky to understand and could make you loose time to figure out why a query is not working. We use TRUNCATE and TO_DATE function to create a query to filter by a date on a timestamp column.
Database Index Page 1
Postgres query performance analysis and optimization
Learn how to analyze and optimize postgres query performance with an example.
Database Index Page 1
How to add or resize swap partition on Ubuntu 16.04
Learn how to add more swap space to Ubuntu 16.04. Also learn how to resize a swap partition.
Database Index Page 1
PostgreSQL Configuration Tuning
Learn how to tune PostgreSQL for optimal performance. Configure shared_buffers, work_mem, effective_cache_size and other key parameters.