Re:ClickHouse Cloud is now in Public Beta
by cinbun8 on Tuesday October 04, 2022 @11:55AM
(#33082232)
If you don't know what a column oriented DB is, that page is probably not for you.
[ Parent
| on HN ]
Re:ClickHouse Cloud is now in Public Beta
by bagels on Tuesday October 04, 2022 @01:18PM
(#33083509)
I know what a column oriented DB is, but ClickHouse was not on my radar before.
The pitch on the landing page is that ClickHouse Cloud is great if you love ClickHouse. If you don't know what ClickHouse is, you have to do some work to find out.
Care to elaborate? I’m a fullstack Rails dev for 12 years and I had no idea either, just like OP. Why alienate potential users from the get go?
Re:ClickHouse Cloud is now in Public Beta
by ipaddr on Tuesday October 04, 2022 @07:01PM
(#33088323)
Isn't it just a database in Second normal form (2NF)?
No. Column oriented storage db’s make it fast to read 10s to billions of “rows”, usually when you have data that you want to read that can be independent of other columns. Ex: (stock close) - row storage isn’t going to buy you much here, you’d rather read the whole “stock close” column as fast as possible.
Whereas traditional db’s, data like [first name, last name], the columns may have way less meaning on their own and you need both columns to have the data make sense.
A traditional db with B(-)tree storage is much slower when dealing with that type of usage. Storing (stock close) in a single column format makes that type of query much faster.