Bulk Inserts with unnest
CrateDB 0.55 introduces support for unnesting. Unnest uses arrays to generate a transient table with each array representing a column.
Blog
Optimizing Big Crate Clusters
Helpful hints on how to optimize your setup when ingesting a massive amount of data into CrateDB.
Backing up and Restoring Crate Databases
Snapshots create incremental backups of entire databases, specific tables or partitions. Restore them through the Crate command line interface.
Running and managing Crate databases with Mesos
How to get started running and managing CrateDB databases with Mesos.
Deploying the Crate Distributed Database Using Mesos and Marathon
Using Mesosphere Marathon to manage CrateDB containers makes it easy to deploy a containerized database cluster and allocate database resources quickly
How To Use Nginx To Make Crate Read-Only
Creating read-only access to a CrateDB cluster using Nginx and a few lines of Lua code.
A Dozen Intel NUCs in a Shoebox
This summer we've built a portable datacenter to demo Crate on commodity hardware. A lot of people are asking us how we did it, what the specs of the cluster are, ... time to write a blogpost!
Using Crate And Node.js For Data Enrichment
Great post by Stefan Thies about how he used Crate and Node.js to overlay the raw data from website log files with whois information, enabling him to "name" visitors to a site.
Crate for Pythonistas with SQLAlchemy
In this tutorial I want you to show how to interact with Crate using SQLAlchemy. SQLAlchemy is a Python SQL toolkit and Object Relational Mapper.
Geospatial Queries with Crate
Crate provides a specific data type for scenarios where it is necessary to track and analyse geo coordinates.