Thom O'Connor · @thomoco
208 followers · 1150 posts · Server mas.to

Detailed, reproducible, and relatively objective analysis in a blog comparing performance, compression, and costs between Cloud and

clickhouse.com/blog/clickhouse

Summary:
* ClickHouse Cloud is 3-5x more cost-effective than Snowflake in production
* ClickHouse Cloud querying speeds are over 2x faster compared to Snowflake
* ClickHouse Cloud results in 38% better data compression than Snowflake

#snowflake #clickhouse

Last updated 1 year ago

Francesco Tisiot · @ftisiot
308 followers · 141 posts · Server hachyderm.io

directly in the database!

With you can train a ML model (stochasticLinearRegression or stochasticLogisticRegression) and then use it to perform predictions!

The flow below also uses the s3 function to read the data from a bucket

Check it out with Aiven for ClickHouse

#machinelearning #clickhouse

Last updated 1 year ago

Su-Shee · @sushee
763 followers · 683 posts · Server fosstodon.org

cool cool can't sleep since 4am because this is the OPTIMAL hour to have awesome tech ideas (or hate your life/job/relationship/neighbors/yourself of course) either way really good time to think of fundamental shit like "should I use or oh I know I use both!1!! can't have enough databases!!"

#sqlite #clickhouse

Last updated 1 year ago

Francesco Tisiot · @ftisiot
306 followers · 135 posts · Server hachyderm.io

Directly reading from and writing to AWS S3 buckets: faster time to analytics with !

We just enabled it on Aiven for ClickHouse, check the doc
docs.aiven.io/docs/products/cl

#clickhouse

Last updated 1 year ago

Su-Shee · @sushee
762 followers · 663 posts · Server fosstodon.org

I think for the smaller and mid-sized "signoz" is looking good. it's a frontend bringing logs, traces, metrics together, stored in (which I can really recommend, I'm quite happy with it - but not yet arrived at petabyte level, can't attest to bigger setups yet)

#observability #clickhouse

Last updated 1 year ago

ClickHouse CI · @ClickHouseCI
24 followers · 265 posts · Server hostux.social

Have I shown our statistics available with public play.clickhouse.com instance?

pastila.nl/?01d5d14e/b4555c6cb

It's impossible to achieve with given GH UI, so it's implemented with a simple set of tools clickhouse.com/blog/monitor-gi

#github #actions #clickhouse

Last updated 1 year ago

Thom O'Connor · @thomoco
207 followers · 1149 posts · Server mas.to

@akahn nice job! it might be interesting to note that cascaded (or chained) Materialized Views do work, and in fact are updated together with the original source table:

clickhouse.com/docs/en/guides/

clickhouse.com/docs/knowledgeb

recursive Materialized Views are probably another matter though :)

#clickhouse

Last updated 1 year ago

Julio Jimenez · @julioj
202 followers · 2058 posts · Server fosstodon.org

Here’s an idea for a new web stack, CHL. and a . I’d pronounce it CHilL🍹

#clickhouse #htmx #lisp

Last updated 1 year ago

Thom O'Connor · @thomoco
207 followers · 1149 posts · Server mas.to

Another round of ClickHouse Fundamentals free virtual instructor-led (live) training this week August 16 & 17 at 1 PM BST / 2 PM CEST / 5 AM US Pacific each day for 3 hours

Free enrollment here:
clickhouse.com/company/events/

This course applies to both or users with lecture and hands-on labs - come join us and learn!

#cloud #opensource #clickhouse

Last updated 1 year ago

@julioj @Perl Thanks Julio. Looking at various 2D solutions to utilize and is definitely among those considered for a SQL form of solution (bonus there is a R interface - many analytics stuff are written in R).
Will take a look!

#clickhouse

Last updated 1 year ago

Julio Jimenez · @julioj
202 followers · 2058 posts · Server fosstodon.org

@ChristosArgyrop @Perl Hey Christos, I’m partial to as you can see from my bio. In my security work I use it for network traffic metrics and observability. I mainly use JavaScript, Python, and Common Lisp to interact with ClickHouse. For R there’s github.com/IMSMWU/RClickHouse

Also, feel free to join our Slack where you can ask any and all questions from our community of users clickhousedb.slack.com

clickhouse.com/docs/en/intro

#clickhouse

Last updated 1 year ago

Thom O'Connor · @thomoco
203 followers · 1141 posts · Server mas.to
Julio Jimenez · @julioj
193 followers · 1950 posts · Server fosstodon.org

With ClickPipes, joins the Connect with
@confluentinc partner program!

Real-time data streams available directly within ClickHouse Cloud!

Hear about our integration with Confluent →

youtu.be/rSUHqyqdRuk

#clickhouse #olap #db #data #database

Last updated 1 year ago

Thom O'Connor · @thomoco
197 followers · 1126 posts · Server mas.to

Learn everything you need to get started with or in this 2-day course “ClickHouse Fundamentals”

Join us on July 11 & 12 for 2 days (3 hrs daily at 8am US Pacific / 17:00 CEST) of virtual instructor-led courses with hands-on labs

Enroll here:
clickhouse.com/company/events/

#training #free #cloud #opensource #clickhouse

Last updated 1 year ago

ClickHouse CI · @ClickHouseCI
20 followers · 230 posts · Server hostux.social

Due to recent overflow, we are sorry to limit number of PRs per day in the

Core engineers: 5
Contributors: 3
New contributors: 1

We plan to address it eventually!

#clickhouse

Last updated 1 year ago

Thom O'Connor · @thomoco
197 followers · 1126 posts · Server mas.to

@akahn I think I understand - it sounds like you have "semi-structured" data. Using a Nested data type with arbitrary key:value pairs might work for you. stores Nested data types as Arrays that can be of arbitrary length.

This looks like a good blog article on this topic:
brunoscheufler.com/blog/2022-1

Here are the official docs on Nested structures in ClickHouse: clickhouse.com/docs/en/sql-ref

#clickhouse

Last updated 1 year ago

Thom O'Connor · @thomoco
197 followers · 1126 posts · Server mas.to

@akahn do you have some specific questions on metrics? I'm happy to answer questions or take a look around for something specific to your need. Metrics tend to be the most straightforward for - it was originally designed for a metrics use case (web click data warehouse...thus the name)

#clickhouse

Last updated 1 year ago

Thom O'Connor · @thomoco
197 followers · 1126 posts · Server mas.to

@akahn hi! full disclosure, I work for . I thought this recent blog series on building an Observability cluster for logs/metrics/traces was quite interesting and detailed - please let me know if useful or if I can try to assist further:

clickhouse.com/blog/storing-lo

clickhouse.com/blog/storing-tr

#clickhouse

Last updated 1 year ago

Julio Jimenez · @julioj
182 followers · 1788 posts · Server fosstodon.org

Our friends at Netflix just gave us a pretty great shoutout on stage @monitorama! We're so glad to be able to help them with their log performance!

#clickhouse #monitorama #o11y

Last updated 1 year ago

Julio Jimenez · @julioj
182 followers · 1764 posts · Server fosstodon.org

@mikemcquaid This is a huge win for user privacy.

May I also recommend one of the ClickHouse-based privacy-focused analytics services (PostHog, Plausible), or using directly.

#clickhouse

Last updated 1 year ago