Hacker News: parthdesai

New comment by parthdesai in "The only scalable delete in Postgres is DROP TABLE"

parthdesai — Mon, 15 Jun 2026 12:46:10 +0000

> (Most) CRUD/OLTP applications don't delete data by timestamp; they delete by primary key. For those workloads, DROP TABLE (or dropping a partition) isn't a palatable option.

UUID v7 to the rescue!

New comment by parthdesai in "Formal methods and the future of programming"

parthdesai — Sun, 14 Jun 2026 22:22:56 +0000

> But with formal methods, you can prove that "for any input x, foo(x) returns a string with no trailing whitespace".

Isn't that essentially property testing?

New comment by parthdesai in "WhatsApp Business API pricing 2026: what's free and where markup hides"

parthdesai — Fri, 12 Jun 2026 17:27:09 +0000

> but that looks pretty close to pricing for SMS. Which makes market sense (imho) because it's a substitute good

People switched to whatsapp because:

1. It was free unlike SMS 2. It was ubiquitously available like SMS (unlike BBM) 3. It was genuinely a good product.

This feels like Whatsapp (Meta) is rug pulling the users once everyone has moved to Whatsapp, almost analogous to what Uber did. Drive Taxis out of business with predatory pricing, and then increase the prices.

New comment by parthdesai in "PgDog is funded and coming to a database near you"

parthdesai — Fri, 12 Jun 2026 16:39:58 +0000

I could be wrong, but with Citus, for most use cases, you can only have one co-ordinator node which fans out requests. So theoretically, you still can run into bottle necks at some point if 1 coordinator node is not enough.

With proxies like pgdog, multigres, and eventually Neki, these can scale out horizontally, so you get true unlimited scale.

New comment by parthdesai in "PgDog is funded and coming to a database near you"

parthdesai — Wed, 10 Jun 2026 18:25:32 +0000

There's multiple solutions coming up in this space:

1. Neki as you mentioned 2. PgDog 3. Multigres, headed by original creator of Vitesse

New comment by parthdesai in "PgDog is funded and coming to a database near you"

parthdesai — Wed, 10 Jun 2026 18:23:34 +0000

Patroni 1.0 was released in 2016, i.e ~10 years ago.

https://github.com/patroni/patroni

New comment by parthdesai in "PgDog is funded and coming to a database near you"

parthdesai — Wed, 10 Jun 2026 15:32:03 +0000

Semi related question - I have always wondered, how do you tackle OOM issues at the proxy layer, i.e. let's say a particular SQL query requires proxy to fan out the query to multiple shards, which return a pretty large dataset. I'm assuming you would need to load this dataset in the ram to perform certain operations. What happens if the resulting dataset causes the proxy pod to go OOM?

New comment by parthdesai in "Pentagon raised threat of Israeli spying on U.S. to highest level, sources say"

parthdesai — Sat, 06 Jun 2026 22:10:25 +0000

Do you’ve proof for that? On the other hand, AIPAC is out there for anyone to see

New comment by parthdesai in "Pentagon raised threat of Israeli spying on U.S. to highest level, sources say"

parthdesai — Sat, 06 Jun 2026 19:53:40 +0000

Given that US spies on other countries, including allies (countless examples), I wouldn't rule out them spying on Israel either.

New comment by parthdesai in "Pentagon raised threat of Israeli spying on U.S. to highest level, sources say"

parthdesai — Sat, 06 Jun 2026 19:44:27 +0000

How many of those countries openly lobby politicians in USA though?

New comment by parthdesai in "Pentagon raised threat of Israeli spying on U.S. to highest level, sources say"

parthdesai — Sat, 06 Jun 2026 19:43:10 +0000

They sure do, but looking at recent events, you can make an educated guess on which country has more influence over the other. Part of it can be attributed to spying and knowing dark? secrets.

New comment by parthdesai in "Elixir v1.20: Now a gradually typed language"

parthdesai — Wed, 03 Jun 2026 20:31:16 +0000

There's also the "bible": https://www.manning.com/books/elixir-in-action-third-edition

New comment by parthdesai in "Anthropic confidentially submits draft S-1 to the SEC"

parthdesai — Mon, 01 Jun 2026 16:45:18 +0000

Is it actually refreshing? It's actually refreshing to see Stripe staying private for so long. That means, they have a sustainable business model, and can take on projects that might benefit users in the long term despite negative short term consequences instead of focus on growing at all cost for the most part.

New comment by parthdesai in "SQLite is all you need for durable workflows"

parthdesai — Fri, 29 May 2026 22:58:09 +0000

use oban and call it a day: https://oban.pro/

New comment by parthdesai in "HashiCorp co-founder says GitHub 'no longer a place for serious work'"

parthdesai — Wed, 29 Apr 2026 12:58:22 +0000

Serious question, have you been part of an org that had to scale orders of magnitude very quickly?

Anyone who has been part of that journey knows how painful it really is. A lot of times the systems to fail at all levels, and you have to redesign it from the first principles.

New comment by parthdesai in "UAE to leave OPEC"

parthdesai — Tue, 28 Apr 2026 16:14:08 +0000

Majority of US voted for Trump. Maybe not aligned with your version of US, but this is what the majority wanted

New comment by parthdesai in "DeepSeek v4"

parthdesai — Fri, 24 Apr 2026 12:58:56 +0000

Quoting a guy who is (in)directly responsible for murder of about 4 million people. Nice

New comment by parthdesai in "DeepSeek v4"

parthdesai — Fri, 24 Apr 2026 12:54:54 +0000

> If China ever feels emboldened enough to go for Taiwan and the US descends into complete chaos, the rest of the world running on AI will be at the mercy of authoritarian regimes.

Alternative being the current reality and world being dominated by US. Let's ask people in Middle East/Asia/South America about how they feel about that. In this current day and age, how is this statement even relevant?

New comment by parthdesai in "Elevated errors on Claude.ai, API, Claude Code"

parthdesai — Wed, 15 Apr 2026 16:09:12 +0000

Sorry, should've AI will replace software engineers in 6-9 months. I'm hoping AI will be the one responding to this incident as well.

New comment by parthdesai in "Elevated errors on Claude.ai, API, Claude Code"

parthdesai — Wed, 15 Apr 2026 14:47:28 +0000

Coding is solved