I periodically need to make changes to tables… mostly adding columns. Very simple with the alter table command… But my tables have up to 40 million rows now and they are growing fast… So those alter table commands take several…
We have added a new feature: time-travel queries. To our knowledge, we are the first database to have implemented the them.
Adopting SQL had an unexpected consequence; it forced us to dabble in language design. In this post, we detail our approach to SQL typing in CockroachDB.
CockroachDB's support for SQL means access to a variety of data frameworks and tools. Today, we'll build a simple application in Python using SQLAlchemy...
CockroachDB contributor Paul Steffensen (aka uptimeDBA) has analyzed CockroachDB's handling of NULL values as compared to other SQL implementations.
CockroachDB is pretty easy to deploy. However, there is still one wrinkle in the fabric, and that's our use of network ports.
In this post, we will go over some of the factors involved in choosing the best index to use for running a certain query.
We introduced Cockroach Labs last June with a simple yet ambitious mission: Make Data Easy. We are now thrilled to launch CockroachDB beta.
SQL grammar diagrams feature easy-to-understand railroad diagrams showing possible options for a SQL statement. Compared to a text representation...
For CockroachDB, the aim is to be highly scalable and transactional. We asked them to share technical details of their open source, distributed SQL database