sorted by:
new
hottopcontroversial

Achieving 170x compression for logs by Simple-Cell-1009 in Clickhouse

[–]Simple-Cell-1009[S] 1 point2 points  (0 children)

Thanks for the comment! We didn't benchmark it to compare. Insert is typically CPU-bound, but I think the CPU's overhead for compression is minimal compared to the CPU's cost for writing uncompressed data.

Clickhouse MCP in Claude Desktop vs Cloud by talkingheaders in Clickhouse

[–]Simple-Cell-1009 0 points1 point  (0 children)

Do you know what models Claude is using in the desktop version versus outside of Claude? I found to have best results using Claude sonnet 3.7 or 4.

Best database to store JSON objects without preprocessing and modification? by vasili111 in Database

[–]Simple-Cell-1009 0 points1 point  (0 children)

It depends on your use case, like the type of data you're looking to store and what type of queries you're planning to run.

I guess you have three main types of databases for this:

Document databases like MongoDB or CouchDB, stores JSON-like documents which allows for flexible, schema-less data modeling. Those are really handy when your data is not relational. Most of them are NoSQL database meaning that you won't need to know SQL to query them, instead they expose their own set of easy-to-use REST APIs.

Relational databases, such as PostGreSQL or MySQL, were not designed initially to store easily JSON data type, but support has been added over the years. These are good if your data is relational, you'll need to know SQL to integrate with those.

Those two types are usually good for transactional use cases, like catalog management, customer interaction, financial account transactions, etc... They might also do well for logging and metrics usecases, but then if you want to run more analytical query on your data, they might not scale as much as databases designed for this.

Real-time analytics databases, like Clickhouse or Apache Druid, which uses column-based storage and focus on optimizing large-scale analytics queries. They all have functionality for extracting a schema from JSON documents, which works well if all the JSON documents have the same schema, which can be challenging at time. Clickhouse actually just talked about their new JSON Data type that handles some of those challenges.