SQLite Deep Dive

by

Overview This blog post is a summary of the following talk on YouTube, credits to the presenter. What is SQLite? SQLite is a widely used, serverless, and self-contained database engine known for its simplicity, speed, and reliability. Its key features contribute to its popularity and versatility across various applications. Ease of Use and Deployment Performance … Read more

Pattern Matching In Java

by

Overview Pattern matching is one of the most powerful features introduced in the recent versions of java. It helps us remove the redundant type casting. In this post, I will cover the key aspects of pattern matching with examples. Let’s get started. What is pattern matching? When talking about pattern matching in java, the first … Read more

Tuning Tips to Maximize Postgres Performance

by

Overview This blog post summarizes key insights from a webinar, “Tuning Tips to Maximize Postgres Performance,” hosted by EDB. The webinar, featuring Dave Page, VP and Chief Architect of Database Infrastructure, and Devrim Gundus, an EDB consultant, offers a deep dive into optimizing Postgres performance, from hardware considerations to query tuning techniques. If you prefer … Read more

How to Enable Spring Data MongoDB Auto Index Creation

by

Overview If you have tried setting auto-index-creation in spring data mongodb without success, like this: Then this post will show you how to work around this. Let’s get started. Enable auto index creation in MongoDB First, let’s consider this document Here, I defined an unique index for my document named rate_limit_config_service_name but when the application … Read more