Hi, I’m Cary Huang — a tech enthusiast based in Canada. I’ve spent years working with complex production systems and open-source software. Through TechBuddies.io, my team and I share practical engineering insights, curate relevant tech news, and recommend useful tools and products to help developers learn and work more effectively.
Introduction If you’ve ever felt curious — or even a little intimidated — by the massive PostgreSQL codebase, you’re not alone. But don’t worry! This guide is here to give you a gentle, beginner-friendly introduction to the PostgreSQL source code… Read More »A Warm Welcome to the PostgreSQL Source Code!
Introduction This post introduces the fundamentals of PostgreSQL’s data page (block) mechanism and how data retrieval works from a high-level perspective (Relative to PostgreSQL version 16). Understanding physical data storage and access methods, you will gain valuable insight into the… Read More »PostgreSQL Page Structure & Scan Methods Explained Now
Introduction Curious what really powers PostgreSQL behind the scenes? This post exposes core PostgreSQL architecture and storage paradigm that drive its reliability and performance. From backend processes to storage structure and table spaces, we will walk you through all of these pieces and show… Read More »PostgreSQL Architecture and Storage Paradigm Exposed Now
Introduction A “thread per task” model looks simple—until it isn’t. Context-switch overhead stacks up, memory usage balloons, and shutdown gets messy. In this tutorial, we’ll write the C codes to utilize Johan Hanssen Seferidis’s lightweight, production-friendly thread pool implementation in… Read More »The No-Frills Rocket: A Lean, Reliable C Thread Pool
Introduction Data is one of our most valuable assets — and one of the most vulnerable. From personal details to business information, protecting it is critical in today’s digital world. That’s why understanding the essential security principles of data isn’t… Read More »Essential Data Security Principles Everyone Should Know
Introduction If you’ve ever noticed a little padlock icon in your browser bar, that’s HTTPS at work — and behind it sits a world of encryption, certificates, and secure handshakes. While it sounds complex, the basics of SSL/TLS certificates can… Read More »SSL & HTTPS Made Simple – How Web Traffic Gets Secured
Introduction You may have heard Prometheus and Grafana mentioned together but have no idea exactly what they are. Don’t worry I was just like that. They are popular open-source tools often used together for monitoring and visualizing system and application performance. Prometheus… Read More »How to Deploy Prometheus and Grafana with Docker Compose
Introduction Time related problems may sound trivial at first but they could be quite tricky and complicated to get right in programming languages such as C or C++. Managing time involves understanding various functions, data structures, and conventions provided by… Read More »A Comprehensive Guide to Working with Time in C
working with strings in C is tricky and error prone, Learn how strings are represented in C and use the right utility to handle them properly
The Online Certificate Status Protocol (OCSP) serves to real-time validate the status of a certificate, offering a much better alternative to the Certificate Revocation List (CRL). OCSP Stapling, utilized in SSL/TLS protocols, involves the server proactively transmitting a recent OCSP response alongside its certificate during the handshake. This enables the client to verify the certificate’s status without direct communication with the OCSP responder
libjansson is one of the C libraries to work with JSON files. Learn how to use this library to parse and create JSON data
PostgreSQL is a robust open-source database management system, earning the distinction of DBMS of the Year 2023. Users choose PostgreSQL due to various reasons, such as SQL support, Query Optimization, and Reliability, etc. In this blog, I will guide you through the process of setting up a TLS connection between a PostgreSQL server and the psql client using self-signed certificates