HNHacker News
TopNewBestAskShowJobs

rossmohax

1,009 karma · joined December 17, 2015

Email: u947d2ybo@mozmail.com
submissionscomments
rossmohax··on When should you use the IN instead of the OR operator in Postgres?
It does, but AFAIk only for prepapred queries and cache is local to the backend serving query. See `plan_cache_mode` param.
rossmohax··on When should you use the IN instead of the OR operator in Postgres?
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)
rossmohax··on Don't Take VC Funding – It Will Destroy Your Company
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.
rossmohax··on ZFS 2.2.0 (RC): Block Cloning merged
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?
rossmohax··on Tesla Gives New UK Owners a ‘Reacher’ Stick to Deal with Left-Hand Drive Cars
Life would be easier if UK switched driving sides.
rossmohax··on Everything that uses configuration files should report where they're located
this will work 0% of the time if app closes config after reading
rossmohax··on System Initiative: Second Wave DevOps
This talk is must see to understand what SI tries to achieve.
rossmohax··on System Initiative: Second Wave DevOps
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.

rossmohax··on PostgreSQL reconsiders its process-based model
This project could borrow a lot from unikernels. If they mandate running it as a VM, there is no HW to support.
rossmohax··on Mullvad Leta (Search Engine)
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.
rossmohax··on Fibonacci Hashing: An optimization that the world forgot (2018)
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.
rossmohax··on Office of the President of Mongolia: Top to bottom text on the web
How does Mongolian IDE look like?
rossmohax··on Using io_uring for network I/O
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
rossmohax··on Key takeaways from the quest design of Cyberpunk 2077 and The Witcher 3
I thought Witcher 3 had a good story until I played Disco Elysium.
rossmohax··on Tracking the Fake GitHub Star Black Market
More than once I've seen when number of stars was an argument to decide whether to pull dependency or write our own.
rossmohax··on Gitlab loses one-third of its value after company issues weak forecast
Gitlab CI pipelines are miles ahead from Github Actions or Circle CI.
rossmohax··on Better alternatives to git submodules
It is a great and more ergonomic alternative, can't recommend enough.
rossmohax··on Declarative Shadow DOM
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?
rossmohax··on U.S. military shoots down suspected Chinese surveillance balloon
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?
rossmohax··on Testing Noctua’s NH-P1 with Ryzen 7700x and Intel’s i9-13900K
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.

rossmohax··on Posters of the IPv4 and IPv6 internet as of Jan 1, 2023
IPv6 only is still unusuable :( I bought new Sony TV and allocated it a new VLAN with IPv6 only network just to see how it works TV couldn't even detect that it connected to the internet, despite it receiving ipv6 address from my router. It looks like it couldn't use IPv6 DNS servers. If I try to configure IP address statically it wont let me enter IPv6 address at all.
rossmohax··on What AMC’s streaming troubles say about the greater TV industry
Final season of Battlestar Galactica was a flop because of Hollywood screenwriters strike which lasted 3 months
rossmohax··on Japanese have been producing wood for 700 years without cutting down trees
I always thought that trees spend energy to grow higher, because they are fighting for the sun. Looking at the picture there seem to be enough sun for each sprout,why does it keep growing?
rossmohax··on Rust and C++ Interoperability
Do you have exmoles to support claim that there is no compatibility between versions of the same compiler? your linked pdf is from 2014, exact time when compilers stopped breaking things.

AFAIK MSVC compilers explicitly guarantee ABI compatibility since 2015 https://learn.microsoft.com/en-us/cpp/porting/binary-compat-...

as for other platforms, all compilers adhere to Itanium ABI and didnt introduce breaking changes for many years now. Standard libraries, libc++ has explicit ABI guarantee as well (https://libcxx.llvm.org/DesignDocs/ABIVersioning.html).

Libstdc++ uses symbol versioning and only nasty thing happened to it was problem with std::string CoW decade ago, but even that was done neatly and in compatible manner https://gcc.gnu.org/onlinedocs/libstdc++/manual/using_dual_a...

rossmohax··on AWS IAM Roles, a tale of unnecessary complexity
Author keeps saying that Roles are identities,but they are exactly opposite. Role is a set of permissions token issued for that role will have. Whether identity can issue token for that role or not is governed separately. Role is not identity , nor service accounts nor principal.
rossmohax··on Rakuten Mobile is replacing Red Hat as its Linux OS supplier
> To get Rocky Linux to deliver on the same performance of Red Hat for us was a 13-month process. It was not trivial…

I wonder why is that, if Rocky is repackaging RHEL source performance should be identical, no?

Article mentions realtime kernel. It seems they were working with RH on custom kernel (that's the support contract he mentioned), but started to be asked to pay for RHEL license to use it, which understandably pisses him off

rossmohax··on Protonmail can delete the wrong email and nobody cares
I had to move off tutanota when I discovered they don't offer offline access to email.

Protonmail claims to support offline access, but in every rare occasion I needed it, it wasnt working for me.

rossmohax··on For its big comeback, Intel needs to spend money, and it's making less and less
Meta is doing buybacks, which is just another form of dividend, so in that regard they are not that different.
rossmohax··on We need a replacement for TCP in the datacenter [pdf]
> It uses several techniques for this, of which the most notable is that it takes advantage of the priority queues provided by modern switches.

I'd understand if they said routers, but switches? Do L2 switches have any notion of priority and if yes how does it work?

rossmohax··on Spotify Royalty Calculator
Fair payouts empower independent labels, obviously biggest players in the music market are opposing it
Page 1 of 13Next →