CrateDB DevRel here :) > databases providing an abstraction through the Postgres wire protocol I would not call it an abstraction, if one has a full parser, analyzer, planner and execution engine. It is just a common…
Not being able to keep up with the incoming data. But 100-200Hz I'd consider fine for most
What do yo mean by high-frequency data? 100Hz, 1KHz, 100KHz? For that kind of use cases many time-series DBs break apart. We have customers storing multiple millions of high frequency measurements per sec in arrays. I…
Most of CrateDB clusters run on cloud providers hardware (azure, aws, alibaba). Using EBS (GP2 or now GP3) is also quite common. Due to the indexing / storage engine, gp disks are typically sufficient and faster disks…
- Depends - Just inserting, indexing, storing and simple querying can be done with little memory (i.e. 1:500 memory-disk-ratio 0.5GB RAM per 1TB disk). Typical production clusters with high query load are in the 1:150…
> is an OLAP database a common go-to for longer-timescale analytics (as in [1])? I would not consider Clickhouse or CrateDB "classic" OLAP DBs. I can speak for CrateDB (I work there), that it definitely would be able to…
That article takes various concepts from typical TSDB solutions and seemingly only looks at the bad sides. Time series data has many different forms, not every form works for every TSDB solution. For the 3 caveats at…
Sorry, but this is not true at all. Some of the biggest changes within ES come from Lucene, like _massive_ reduction in memory footprint, enabling ES to use cases not even possible before.
If you are looking an OSS ES replacement, CrateDB might also be worth a look :) Basically a best of both worlds combination of ES and PostgreSQL, perfect for time-series and log analytics.
Yes, we have customers using CrateDB as part of their proprietary product. Also the SSPL is so vague, that we probably would not only have to release CrateDB itself - which we already do, but also everything we use for…
The thing is, that all the arguments they now bring up for the move, have been true in 2018 as well ...
> This begs the question: isn't "a restrictive OSS licence" not less "fully open source" than a more permissive licence like GPL, MIT or BSD? We gonna change CrateDB fully to Apache License v2 ;) I would say that counts…
> If your business model cannot survive when a critical upstream piece of your infrastructure moves to GPL, you probably have a bad business model to begin with. To be clear CrateDB started out as OSS and we decide to…
Fair point - I will review this with our marketing and get that fixed
Many reasons actually ... - Scalability CrateDB is built for horizontal scale from the ground up on top of distributed technologies. We have customers using clusters with 80+ nodes in production for many years now.…
CrateDB DevRel here :) > databases providing an abstraction through the Postgres wire protocol I would not call it an abstraction, if one has a full parser, analyzer, planner and execution engine. It is just a common…
Not being able to keep up with the incoming data. But 100-200Hz I'd consider fine for most
What do yo mean by high-frequency data? 100Hz, 1KHz, 100KHz? For that kind of use cases many time-series DBs break apart. We have customers storing multiple millions of high frequency measurements per sec in arrays. I…
Most of CrateDB clusters run on cloud providers hardware (azure, aws, alibaba). Using EBS (GP2 or now GP3) is also quite common. Due to the indexing / storage engine, gp disks are typically sufficient and faster disks…
- Depends - Just inserting, indexing, storing and simple querying can be done with little memory (i.e. 1:500 memory-disk-ratio 0.5GB RAM per 1TB disk). Typical production clusters with high query load are in the 1:150…
> is an OLAP database a common go-to for longer-timescale analytics (as in [1])? I would not consider Clickhouse or CrateDB "classic" OLAP DBs. I can speak for CrateDB (I work there), that it definitely would be able to…
That article takes various concepts from typical TSDB solutions and seemingly only looks at the bad sides. Time series data has many different forms, not every form works for every TSDB solution. For the 3 caveats at…
Sorry, but this is not true at all. Some of the biggest changes within ES come from Lucene, like _massive_ reduction in memory footprint, enabling ES to use cases not even possible before.
If you are looking an OSS ES replacement, CrateDB might also be worth a look :) Basically a best of both worlds combination of ES and PostgreSQL, perfect for time-series and log analytics.
Yes, we have customers using CrateDB as part of their proprietary product. Also the SSPL is so vague, that we probably would not only have to release CrateDB itself - which we already do, but also everything we use for…
The thing is, that all the arguments they now bring up for the move, have been true in 2018 as well ...
> This begs the question: isn't "a restrictive OSS licence" not less "fully open source" than a more permissive licence like GPL, MIT or BSD? We gonna change CrateDB fully to Apache License v2 ;) I would say that counts…
> If your business model cannot survive when a critical upstream piece of your infrastructure moves to GPL, you probably have a bad business model to begin with. To be clear CrateDB started out as OSS and we decide to…
Fair point - I will review this with our marketing and get that fixed
Many reasons actually ... - Scalability CrateDB is built for horizontal scale from the ground up on top of distributed technologies. We have customers using clusters with 80+ nodes in production for many years now.…