April 2020 Summaries

In "On Optimism and Team Engagement in the time of COVID," Evan Atkinson, Culture and Workplace Associate at Cockroach Labs, explores how the organization has adapted to remote work during the pandemic by fostering a sense of community and engagement among employees. Atkinson likens himself to a character in an apocalyptic film, humorously portraying his efforts to maintain optimism and connection within the team. Through creative initiatives such as virtual house tours, "Spinning-Up" social calls, and "Tea Times," Atkinson has integrated fun and interaction into the workweek, transforming traditional in-office activities into virtual formats. These efforts have helped sustain Cockroach Labs' culture and support employees' mental well-being, emphasizing the importance of maintaining human connection and levity amidst the challenges of remote work and global uncertainty.

The blog post by Piyush Singh discusses optimizing application performance for SQL databases through the use of the "duplicate indexes" topology pattern in CockroachDB. The focus is on improving read performance, especially in scenarios where data such as zip codes or user authentication details require frequent access and read speed is prioritized over write speed. By creating secondary indexes in multiple geographic regions, this pattern ensures that reads are handled by local data centers, minimizing latency and enhancing user experience, even if users migrate between regions. The trade-off is a decrease in write performance due to increased data replication, though the write latency remains within an acceptable range. This approach ultimately leads to near-instantaneous read experiences, making it ideal for applications where fast data retrieval is crucial.

In response to the challenges posed by the COVID-19 pandemic, Cockroach Labs has committed to supporting its community by enhancing customer service and offering resources to manage increased demand and reduced headcount. The company has increased staffing in its Slack channel for CockroachDB Core users and upgraded all CockroachDB Dedicated accounts to 24/7 support for managed service customers. Additionally, they are providing free instances of CockroachDB Dedicated to new users for a limited time to help with application scaling. Spencer Kimball, CEO and Co-Founder, emphasizes the company's willingness to assist customers during these uncertain times and encourages them to reach out for further support.

Eric Harmeling's tutorial addresses the challenge of reducing latency in global applications by detailing the deployment of a low-latency, multi-region Flask app for MovR, a fictional vehicle-sharing company. The app, designed to serve a global customer base, leverages CockroachDB's multi-region capabilities and geo-partitioned replicas to minimize latency, utilizing Google Cloud's Kubernetes Engine for deployment across the US and Europe. By strategically deploying both the application and its database, the tutorial demonstrates significant latency reduction—from 150ms in a single-region setup to under 2.5ms in a multi-region configuration—highlighting the importance of proximity in data requests. The detailed implementation includes Python class definitions, SQLAlchemy transactions, and a backend API, with the full codebase available on GitHub for readers to explore through an end-to-end tutorial.