4 ms·
If you don't know what a column oriented DB is, that page is probably not for you.
by cinbun8 4y ago
If you don't know what a column oriented DB is, that page is probably not for you.
- bagels 4y agoI 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.
- pqdbr 4y agoCare 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?
- ipaddr 4y agoIsn't it just a database in Second normal form (2NF)?
- bfung 4y agoNo. 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.