Live data from Hacker News

Building the world’s fastest website analytics (2021)

usefathom.com

21–30 of 40 posts

Re: Building the world’s fastest website analytics (2021)

#21

Earlier quoted context omitted.

Definitely not. No regrets after making the move. March next year will be the two year mark.

I'm curious how you (and your team I presume) came to decide you need to build your own database?

We didn’t decide that, we used SingleStore

Re: Building the world’s fastest website analytics (2021)

#22
post #19

They would have saved a whole lot of time just using Clickhouse which is a US company and has completely severed ties with Russia [1]. Altinity has offered managed clickhouse since 2020 [2], and now Clickhouse Cloud does too [3] [1] https://clickhouse.com/blog/we-stand-with-ukraine [2] https://altinity.com/cloud-database/ [3] https://clickhouse.com/cloud

If you're really confident that your SaaS application will only have that single workload (single table group-by) into perpetuity, it's a workable choice. But, that's a big bet against the reality of the diverse workloads required today in scale-up SaaS applications. Sure, you can stitch together specialized stores to make your own accidental distributed database for your app, but the simpler, more straight-forward a…

You should probably focus on evangelizing the features of your own database instead of broadcasting your ignorance on those of a competitor.

Re: Building the world’s fastest website analytics (2021)

#23
post #19

They would have saved a whole lot of time just using Clickhouse which is a US company and has completely severed ties with Russia [1]. Altinity has offered managed clickhouse since 2020 [2], and now Clickhouse Cloud does too [3] [1] https://clickhouse.com/blog/we-stand-with-ukraine [2] https://altinity.com/cloud-database/ [3] https://clickhouse.com/cloud

If you're really confident that your SaaS application will only have that single workload (single table group-by) into perpetuity, it's a workable choice. But, that's a big bet against the reality of the diverse workloads required today in scale-up SaaS applications. Sure, you can stitch together specialized stores to make your own accidental distributed database for your app, but the simpler, more straight-forward a…

> Sure, you can stitch together specialized stores to make your own accidental distributed database for your app, but the simpler, more straight-forward and lower-latency alternative available.

Organizations like Facebook, Amazon, Netflix, Cloudflare, and many, many others have been combining specialized data stores for many years. Stonebraker, Madden, and colleagues summarized the argument for this approach in 2007. [0] At this point I can't think of any major SaaS application I've seen recently that did not have multiple data store types. That includes event streams, which are data stores as well.

[0] http://nms.csail.mit.edu/~stavros/pubs/hstore.pdf

Disclaimer: I work for Altinity.

Re: Building the world’s fastest website analytics (2021)

#24

They would have saved a whole lot of time just using Clickhouse which is a US company and has completely severed ties with Russia [1]. Altinity has offered managed clickhouse since 2020 [2], and now Clickhouse Cloud does too [3] [1] https://clickhouse.com/blog/we-stand-with-ukraine [2] https://altinity.com/cloud-database/ [3] https://clickhouse.com/cloud

Yandex (Google of Russia) is a large share holder of Clickhouse Inc[1]. Yes, this maybe a European Yandex subsidiary.. I really don't care to dig, but I think its dishonest to say the company doesn't have Russian backers. Has Clickhouse Inc forced Yandex to divest their large ownership stake?

[1] https://www.crunchbase.com/organization/clickhouse/company_f...

Re: Building the world’s fastest website analytics (2021)

#25

They would have saved a whole lot of time just using Clickhouse which is a US company and has completely severed ties with Russia [1]. Altinity has offered managed clickhouse since 2020 [2], and now Clickhouse Cloud does too [3] [1] https://clickhouse.com/blog/we-stand-with-ukraine [2] https://altinity.com/cloud-database/ [3] https://clickhouse.com/cloud

Yandex (Google of Russia) is a large share holder of Clickhouse Inc[1]. Yes, this maybe a European Yandex subsidiary.. I really don't care to dig, but I think its dishonest to say the company doesn't have Russian backers. Has Clickhouse Inc forced Yandex to divest their large ownership stake? [1] https://www.crunchbase.com/organization/clickhouse/company_f...

> I really don't care to dig

Then why are you opining on the subject?

Re: Building the world’s fastest website analytics (2021)

#26

Earlier quoted context omitted.

Yandex (Google of Russia) is a large share holder of Clickhouse Inc[1]. Yes, this maybe a European Yandex subsidiary.. I really don't care to dig, but I think its dishonest to say the company doesn't have Russian backers. Has Clickhouse Inc forced Yandex to divest their large ownership stake? [1] https://www.crunchbase.com/organization/clickhouse/company_f...

> I really don't care to dig Then why are you opining on the subject?

Because half truths like your statements bother me? Yandex is a large investor in clickhouse Inc. (at last as far as public record shows). Have they forced Yandex to divest their holdings?

Re: Building the world’s fastest website analytics (2021)

#27

Earlier quoted context omitted.

> I really don't care to dig Then why are you opining on the subject?

Because half truths like your statements bother me? Yandex is a large investor in clickhouse Inc. (at last as far as public record shows). Have they forced Yandex to divest their holdings?

It's literally in the article I linked (https://clickhouse.com/blog/we-stand-with-ukraine). As you're incapable of reading let me highlight it for you:

> We have no operations in Russia, no Russian investors, and no Russian members of our Board of Directors.

It's disappointing after 11+ yrs of failing to find traction for MemSQL, this is the hill you die on? You're running your mouth on some random comments thread about a shitty 2-person analytics platform where the author clearly doesn't know the first thing about databases and just went with the first Twitter ad he came across.

Under Raj's "leadership" you know damn well MemSQL/SingleStore will be dead within two years. The hyper-aggressive sales pressure had some success during the lofty bull market due to clueless IT managers with massive budgets, but that time has come to an end. You guys missed the window to IPO to get your own exit and your runway is quickly diminishing.

Re: Building the world’s fastest website analytics (2021)

#28

While reading the article, I found that they are rediscovering the tricks, already well-known for ClickHouse: > The biggest mistake I made was that I kept the UPDATEs in our code (we update the previous pageview with the duration, remove the bounce, etc.). In a few weeks, I'll be moving to 100% append-only by utilizing negative numbers. > For example, if you want to set bounce_rate to 0%, you would write a 1 for boun…

It's worth noting that ClickHouse and MySQL work quite well together. Clickhouse has a similar SQL dialect and can read data directly from MySQL. (Awesome feature BTW; in some cases queries even run faster that way.)

It's straightforward to build applications that do transaction processing in MySQL and analytics in ClickHouse. You can migrate data out of MySQL that does not belong there. You can also use CDC to mirror transaction data into ClickHouse for analytic processing. [0] The resulting applications are quite robust and have the advantage that different parts can scale independently.

Building applications that use the strengths of each of the component databases is a natural way to scale systems.

Disclaimer: I'm the author of the cited article and I work for Altinity.

[0] https://altinity.com/blog/using-clickhouse-as-an-analytic-ex...

Re: Building the world’s fastest website analytics (2021)

#29

They would have saved a whole lot of time just using Clickhouse which is a US company and has completely severed ties with Russia [1]. Altinity has offered managed clickhouse since 2020 [2], and now Clickhouse Cloud does too [3] [1] https://clickhouse.com/blog/we-stand-with-ukraine [2] https://altinity.com/cloud-database/ [3] https://clickhouse.com/cloud

By migrating to SingleStore, we didn’t have to change any persistence logic (we were already using SQL and Laravel Eloquent). Having explored doing that for Elasticsearch, it wasn’t something we wanted to do.

Looking back, I’m glad we went in this direction. Fathom has grown beyond what we could’ve imagined. Let’s see what happens over the next five years.

Re: Building the world’s fastest website analytics (2021)

#30

Earlier quoted context omitted.

Because half truths like your statements bother me? Yandex is a large investor in clickhouse Inc. (at last as far as public record shows). Have they forced Yandex to divest their holdings?

It's literally in the article I linked ( https://clickhouse.com/blog/we-stand-with-ukraine ). As you're incapable of reading let me highlight it for you: > We have no operations in Russia, no Russian investors, and no Russian members of our Board of Directors. It's disappointing after 11+ yrs of failing to find traction for MemSQL, this is the hill you die on? You're running your mouth on some random comments thread…

I read the article. And yes, this was probably a mistake to engage with you on it.

Yandex N.V. (A dutch holding company of Yandex Russia) is listed as an investor of Clickhouse Inc. This is all I'm stating.

Post reply on HN