Are database partition ranges inclusive on both ends?

I was recently reviewing a database partitioning definition in YugabyteDB (the postgres “ysql” API), and realized the partition distribution might not be what the developer intended. What is database partitioning? Let’s start with a little background. Database partitioning is used to divide large tables into smaller tables (partitions). While the data is physically separate,...

Read and Write Latency in a Global Database Cluster

Global and distributed applications often need to serve user requests from a single data source across different regions. While providing data scaling and protection against network outages, ensuring low-latency access to data is critical for providing a seamless user experience. YugabyteDB, a distributed SQL database, is designed to handle global data workloads efficiently. In...

Database transformation from SQL Server to YugabyteDB

A database transformation and migration project takes solid planning and testing. I’ve found that three common changes required when transforming a SQL Server database to YugabyteDB YSQL are related to syntax, performance, and stored procedures. These will get you started on your transformation project. Syntax Transforming a schema from MS SQL to YugabyteDB requires...

Belt and Suspenders

I’m writing this the night before we’re going to get some very bad weather. In North Carolina this time of year, that could mean an ice storm. Ice coats all the big and little branches on all the trees, and then they start to shatter onto roofs and overhead cables. I’ve lived all over...

Which Open-Source Database?

I’m an open-source database consultant. But which open-source database? Well, several of them. I made the decision several years ago to take every opportunity to work with multiple databases. Why? This was the kind of database consultant I intended to be — providing value to engineering teams by guiding them to the right system,...