March 2020 Summaries

Cockroach Labs' decision to use the Go programming language for their complex application since 2015 has led to several discussions and presentations about its benefits, and they now support GORM, a developer-friendly ORM library that simplifies interactions with relational databases like CockroachDB. This support allows Go developers to harness the power of SQL while managing database operations efficiently. As Golang continues to gain popularity, being foundational to major open source projects such as Kubernetes and Docker, the company provides resources like tutorials and live streams to help newcomers learn the language. Dan Kelly, a content creator at Cockroach Labs, has been instrumental in producing educational materials to address developers' challenges, while also engaging in personal interests like spending time with his daughter and cooking.

The blog post by Aayush Shah outlines the implementation of hash sharded indexes in CockroachDB to enhance performance for sequential workloads. Traditionally, CockroachDB uses range partitioning, which struggles with sequential data access patterns, leading to load imbalances and single range hotspots. Hash sharded indexes, however, distribute incoming traffic more evenly across ranges, facilitating linear scaling as cluster size increases. This alleviates performance bottlenecks by spreading the load uniformly across nodes, as demonstrated through benchmarking comparisons between unsharded and sharded schemas. The new syntax introduced in CockroachDB version 20.1 simplifies the process of creating hash sharded indexes, improving usability and performance by automatically managing shard columns and constraints. Shah also reflects on his educational internship experience at Cockroach Labs, highlighting the collaborative environment and opportunities to tackle complex distributed database challenges.

The 2020 Cloud Report conducted by Cockroach Labs benchmarked the performance of Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP) using default configurations to avoid bias, which sparked significant feedback from both cloud providers and customers. AWS, Azure, and GCP responded with suggestions for optimizing performance and expressed interest in continued collaboration for future reports. AWS recommended testing new machine types for improved performance, while Azure highlighted the need for careful configuration due to its numerous options and provided insights into VM scaling and network configurations. GCP emphasized the importance of staying updated on processor types and shared improvements in network performance. The report noted the complexities of tuning cloud configurations, such as VM machine types and network settings, and emphasized the importance of ongoing benchmarking to aid users in configuring their cloud environments effectively. The insights gathered will inform revisions to the testing suite for the 2021 Cloud Report, aiming to provide a more comprehensive analysis of online transaction processing (OLTP) workloads across these major cloud platforms.

In response to the COVID-19 pandemic's disruption of in-person events, the Cockroach Labs marketing team adapted their successful "contacts for charity" initiative by creating a "virtual badge scan" program to continue supporting Women Who Code. Initially, the team had planned to expand their program, which involved donating funds to the non-profit in exchange for lead contacts at events, but faced challenges when conferences like Kubecon EU and Google Cloud Next were canceled. The innovative virtual badge scan allows individuals to provide their email addresses at virtual events, with each validated submission resulting in a $3 donation to Women Who Code, maintaining their charitable efforts amid the shift to virtual gatherings.

The tutorial provides a comprehensive guide on building an application using SpringBoot, Java, Hibernate, Gradle, and CockroachDB, emphasizing the ease of integrating CockroachDB due to its compatibility with PostgreSQL. It walks through the process of setting up a SpringBoot project, configuring the necessary dependencies, and establishing a database connection using a JDBC driver. Key steps include creating a Flyway migration file to define database tables, setting up entities, controllers, repositories, and services for managing data, and running the application to interact with the database. The tutorial highlights the simplicity of transitioning from PostgreSQL to CockroachDB, particularly for developers familiar with Postgres, and concludes with practical examples of querying and inserting data using RESTful services.