CockroachDB Strengthens Change Data Capture
Written by Kay Ewbank   
Monday, 24 January 2022

CockroachDB has been updated with improvements including stronger support for distributed Change Data Capture (CDC), new SQL syntax support and better monitoring of query performance.

CockroachDB is a distributed SQL database that is cloud native and offers horizontal scalability with no single points of failure.

cockroachdb

The distributed Change Data Capture (CDC) makes it easier to Integrate with event-driven data architectures, and the new release means developers can stream data updates to any https endpoint using a new webhook-style sink. This has been added in addition to the existing integrations with Kafka and cloud storage. The new release offers higher throughput and improvements for large table sizes, making it possible to increase the scale of the CDC capacity, and there's easier troubleshooting for CDC.

The updated version also has new SQL syntax including ON UPDATE and expression indexes. The monitoring UI makes additional query performance data available, including index usage statistics, and there's an update that lets SQL transactions and statements data persist for multiple days. The On Update improvements will automatically update a column every time a row is updated, removing the need to implement this logic at the application layer. Expression indexes apply expressions to entire columns and create an index on these expressions.

The improved monitoring aims to help users retrieve query stats and diagnose issues straight from the SQL CLI through new metrics and internal tables, including query contention information and more table views. The index stats give you visibility into whether or not an index is being used, so you can drop unused indexes for optimal performance.

Another major area of improvement is new support for Alembic, a schema migration tool for Python developers, and Sequelize, a Node.js ORM. CockroachDB already supported for popular ORMs and drivers for Javascript/Typescript, Python, Go, Java, Ruby, C, and C++.

CockroachDB 21.2 is available now.

cockroachdb

More Information

Cockroachlabs

Related Articles

CockroachDB 20.2 Adds PostGIS Spatial Data Support

CockroachDB 20.1 Improves App Development

Cockroach Creates Pebble

CockroachCloud Enters Beta

CockroachDB Adds GDPR Compliance

CockroachDB Production Ready

CockroachDB Released

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.

Banner


IEEE Spectrum Ranks Languages
02/09/2022

IEEE Spectrum has repeated its annual exercise to rank programming languages in terms of their popularity and once again it is Python that emerges as the front runner in its rankings. However, Python  [ ... ]



The Bamboo Garden Trimming Problem - Fun CS Theory
18/09/2022

Today is World Bamboo Day which, since 2009, is observed on September 18 in order to raise awareness about the conservation of this extremely useful plant. It reminded me of an algoritrhmic puzzl [ ... ]


More News

pythondata

 



 

Comments




or email your comment to: comments@i-programmer.info