Hacker News: sirfz

New comment by sirfz in "Pandas Should Go Extinct"

sirfz — Sat, 12 Sep 2026 05:20:03 +0000

I've plugged this several times here (just a fan) but chdb's DataStore is a "lazy" drop-in replacement for pandas dataframe. Pandas API with chdb performance. I don't use it myself (I do everything mostly in sql with either duckdb or chdb) but always found pandas more convinient than polars for quick and dirty data crunching (less typing and frankly more pythonic if you're used to slicing).

New comment by sirfz in "Google Has Removed MV2 Extensions from the Chrome Web Store, Including UBO"

sirfz — Mon, 31 Aug 2026 21:47:20 +0000

Firefox was amazing even when Chrome was released

New comment by sirfz in "Migrating to HTTPX2"

sirfz — Sat, 29 Aug 2026 17:38:15 +0000

Understood (fyi I was genuinely asking as I only used pyreqwest, which I like, and was looking for comparison if any)

New comment by sirfz in "Migrating to HTTPX2"

sirfz — Fri, 28 Aug 2026 21:02:49 +0000

Why not pyreqwest?

New comment by sirfz in "Python Polars Cheatsheet (based on our O'Reilly book)"

sirfz — Tue, 18 Aug 2026 19:57:51 +0000

Yep, and chdb as well. Said this before, chdb's DatStore is a pretty neat pandas replacement too.

New comment by sirfz in "Mir Books – Books from the Soviet Era"

sirfz — Sat, 04 Jul 2026 16:11:03 +0000

They have a very strong DIY culture which I'm sure helps with making people explore and discover knowledge and develop skill

New comment by sirfz in "Mojo 1.0 Beta"

sirfz — Fri, 08 May 2026 21:51:22 +0000

Cython is a no-brainer really. You write the same language with immense speedup (matching what the "other languages" can achieve at much less effort).

Also tools like numba can beat them all at way less effort.

Imho, dropping into other languages should be the last resort in any project.

New comment by sirfz in "AI got the blame for the Iran school bombing. The truth is more worrying"

sirfz — Fri, 27 Mar 2026 21:04:33 +0000

My comment is to say the US has proven how brutal they are consistently through all the wars of aggression they have waged in the past several decades. They do not see their "enemies" as human. I can't fix anything unfortunately.

New comment by sirfz in "AI got the blame for the Iran school bombing. The truth is more worrying"

sirfz — Fri, 27 Mar 2026 20:38:43 +0000

It's incredible, after all the grotesque stories about rape, torture and murder of children, men and women during the Iraq war, active support of genocide (and 10s of thousands of children murdered by Israel, on purpose), prisoners rape and child imprisonment, a "secretary of war" and president publicly admiting to war crimes and saying things like "negotiate with bombs" you still "refuse to believe" that anyone in decision chain wouldn't do anything like this.

New comment by sirfz in "A Faster Alternative to Jq"

sirfz — Fri, 27 Mar 2026 12:11:40 +0000

Nowadays I'd just use clickhouse-local / chdb / duckdb to query json files (and pretty much any standard format files)

New comment by sirfz in "Python: The Optimization Ladder"

sirfz — Sat, 14 Mar 2026 21:47:38 +0000

Fwiw, I thought the article is full of great information and well researched. I think your reflex is holding you back.

New comment by sirfz in "SSH Secret Menu"

sirfz — Wed, 11 Mar 2026 00:50:26 +0000

You can even chain them if you have deep ssh connections (i.e. ssh from one instance to another). I think it would be ~~. to terminate the 2nd hop.

Edit: it's already explained in the OP

New comment by sirfz in "You Don't Need a Vector Database"

sirfz — Sun, 08 Mar 2026 13:25:34 +0000

You don't need a vector db, you just need np.dot

New comment by sirfz in "The United States and Israel have launched a major attack on Iran"

sirfz — Sat, 28 Feb 2026 20:23:12 +0000

You being Iranian-american bares no weight on your opinion

New comment by sirfz in "The United States and Israel have launched a major attack on Iran"

sirfz — Sat, 28 Feb 2026 20:22:24 +0000

No he's saying that israel intentionally bomb schools and hospitals

New comment by sirfz in "Apache Arrow is 10 years old"

sirfz — Fri, 13 Feb 2026 01:14:58 +0000

chdb's new DataStore API looks really neat (drop in pandas replacement) and exactly how I envisioned a faster pandas could be without sacrificing its ergonomics

New comment by sirfz in "Pandas 3.0"

sirfz — Wed, 28 Jan 2026 12:55:07 +0000

I think that's a sane take. Indeed, I think most data analysts find it much easier to use pandas over polars when playing with data (mainly the bracket syntax is faster and mostly sensible)

New comment by sirfz in "Unconventional PostgreSQL Optimizations"

sirfz — Tue, 20 Jan 2026 22:38:34 +0000

It'll use less storage space

New comment by sirfz in "Unconventional PostgreSQL Optimizations"

sirfz — Tue, 20 Jan 2026 20:34:28 +0000

That doesn't work well with conflicts tho iirc

New comment by sirfz in "OLED, Not for Me"

sirfz — Sat, 10 Jan 2026 07:49:12 +0000

I just ordered this monitor earlier this week (still waiting for it to be delivered), did you need to tweak it or use some thing like MacType like others are suggesting in this thread?