June 2017 Summaries

Since initially publishing their post in 2017, Cockroach Labs has completed full support for Active Record and now fully supports Common Table Expressions. The company aims to make CockroachDB a user-friendly, scalable, and robust SQL database, which led them to provide support for popular ORMs like ActiveRecord, the ORM behind Ruby on Rails. While initially facing challenges due to the PostgreSQL wire protocol, the company adopted a hybrid approach by creating a lightweight ActiveRecord adapter gem, which extends from the existing Postgres adapter to modify unsupported features such as Common Table Expressions. This gem allows Rails users to utilize CockroachDB as their backend database with minimal configuration changes, and Cockroach Labs encourages developers to provide feedback to further improve the integration.

CockroachDB offers two main modes for executing SQL queries: local and distributed. The local execution engine processes queries primarily on the node that receives them, operating sequentially but allowing for parallelized local processing of multiple data updates through SQL syntax extensions like RETURNING NOTHING. This approach is simple and trusted by developers for its correctness and speed when data is locally available. The distributed execution engine, on the other hand, delegates parts of a query to multiple nodes in the cluster, aiming to leverage proximity to data to expedite processing and reduce network traffic. This engine is designed to simplify development by providing a general-purpose distributed computing solution that removes the complexity of managing performance and consistency across multiple systems. While the distributed engine currently enhances SQL query performance for tasks such as filtering, joins, and aggregations, CockroachDB plans to expand its functionality further, supported by ongoing work on theoretical challenges related to distributed processing. Both execution modes can operate simultaneously, with distributed execution being the default for eligible queries, encouraging users to explore its benefits.

CockroachDB's 1.0 release marks its transition to a production-ready, cloud-native database, designed to address the limitations of traditional databases in handling distributed OLTP workloads. By combining the strong consistency of SQL with the scalability of NoSQL, CockroachDB allows businesses to scale their databases across multiple datacenters without substantial application changes. Core features such as distributed SQL, multi-active availability, and consensus-based replication enhance stability, performance, and usability, while supporting mission-critical applications. Although CockroachDB 1.0 does not yet support all PostgreSQL functionalities and faces network latency challenges, it is optimized for transactional workloads and offers robust community support. As Cockroach Labs continues to develop CockroachDB, they aim to expand its capabilities, improve query performance, and integrate with more deployment tools, driven by feedback from its users.