Viewing profile — pradeepchhetri

Very cool project indeed! I tried to check the kind of flights they flew in the world's dangerous airport (Lukla, Nepal)[0] and found they use ATR-72 series. [0] https://adsb.expos…

> Debian package is of poor quality Can you elaborate more please? I would love if you can say what all can be improved to make debian package up to standards.

clickhouse-local is similar to duckdb, you don't need a clickhouse-server running in order to use clickhouse-local. You just need to download the clickhouse binary and start using …

I prefer to use clickhouse-local for all my CSV needs as I don't need to learn a new language (or cli flags) and can just leverage SQL. clickhouse local --file medias.csv --query "…

glad you are using CH :)

I am looking forward to learn about such upcoming features in the community call https://clickhouse.com/company/events/v25-1-community-releas...

ClickHouse has a solid Iceberg integration. It has an Iceberg table function[0] and Iceberg table engine[1] for interacting with Iceberg data stored in s3, gcs, azure, hadoop etc. …

To my knowledge, both Postgres and MySQL has their own strengths and weaknesses. Example: mvcc implementation, data replication, connection pooling and difficulty of upgrades were …

> If I had to only pick two databases to deal with, I’d be quite happy with just Postgres and ClickHouse - the former for OLTP, the latter for OLAP. As the author mentioned, I comp…

Streaming queries is coming in ClickHouse too: https://github.com/ClickHouse/ClickHouse/pull/63312

There was a great talk[0] recently from Laravel core team member about ClickHouse, Probably you will enjoy watching it. [0] https://www.youtube.com/watch?v=_jjvaFWWKqg

You should look at ClickHouse which has good PHP client [0] https://github.com/smi2/phpClickHouse

Since analytics data is generally write-heavy, I would recommend to use ClickHouse. You can use async-insert[0] feature of ClickHouse, thus you don't need to worry about batching e…

You can leverage ClickHouse to process your music data. ClickHouse supports both TSV[0] and XML[1] data formats. [0] https://clickhouse.com/docs/en/interfaces/formats#tabseparat...…

This syntax looks a lot like PRQL. ClickHouse supports writing queries in PRQL dialect. Moreover, ClickHouse also supports Kusto dialect too. https://clickhouse.com/docs/en/guides/…

I would recommend using ClickHouse which provides very efficient compression and thus reduces the size of data drastically. Apart from that, it provides various other feature: - Dy…

I would recommend to look at ClickHouse[0] which is Apache-License and is completely open-source. You can self-host it and it is one of the fastest growing OLAP database. It has go…

If you are interested in reading internals of using Parquet with ClickHouse, do read following articles: - https://clickhouse.com/blog/apache-parquet-clickhouse-local-... - https:/…