Hello All, We're happy to announce the release of v1.17 of pgmetrics. Changes since the v1.16 release include: Support for PostgreSQL v17 beta 2. Support for PgBouncer up to v1.23.0. Support for Pgpool up to v4.5.2. Include full log entries in JSON output. Support libpq key-value style connection strings. Updated…
Welcome to the Tech Olympics, where code meets competition! With the 2024 Summer Olympics starting today, we thought it’d be fun to imagine developers as athletes, showcasing their skills in a series of thrilling events. From relay races to coding challenges, the Tech Olympics would bring together the brightest minds…
Vertical Scaling Benefits and Challenges Thinking about how to make your IT infrastructure more efficient? You might be wondering whether vertical scaling is the right approach for you. Let’s break down what vertical scaling is and how it can benefit your setup. Vertical scaling, also known as scaling up, involves…
Text Size 100%: － ＋ Oracle recently published a new container image for running Oracle REST Data Service (ORDS). The new image externalises the ords binary, therefore greatly simplifying the process of making changes to the configuration. How does this change the way you work with the ords image? Let's…
Graphs and Networks for Beginners You’ve probably heard about graphs and networks in various contexts, from social media to transportation systems. Understanding these concepts can help you make sense of complex relationships and structures. Graphs and networks are more than just abstract ideas; they have practical applications in many fields.…
Challenges in Managing Many-to-Many Relationships in SQL Managing many-to-many relationships in SQL can feel like a puzzle, especially if you’re just diving into the world of database design. But don’t worry, you’re not alone in wondering how these relationships fit into your project. Let’s break it down together. When you’re…
AI can lead to major enterprise advancements and productivity gains. By offering new capabilities, they open up opportunities for enhancing customer engagement, content creation, process automation, and more. According to McKinsey & Company, generative Al has the potential to deliver an additional $200-340B in value for the banking industry. One…
What is Graph Traversal and Its Algorithms You’ve probably heard the term “graph traversal” thrown around in computer science discussions. It might sound complex, but it’s a fundamental concept that’s worth understanding. Whether you’re a developer or just curious about how algorithms work, grasping graph traversal can open up a…
Shard Key Basics Explained A shard key is a field or combination of fields that determines the distribution of data across shards in a sharded database cluster. It acts as a guide for the database to partition data, ensuring even distribution for optimal performance and scalability. By using a shard…
Horizontal Partitioning vs Vertical Partitioning You’re dealing with a database that’s growing faster than you expected. Queries are taking longer, and you’re starting to worry about performance issues. We get it—slow queries can be a nightmare, especially when you’re responsible for keeping everything running smoothly. You’ve heard about partitioning as…