In this post, we will go through real-world performance optimizations introduced to the Wazuh server 4.13.0 version, achieving significant reductions in time and resources consumption up to 95%!

We will explore different techniques such as connection pooling, caching, SQL query improvements, …

This is the part 2 of a series covering sql and Go, this time, we will cover how to work with SQL transactions context and isolation levels, results dynamic scanning, full text search and recursive queries as well as using multiple result sets to do many queries in a single roundtrip.

To go to part …

I found myself using SQL a lot in one of my projects and I have learnt many things while trying to solve the problems I encountered.

This post is the part one of a series where I will try to show how to manage data in a relational database using SQL (Postgre syntax), Go and its standard library …