Topic

Examples

Find some examples of Crate in the wild.

How we orchestrated a SQL database with Docker Swarm Mode

September 20, 2016

by

Claus Matzinger

Crate is a distributed SQL database and with its shared-nothing architecture, Crate is a perfect fit for setting up a container-based cluster for microservices. While there are many orchestration tools out there, Docker - with their latest update to Docker engine 1.12 - blended their applications nicely together and managing large clusters of containerized applications becomes a breeze!

Upgrade Your Cluster to 0.55.x

July 22, 2016

by

Claus Matzinger

Version 0.55 of Crate introduces a lot of great features, fixes and changes. Some of these required making changes to our code base that require extra steps to upgrade your clusters than with previous Crate versions.

Deep Analysis of Big Data with Crate and Zoomdata

July 21, 2016

by

Crate clusters are now a data source on Zoomdata, that allows for deep analysis and visualization of big data sets through a simple interface.

Optimizing Big Crate Clusters

March 3, 2016

by

Johannes Moser

Optimizing a big Crate cluster is a process. We show some options to get the best out of it.

Berlin and Geo Shapes in Crate

December 10, 2015

by

Claus Matzinger

In our last blogpost about Crate's spatial and geographic features we announced the support for the geo_point data type and related operations. Since that post, we have greatly improved our geographic features...

Crate, an easy to scale, real time SQL data store, secures funding from Sunstone and DFJ Esprit

April 24, 2014

by

Jodok Batlogg

Berlin/Austria-based Crate.IO, an open source data store for developers, secures a $ 1.5 m funding round. Crate.IO, an open source data store for developers, has...

How we chose the Facebook Presto SQL Parser for Crate

June 4, 2014

by

Bernd Dorn

Crate is an elastic SQL Data Store. We created it to provide a quick and powerful massively scalable backend for data intensive (or analytics) apps...

The Getting Started with Crate - Webinar

June 11, 2014

by

Jodok Batlogg

Check out the recording of our Introduction to Crate webinar...

Super Simple Real-Time Big Data Backend - July 8th Webinar

July 1, 2014

by

Jodok Batlogg

Presented by: Jodok Batlogg Duration: Approximately 60 minutes Cost: Free Hosted by: Ben Lorica Crate is a shared-nothing, fully searchable, document-oriented cluster data store. Today,...

Using Crate As a BLOB Store

July 2, 2014

by

Jodok Batlogg

Crate provides BLOB storage so you can persistently store and retrieve BLOB \u2013 typically pictures, videos or large unstructured files, providing a fully distributed cluster...

Using Crate With Rails

July 8, 2014

by

Jodok Batlogg

This is a re-post of Christoph Klocker's post \"Using Crate With Rails\". If you don\u2019t know Crate yet, Crate is a document-oriented cluster data store...

Crate for Pythonistas with SQLAlchemy

July 18, 2014

by

Philip Bogensberger

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

July 12, 2014

by

Christian Haudum

Crate is a simple to use database backend for many applications. Nowadays a huge percentage of data is geo-tagged already, no matter whether it comes...

Using Crate in a Multi Node Setup

July 22, 2014

by

Christian Haudum

UPDATE There is now a best practice in our documentation on how to Use Crate in a Multi Node Setup. Please check the documentation first,...

Using Crate And Node.js For Data Enrichment

August 5, 2014

by

Jodok Batlogg

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...

Test Driven Development of a Horizontally Scaling REST-Service with Pyramids, Crate and SQLAlchemy

August 11, 2014

by

Christian Haudum

This blog post is a recap of a tutorial held by Bernd Dorn at EuroPython2014. The resulting sample web application that is publicly available on...

How We Test Crate

September 2, 2014

by

Christian Haudum

Testing is an integral component of software development, especially when you develop a database that is used by developers to store millions of records. That...

A Dozen Intel NUCs in a Shoebox

September 11, 2014

by

Jodok Batlogg

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...

Crate with Docker & Weave

January 22, 2015

by

Jodok Batlogg

This is a guest post originally published on all about Weave on Jan 7, 2015. Crate is a massively scalable, distributed, and highly available database...

How To Use Nginx To Make Crate Read-Only

February 5, 2015

by

Christian Haudum

tl;dr ... There's a gist of the Nginx configuration. At the moment, Crate does not have a builtin concept of ACL or user permissions, but...

Deploying the Crate Distributed Database Using Mesos and Marathon

March 6, 2015

by

Christian Haudum

This is a guest post originally published on Mesosphere's Blog on Feb 25, 2015. Editor's Note: This guest post is written by Christian Haudum of...

Running and managing Crate databases with Mesos

May 13, 2015

by

Apache Mesos is a fantastic tool for abstracting CPU, memory, storage, and other compute resources away from machines (physical or virtual). This lets you program...

Running Crate on Linux and Windows with Azure

August 13, 2015

by

We have had requests from many of you about the potential of running Crate on Azure cloud hosting and/or Windows. Whilst this was always possible...

Backing up and Restoring Crate Databases

November 30, 2015

by

Our databases contain valuable and business critical information and whilst there have always been manual ways to create restorable backups of Crate databases, as of version 0.53, we are pleased to announce the 'Snapshots' feature.

Analyzing Germany's weather with Crate.IO

September 2, 2015

by

The german weather service, DWD, publishes a vast amount of data measured at german weather stations. The data is available in monthly, daily and hourly intervals from the beginning of recorded official measurements. Temperature, humidity, cloudiness, precipitation, air pressure, soil temperature, sunshine duration, radiation, wind speed and direction and sun zenith are measured. I decided I would write a blog post about my experiments importing their 236 million rows of data into Crate.