pradeepchhetri

11 ms·

1.
He Wasn't Chasing Mountains(hasskhan.substack.com)
1 points by pradeepchhetri 2mo ago|0 comments
2.
Kim Kardashian is welcome to join my Research Team on 3I/ATLAS(avi-loeb.medium.com)
3 points by pradeepchhetri 11mo ago|3 comments
3.
The Scientific Revolution of Interstellar Objects(avi-loeb.medium.com)
6 points by pradeepchhetri 11mo ago|1 comments
4.
by pradeepchhetri 11mo ago
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.exposed/?dataset=Planes&zoom=12&lat=
5.
ClickHouse's JSON datatype gets better(clickhouse.com)
6 points by pradeepchhetri 11mo ago|0 comments
6.
A Postgres Mystery: The SIGTERMs do nothing!(clickhouse.com)
9 points by pradeepchhetri 1y ago|0 comments
7.
Ursa: ClickHouse Research Fork(maksimkita.com)
1 points by pradeepchhetri 1y ago|0 comments
8.
by pradeepchhetri 1y ago
> 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.
9.
by pradeepchhetri 1y ago
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 it. clickhouse local ClickHouse local version 25.
10.
by pradeepchhetri 1y ago
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 "SELECT edito, count() AS count from table gr
11.
One Billion JSON Challenge(clickhouse.com)
15 points by pradeepchhetri 2y ago|0 comments
12.
by pradeepchhetri 2y ago
glad you are using CH :)
13.
by pradeepchhetri 2y ago
I am looking forward to learn about such upcoming features in the community call https://clickhouse.com/company/events/v25-1-community-releas...
14.
by pradeepchhetri 2y ago
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. [0] https://clickhouse.com/docs/en&#x2F
15.
by pradeepchhetri 2y ago
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 the major weaknesses of Postgres which are much improved ove
16.
by pradeepchhetri 2y ago
> 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 completely agree with this statement. In fact, many companie
17.
by pradeepchhetri 2y ago
Streaming queries is coming in ClickHouse too: https://github.com/ClickHouse/ClickHouse/pull/63312
18.
by pradeepchhetri 2y ago
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
19.
by pradeepchhetri 2y ago
You should look at ClickHouse which has good PHP client [0] https://github.com/smi2/phpClickHouse
20.
by pradeepchhetri 2y ago
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 events on your side. If you are looking for an embedded
21.
by pradeepchhetri 2y ago
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... [1] https://clic
22.
by pradeepchhetri 2y ago
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/developer/alternative-..
23.
by pradeepchhetri 2y ago
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: - Dynamic datatype [0] which are very useful for semi-structured
24.
by pradeepchhetri 2y ago
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 good integrations with BI tools and it can be used for wide va
25.
by pradeepchhetri 2y ago
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://clickhouse.com/blog&#
26.
by pradeepchhetri 2y ago
Reading through this blog, to me it seems Parquet is lot like ClickHouse native data format. Best part of ClickHouse native data format is I can use the same ClickHouse queries and can run in local or remote server/cluster and let Clic
27.
by pradeepchhetri 2y ago
> Postgres is still way ahead of ClickHouse in terms of operational simplicity Having served as both ClickHouse and Postgres SRE, I don't agree with this statement. - Minimal downtime major version upgrades in PostgreSQL is very cha
28.
by pradeepchhetri 3y ago
Yup https://clickhouse.com/docs/en/sql-reference/statements/sele...
29.
by pradeepchhetri 3y ago
If you are interested in reading about JOINS in detail, ClickHouse has good blogs around it: - https://clickhouse.com/blog/clickhouse-fully-supports-joins-... - https://clickhouse.com/blog/clickhou
30.
by pradeepchhetri 3y ago
Definitely clickhouse ecosystem. - For querying csv data from command line, I use clickhouse-local. - For querying csv data programmatically using a library, I use chdb (embedded version of clickhouse) - For querying large amount of csv dat

More ›