This blog shows how to use value-based splitting to manually split tables into ranges with approxiimately-equal sizes when the data in a CockroachDB table is unevenly distributed. This is an advanced technique, because CockroachDB automatically manages ranges, so you usually don’t need to take manual control. Further, even when you want to take control, there… Continue reading CockroachDB Range Splitting Using ntile()
CockroachDB SQL Column Name Utility
Today I’ll share a simple “snippet” utility SQL query. You specify a table in your database and an alias for that table, and it generates several flavors of column-separated lists of column names for that table. This can come in handy when you are crafting SQL to join multiple tables that have the same column… Continue reading CockroachDB SQL Column Name Utility
CDC Sink Replication from PostgreSQL to CockroachDB
CDC Sink is a tool that enables logical data replication to CockroachDB, the SQL relational database with built-in high availability, horizontal scalability, multi-region geographic distribution, and fully-consistent transactional data. Data Sources CDC Sink works with a variety of data sources, including: This blog post focuses on using PostgreSQL as the source database. Use Cases One… Continue reading CDC Sink Replication from PostgreSQL to CockroachDB
CockroachDB Multi-Region Under-the-Hood
CockroachDB has always provided a SQL relational database with high availability, horizontal scalability, and multi-region geographic distribution, while delivering fully-consistent data and ACID transactions. In version 21.1, CockroachDB provided a new multi-region syntax to make these features easier to configure. This syntax is high-level, declarative and goal-oriented. But it raises the question, “What’s going on… Continue reading CockroachDB Multi-Region Under-the-Hood
What is Data Science?
You have undoubtably seen many articles on the web and in the popular press that explore the question “What is Data Science?” Data Science is hard to pin down, for several reasons: First of all, it is interdisciplinary. People have varying opinions about what activities or subject areas make up Data Science. Some even question whether Data Science has an identity… Continue reading What is Data Science?
Welcome!
Hi and welcome to DataSciGuy.com. My name is Steven Hand, and over the course of my career I’ve been a Sr. Software Developer, Database Team Lead, Data Scientist, Data Architect, and Enterprise Architect. I hope that together we can enjoy exploring the theory and practice of Data Science and other data and database-related topics. The… Continue reading Welcome!