Category Database

Database, Development, go, SystemArchitect

Understanding Database Locking in an Airline Seat Booking System

In this blog, we explore database locking mechanisms in an airline seat booking system using Go and PostgreSQL/YugabyteDB. Learn how to handle concurrent transactions with various locking strategies for data consistency.

uday.chauhan
August 15, 2024

Connection Pooling, Database, Development, Docker, go, SystemArchitect

Boosting Database Performance with Connection Pooling

Learn how to significantly enhance your application's performance by implementing connection pooling in Go. Explore best practices, detailed code snippets, and real-world benchmarks using YugabyteDB to efficiently manage database interactions and ensure your application scales smoothly under heavy load.

uday.chauhan
August 12, 2024

Database, Developer, Development

Optimizing DBeaver for Better Performance and Usability

Optimize DBeaver for better performance and usability with these expert tips. Learn how to tune memory settings, enhance the user interface, enable autosave, and configure SQL formatting for a smoother experience.

uday.chauhan
May 26, 2024

Database, Development

Managing Long-Running Jobs in Spring Batch: Troubleshooting Connection Issues

Dealing with long-running jobs in Spring Batch can be tricky, especially when it comes to managing database connections and transactions. In our latest post on Developer’s Coffee, we dive into a real-world issue we faced with a Spring Batch job that timed out due to connection limits. Discover how we tackled the problem by tweaking HikariCP settings and adjusting load balancer timeouts to ensure smooth and reliable batch processing. Read on to learn more about our solutions and how you can apply them to your projects.

uday.chauhan
May 16, 2024

Database, Development

TEXT vs. VARCHAR in PostgreSQL: A Closer Look with Examples

"TEXT vs VARCHAR: Which to use when?"

uday.chauhan
December 24, 2023

Database

Consistency Models in System Design: A Deep Dive

Introduction Consistency models serve as the backbone of any distributed system, laying down the rules for how data is read and written across multiple nodes. Choosing the right model is critical because it influences the system’s performance, reliability, and user…

uday.chauhan
September 4, 2023

BuildTools, Database, Development, DevOps, Flyway

Managing YugaByte Database Migrations with Flyway on Yugabyte | Flyway Logging and Debugging Tips

Learn about Flyway logging options and debugging techniques to troubleshoot issues and gain insights into the migration process in Yugabyte.

uday.chauhan
May 1, 2023

Database, Development, DevOps, Flyway, Java

Efficient Database Migration with Flyway and Yugabyte: A Comprehensive Guide to CLI Commands

Discover how Flyway and Yugabyte can make database schema changes easier with a comprehensive guide to CLI commands for seamless migrations.

uday.chauhan
April 7, 2023

Database, Development, DevOps, Sharding

Maximising PostgreSQL Efficiency in Yugabyte: Best Practices for Distributed Databases

Optimising PostgreSQL performance in distributed SQL environments can be a complex and challenging task, especially when using a platform like Yugabyte

uday.chauhan
February 20, 2023
2 Comments

Database, Development, DevOps, Sharding

Sharding in YugabyteDB: Understanding Hash and Range Partitioning

This post provides a detailed comparison of the two sharding methods and provides examples of when to use each one, along with SQL examples. It also explains the underlying hardware and DocDB considerations while using sharding in YugabyteDB.

uday.chauhan
January 22, 2023
1 Comment