Hacker News: rossmohax

New comment by rossmohax in "When should you use the IN instead of the OR operator in Postgres?"

rossmohax — Thu, 31 Aug 2023 11:54:30 +0000

It does, but AFAIk only for prepapred queries and cache is local to the backend serving query. See `plan_cache_mode` param.

New comment by rossmohax in "When should you use the IN instead of the OR operator in Postgres?"

rossmohax — Thu, 31 Aug 2023 11:43:02 +0000

Please use neither. Reason is as number of lookups varies, you'll have to template query as a string adding either values to IN list or `OR` conditions. Not only it causes excessive string concatenation on your app side, these queries are also seen as distinct queries which has following drawbacks:

- every query has to be planned

- your DB driver can't prepare query as they are all different

- collecting per query stats becomes nightmare if number of arguments per query varies in wide range. metrics cardinality is a problem.

Correct way to handle it is pass all args as single parameter of type array and use `= ANY($1)` or if there are multiple columns build a virtual table and join:

  SELECT a,b FROM table 
  NATURAL JOIN ROWS FROM (
    unnest($1::type_of_a[]),
    unnest($2::type_of_b[])
  ) t(a,b)

New comment by rossmohax in "Don't Take VC Funding – It Will Destroy Your Company"

rossmohax — Sun, 09 Jul 2023 16:58:33 +0000

There was a company I can't recall its name, but they took VC funding for one round, retained voting control, built successfull business and then refused to go for another VC round. VC still owns company, but can't exit and founders are happy with the way things are.

New comment by rossmohax in "ZFS 2.2.0 (RC): Block Cloning merged"

rossmohax — Tue, 04 Jul 2023 19:21:38 +0000

Does ZFS or any other FS offer special operations which DB engine like RocksDB, SQLite or PostgreSQL could benefit from if they decided to target that FS specifically?

New comment by rossmohax in "Tesla Gives New UK Owners a ‘Reacher’ Stick to Deal with Left-Hand Drive Cars"

rossmohax — Sun, 02 Jul 2023 18:12:05 +0000

Life would be easier if UK switched driving sides.

New comment by rossmohax in "Everything that uses configuration files should report where they're located"

rossmohax — Sun, 25 Jun 2023 09:57:04 +0000

this will work 0% of the time if app closes config after reading

New comment by rossmohax in "System Initiative: Second Wave DevOps"

rossmohax — Wed, 21 Jun 2023 19:59:39 +0000

This talk is must see to understand what SI tries to achieve.

New comment by rossmohax in "System Initiative: Second Wave DevOps"

rossmohax — Wed, 21 Jun 2023 19:58:09 +0000

I like the appeal of model being bidirectional. Also modelling sequence of actions is really not solved problem in Terraform & Pulumi: canary change, check metrics, rollout to the rest of the region, check metrics, then all regions, if they solved it all while being "declarative" and high level it can be the next tool of choice for me.

I am not worried about UI representation of the model like many comments, it is not the main point of this project as I understand. UI just that - a representation, same relationships might as well be coded in HCL or the like of it.

New comment by rossmohax in "PostgreSQL reconsiders its process-based model"

rossmohax — Tue, 20 Jun 2023 07:00:21 +0000

This project could borrow a lot from unikernels. If they mandate running it as a VM, there is no HW to support.

New comment by rossmohax in "Mullvad Leta (Search Engine)"

rossmohax — Tue, 16 May 2023 17:27:15 +0000

TLDR; it is a Google search proxy for Mullvad customers with 50 searches per 24 limit. There is an option to do unlimited number of searches in their cache.

New comment by rossmohax in "Fibonacci Hashing: An optimization that the world forgot (2018)"

rossmohax — Sun, 30 Apr 2023 09:40:28 +0000

TLDR; hash the hash with fast function, like fibonacci hash which is just single multiplication by a constant, then take lower bits as your bucket index.

New comment by rossmohax in "Office of the President of Mongolia: Top to bottom text on the web"

rossmohax — Fri, 21 Apr 2023 12:32:03 +0000

How does Mongolian IDE look like?

New comment by rossmohax in "Using io_uring for network I/O"

rossmohax — Thu, 13 Apr 2023 05:02:12 +0000

There is still no good support for io_uring in Rust. AFAIK none of existing solutions fully support multishot ops, zerocopy ops with delayed buffer release, sending messages to another ring with IORING_OP_MSG_RING or convenient ops linking

New comment by rossmohax in "Key takeaways from the quest design of Cyberpunk 2077 and The Witcher 3"

rossmohax — Sun, 02 Apr 2023 23:06:14 +0000

I thought Witcher 3 had a good story until I played Disco Elysium.

New comment by rossmohax in "Tracking the Fake GitHub Star Black Market"

rossmohax — Sat, 18 Mar 2023 10:39:55 +0000

More than once I've seen when number of stars was an argument to decide whether to pull dependency or write our own.

New comment by rossmohax in "Gitlab loses one-third of its value after company issues weak forecast"

rossmohax — Mon, 13 Mar 2023 23:25:36 +0000

Gitlab CI pipelines are miles ahead from Github Actions or Circle CI.

New comment by rossmohax in "Better alternatives to git submodules"

rossmohax — Fri, 03 Mar 2023 13:00:53 +0000

It is a great and more ergonomic alternative, can't recommend enough.

New comment by rossmohax in "Declarative Shadow DOM"

rossmohax — Mon, 13 Feb 2023 21:36:41 +0000

Is it accurate to mentally model this feature as browser mounting/applying CSS not to the document, but to the arbitrary DOM element in it?

New comment by rossmohax in "U.S. military shoots down suspected Chinese surveillance balloon"

rossmohax — Sun, 05 Feb 2023 10:40:57 +0000

If it was flying at 80000ft as initially reported, how did they shot it down? No fighter planes can fly that high. Did they wait until it lowered to the operating altitude?

New comment by rossmohax in "Testing Noctua’s NH-P1 with Ryzen 7700x and Intel’s i9-13900K"

rossmohax — Sun, 29 Jan 2023 18:43:00 +0000

Despite all the effort, benchrmak results are still not consistent. The other day I wanted to check how Ryzen 7600 compares to i13600k in code compilation. Ratio in time between these 2 processors reported by different authors were wildly different:

LTT: 129% GN: 160% Techpowerup: 105%

With results fluctuating up to 2 generational differences it is hard to make sense, despite all the authors effort. This leaves that kind of content more of entertainment rather than informational and from that perspective low effort doesn't bother me.