Articles tagged "database"
Page 1 of 2
PostgreSQL Full-Text Search Tutorial 2026: tsvector, GIN Indexes, Ranking, and Autocomplete
PostgreSQL full-text search tutorial 2026: tsvector, tsquery, GIN indexes for sub-50ms searches on 1M rows, ts_rank relevance ranking, multi-language stemming, autocomplete with pg_trgm, and when to use Elasticsearch instead.
Redis Tutorial for Python Developers 2026: Caching, Rate Limiting, Pub/Sub, and Streams
Redis tutorial for Python developers 2026: API response caching with cache invalidation, token bucket rate limiter, pub/sub for real-time notifications, and Redis Streams for event sourcing — with redis-py and aioredis.
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.
db2stop force: How to Stop a DB2 Instance Safely (2026 Guide)
Learn how to use db2stop and db2stop force to stop a DB2 instance safely. Includes error handling when db2stop force fails.
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.
SQLAlchemy Bulk Insert 2026: The Fastest Methods Compared (40x to 240x Speedup)
SQLAlchemy bulk insert performance guide 2026. ORM add_all vs bulk_save_objects vs Core execute_many (40x) vs PostgreSQL COPY via psycopg2 (240x). Real benchmarks with 100K rows. Async support included.
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
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.
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.
Postgres query performance analysis and optimization
Learn how to analyze and optimize postgres query performance with an example.