Welcome to techbuddies.io, a realm where data becomes your most potent asset. Dive into our tech blog, where we unravel the mysteries of PostgreSQL, the open-source database management system that’s revolutionizing the way we handle data. In conjunction with cybersecurity, networking and even fundamental C programming that formed the innovations that we live by today.
Whether you’re a DBA, a developer, or simply fascinated by the world of databases and technology, we’ve got insights, tips, and tricks that will elevate your data game to the next level.
Popular PostgreSQL Posts
Understanding Incremental Data Backup in pg_rman
Previously, we discussed how to perform a simple backup using pg_rman. As pg_rman can back up PostgreSQL at the physical file copy level, it is quite useful for daily database maintenance. Particularl…
Read More
Restore PostgreSQL with pg_rman
We discussed a topic on how to create simple backups using pg_rman. In this blog post, we will demonstrate how to restore PostgreSQL using a backup generated by pg_rman. In continuation of the previou…
Read More
A simple way to backup PostgreSQL with pg_rman
Introduction PostgreSQL, a powerful open-source relational database, is known for its robustness and extensibility. One critical aspect of database management is ensuring reliable backup and recovery …
Read More
Unlock Your Arsenals: GDB Debugging Essentials with PostgreSQL
GDB is a powerful tool for any seasoned C developer. Explore the essentials of GDB debugging with PostgreSQL database as practical examples
Read More
Explore Practical PostgreSQL Substring Use Cases with Examples
Explore the versatility of PostgreSQL substring function and learn how it can help with your string manipulation tasks.
Read More
All PostgreSQL Replication Explained – How to Do Them Right.
Dive into the principles of PostgreSQL streaming replication and logical replication. Learn how to set them up properly
Read More
Achieve ISNULL Function in PostgreSQL 16 with Right Examples
Explore the alternatives to achieve ISNULL PostgreSQL example. Learn to create your own ISNULL function in PostgreSQL 16
Read MoreLearn C Programming
C is the most desirable programming language for embedded systems, firmware, drivers, operating systems and database software (like PostgreSQL). In your software development career path, It is quite likely that you will come across some of these categories of development. This is why the C language is very important because it is literally every where! Check out these C programming related posts to sharpen your C skills!
Working with the Infamous Strings in C Made Easy
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
Read More
Easy JSON Parsing with libjansson Tutorial in C
libjansson is one of the C libraries to work with JSON files. Learn how to use this library to parse and create JSON data
Read More
Easy Config File Management with libconfig Tutorial in C
Libconfig is a easy to use C library to manage configuration files for C applications. Learn the basics to intermedia use cases with examples
Read More
5 Deadly Mistakes to Avoid in C Programming
Explore 5 simple but deadly mistakes in your C programming journey that you could avoid to save time from tedious debugging efforts
Read More
A Deeper Look at Computer Memory
Do you really know about computer memory? As a C programmer, knowing the fundamental of memory is vital to building reliable applications
Read More
Explore the Role of the Static Keyword in C
the static keyword in C plays a very important role in the scope of a function or variable, learn how to create custom behaviors with static
Read MoreExternal Posts
These are the most popular posts published externally. Mostly on PostgreSQL internals and security topics. Check them out!
Modernize PostgreSQL Certificate Revocation List with OCSP Stapling
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, util…
Read More
A Guide to Set up TLS Security in PostgreSQL
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…
Read More
PostgreSQL Query Processing – A Comprehensive Overview
PostgreSQL performs several stages of processing to turn a query into results in shortest amount of time. Learn the sophisticated internal processing of PostgreSQL as a database developer
Read More