Hacker News: pradeepchhetri

Kim Kardashian is welcome to join my Research Team on 3I/ATLAS

pradeepchhetri — Mon, 03 Nov 2025 17:18:29 +0000

Article URL: https://avi-loeb.medium.com/kim-kardashian-is-welcome-to-join-my-research-team-on-3i-atlas-975ea3356581

Comments URL: https://news.ycombinator.com/item?id=45801548

Points: 3

# Comments: 3

The Scientific Revolution of Interstellar Objects

pradeepchhetri — Sun, 02 Nov 2025 18:46:10 +0000

Article URL: https://avi-loeb.medium.com/the-scientific-revolution-of-interstellar-objects-b305eb3f3270

Comments URL: https://news.ycombinator.com/item?id=45792433

Points: 6

# Comments: 1

New comment by pradeepchhetri in "ADS-B Exposed"

pradeepchhetri — Tue, 14 Oct 2025 16:17:50 +0000

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=27.7136&lng...

ClickHouse's JSON datatype gets better

pradeepchhetri — Fri, 10 Oct 2025 03:55:46 +0000

Article URL: https://clickhouse.com/blog/json-data-type-gets-even-better

Comments URL: https://news.ycombinator.com/item?id=45535244

Points: 6

# Comments: 0

A Postgres Mystery: The SIGTERMs do nothing!

pradeepchhetri — Fri, 11 Jul 2025 06:00:03 +0000

Article URL: https://clickhouse.com/blog/sigterm-postgres-mystery

Comments URL: https://news.ycombinator.com/item?id=44528815

Points: 9

# Comments: 0

New comment by pradeepchhetri in "XAN: A Modern CSV-Centric Data Manipulation Toolkit for the Terminal"

pradeepchhetri — Wed, 09 Apr 2025 03:06:45 +0000

> 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.

New comment by pradeepchhetri in "XAN: A Modern CSV-Centric Data Manipulation Toolkit for the Terminal"

pradeepchhetri — Mon, 31 Mar 2025 02:27:17 +0000

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.4.1.1143 (official build).

  :)

There are few benefits of using clickhouse-local since ClickHouse can just do lot more than DuckDB. One such example is handling compressed files. ClickHouse can handle compressed files with formats ranging from zstd, lz4, snappy, gz, xz, bz2, zip, tar, 7zip.

  clickhouse local --query "SELECT count() FROM file('top-1m-2018-01-10.csv.zip :: *.csv')"
  1000000

Also clickhouse-local is much more efficient in handling big csv files[0]

[0]: https://www.vantage.sh/blog/clickhouse-local-vs-duckdb

New comment by pradeepchhetri in "XAN: A Modern CSV-Centric Data Manipulation Toolkit for the Terminal"

pradeepchhetri — Sun, 30 Mar 2025 01:45:41 +0000

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 group by all order by count FORMAT PrettyCompact"

   ┌─edito──────┬─count─┐
   │ agence     │     1 │
   │ agrégateur │    10 │
   │ plateforme │    14 │
   │ individu   │    30 │
   │ media      │   423 │
   └────────────┴───────┘

With clickhouse-local, I can do lot more as I can leverage full power of clickhouse.

One Billion JSON Challenge

pradeepchhetri — Thu, 30 Jan 2025 15:50:47 +0000

Article URL: https://clickhouse.com/blog/json-bench-clickhouse-vs-mongodb-elasticsearch-duckdb-postgresql

Comments URL: https://news.ycombinator.com/item?id=42878867

Points: 15

# Comments: 0

New comment by pradeepchhetri in "Apache Iceberg"

pradeepchhetri — Thu, 30 Jan 2025 05:00:40 +0000

glad you are using CH :)

New comment by pradeepchhetri in "Apache Iceberg"

pradeepchhetri — Mon, 27 Jan 2025 07:00:01 +0000

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

New comment by pradeepchhetri in "Apache Iceberg"

pradeepchhetri — Sun, 26 Jan 2025 07:17:31 +0000

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/sql-reference/table-functions...

[1] https://clickhouse.com/docs/en/engines/table-engines/integra...

New comment by pradeepchhetri in "7 Databases in 7 Weeks for 2025"

pradeepchhetri — Fri, 06 Dec 2024 04:30:52 +0000

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 over time. Similarly mysql query optimizer is consider lesser developed than that of Postgres's.

Overall I think Postgres adoption and integrations and thus community is much more wider than MySQL which gives it major advantage over MySQL. Also looking at the number of database-as-a-service companies of Postgres vs those of MySQL we can immediately acknowledges that Postgres is much widely adopted.

New comment by pradeepchhetri in "7 Databases in 7 Weeks for 2025"

pradeepchhetri — Fri, 06 Dec 2024 03:01:06 +0000

> 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 companies like Cloudflare are built with exactly this approach and it has scaled them pretty well without the need of any third database.

> Another reason I suggest checking out ClickHouse is that it is a joy to operate - deployment, scaling, backups and so on are well documented - even down to setting the right CPU governor is covered.

Another point mentioned by author which is worth highlighting is the ease of deployment. Most distributed databases aren't so easy to run at scale, ClickHouse is much much easier and it has become even more easier with efficient storage-compute separation.

New comment by pradeepchhetri in "Show HN: Open-source Kibana alternative for logs and traces in ClickHouse"

pradeepchhetri — Wed, 13 Nov 2024 20:27:23 +0000

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

New comment by pradeepchhetri in "SQLite on Rails: The how and why of optimal performance"

pradeepchhetri — Thu, 12 Sep 2024 02:31:30 +0000

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

New comment by pradeepchhetri in "SQLite on Rails: The how and why of optimal performance"

pradeepchhetri — Thu, 12 Sep 2024 02:25:44 +0000

You should look at ClickHouse which has good PHP client

[0] https://github.com/smi2/phpClickHouse

New comment by pradeepchhetri in "SQLite on Rails: The how and why of optimal performance"

pradeepchhetri — Thu, 12 Sep 2024 02:15:43 +0000

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 solution, you can use chDB which is built on top of ClickHouse.

[0] https://clickhouse.com/blog/asynchronous-data-inserts-in-cli...

New comment by pradeepchhetri in "How to process 100gb tsv and XML files?"

pradeepchhetri — Fri, 30 Aug 2024 03:14:50 +0000

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://clickhouse.com/docs/en/interfaces/formats#xml

New comment by pradeepchhetri in "Google's new pipe syntax in SQL"

pradeepchhetri — Thu, 29 Aug 2024 05:43:43 +0000

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-...