Platforming The Future
As a seasoned technology leader with a passion for technology, I'm excited to share my insights on industry trends, best practices, and emerging technologies. Join me as I explore the latest developments in platform engineering, cloud computing, devops, agile methodologies, artificial intelligence and more. I do not have a regular posting cadence, but I do try to keep this feed fairly current.
Explore the powerful unique features of ClickHouse, a high-performance columnar database designed for real-time analytics.
Explore Valkey, an open-source alternative to Redis, offering improved multi-core performance, scalability, and memory efficiency.
Successfully migrated from MySQL to PostgreSQL! This post is a quick summary of the process, including tackling SQL syntax differences and parameterized queries.
Reclaiming compute resources: My journey migrating from WordPress to Grav CMS. Learn why I am swapping MySQL for PostgreSQL to streamline my digital twin project.
Explore distributed SQL databases like CockroachDB and YugabyteDB. Learn about key characteristics, benefits, and how they compare to traditional relational databases.
An introduction to ClickHouse: The open-source, column-oriented database used by Uber and CERN for high-volume, real-time analytics and horizontal scalability.
Redis vs. KeyDB: A comparison of in-memory data stores for caching, session management, and real-time data processing.
Identify database bottlenecks and slow queries with PgBadger. Discover how to parse PostgreSQL and PgBouncer logs into actionable, graph-heavy HTML reports.
Master PgBouncer tuning for PostgreSQL. Learn how to configure pool sizes, connection limits, and timeouts to optimize high-transaction database environments.
Learn how to tune key PostgreSQL parameters like max_connections, shared_buffers, and work_mem to improve database performance and efficiency.
