hashmush (u/hashmush)

hashmush commented on Avoid UUID Version 4 Primary Keys in Postgres andyatkinson.com/avoid-uu... · Posted by u/pil0u

dotancohen · 4 days ago

From the fine article:

  > Random values don’t have natural sorting like integers or lexicographic (dictionary) sorting like character strings. UUID v4s do have "byte ordering," but this has no useful meaning for how they’re accessed.

Might the author mean that random values are not sequential, so ordering them is inefficient? Of course random values can be ordered - and ordering by what he calls "byte ordering" is exactly how all integer ordering is done. And naive string ordering too, like we would do in the days before Unicode.

hashmush · 4 days ago

Agree, I did a double take on this too.

Values of the same type can be sorted if a order is defined on the type.

It's also strange to contrast "random values" with "integers". You can generate random integers, and they have a "sorting" (depending on what that means though)

hashmush commented on Read your way through Hà Nội vietnamesetypography.com/... · Posted by u/jxmorris12

tsimionescu · 2 months ago

Yes, I had never looked into this and had assumed Vietnamese uses a Chinese-inspired writing system natively, like other languages in the region. Knowing that this is the only writing system immediately made sense of why this is necessary.

hashmush · 2 months ago

Ehm, like in Vietnam's neighbors Laos (ພາສາລາວ) and Cambodia (ខ្មែរ)? Sure Vietnamese used to (a long time ago) be written in its own version of the Chinese script, I'll give you that. But most languages in the region do not use a script derived from Chinese.

hashmush commented on Offline card payments should be possible no later than 1 July 2026 riksbank.se/en-gb/press-a... · Posted by u/sebiw

noduerme · 2 months ago

Wow... depositing more than $1k would trigger AML. That's incredible. In the US it's not uncommon for contractors to pull $10k cash at the end of a week to pay their workers. Some of that may be due to tax evasion or, just as likely, the workers being in the country illegally. I suppose this is another major reason cash is still "tolerated" in the US, because the casual labor market depends so heavily on undocumented workers. No one besides a few ultra-nationalists would really want to enforce such a thing, as it would drive up construction costs. And the nationalists are paranoid and stock up on cash and gold themselves.

Honestly, that system sounds a bit Orwellian. But also, does that mean that you have to pay a bank transfer fee every time you buy anything?

hashmush · 2 months ago

> But also, does that mean that you have to pay a bank transfer fee every time you buy anything?

No, not at all. The Swish rails are free to users. But I've never had to pay any transfer fees for domestic transfers anyway. They are just much slower than using Swish (instant transfers) and much more clunky (bank account number etc. vs. phone number/QR-code).

hashmush commented on AI is different antirez.com/news/155... · Posted by u/grep_it

sebmellen · 4 months ago

In a sense, LLMs emergently figured out the deep structure of language before we did, and that’s the most remarkable thing about them.

hashmush · 4 months ago

I dunno, it seems you have figured it out too, probably before LLMs?

I'd say all speakers of all languages have figured it out and your statement is quite confusing, at least to me.

hashmush commented on Curl: We still have not seen a valid security report done with AI help linkedin.com/posts/daniel... · Posted by u/indigodaddy

jacksnipe · 7 months ago

Something that really frustrates me about interacting with (some) people who use AI a lot is that they will often tell me things that start “I asked ChatGPT and it said…” stop it!!! If the chatbot taught you something and you understood it, explain it to me. If you didn’t understand or didn’t trust it, then keep it to yourself!

hashmush · 7 months ago

As much as I'm also annoyed by that phrase, is it really any different from:

- I had to Google it...

- According to a StackOverflow answer...

- Person X told me about this nice trick...

- etc.

Stating your sources should surely not be a bad thing, no?

hashmush commented on Interviewing a software engineer who prepared with AI kapwing.com/blog/what-its... · Posted by u/justswim

rahimnathwani · 8 months ago

Sorry, I wrote this in a hurry. Of course I would have included an ORDER BY clause.

hashmush · 8 months ago

The one without that clause was still fun to think about, so no harm done!

hashmush commented on Interviewing a software engineer who prepared with AI kapwing.com/blog/what-its... · Posted by u/justswim

rahimnathwani · 8 months ago

Me, too.

But, sadly, OP is right.

When doing a technical screen I'll sometimes pick a skill the person claims to have, and ask them the simplest possible non-trivial question I can ask.

For example, let's say you list 'SQL' as one of the skills on your CV. I might show you a SQL statement like:

  SELECT id, start_date FROM employees;

(EDIT: I meant SELECT id, start_date FROM employees ORDER BY id;)

I'll tell you id is an auto-increment field, and ask whether the result would show the newest employee at the top or the bottom.

You have a 50/50 chance of getting it right. If you get it wrong, I'll tell you the answer. Getting it wrong wouldn't disqualify you.

Then I'll ask you how to get it in the opposite order.

I am expecting you to immediately say 'add DESC'. If you can't answer that question in under 2 seconds, you probably haven't written enough SQL to justify listing it as a skill on your CV.

You would be surprised at how many people fail simple tests just like this one.

(I won't use this particular one again.)

hashmush · 8 months ago

> You have a 50/50 chance of getting it right.

What is the right answer? Doesn't it depend on the DB? Postgres at least shows rows ordered by last updated time (simplified, I know).

I would be fine if it was "... near the top or bottom" though.

(Or maybe this comment is the correct answer?)

hashmush commented on Show HN: Seven39, a social media app that is only open for 3 hours every evening seven39.com... · Posted by u/mklyons

dailykoder · 9 months ago

Fun fact: If you don't open a social media account, then you will most likely not spend hours on their apps. Sounds really fucking crazy, but it's true. I tested it myself!

hashmush · 9 months ago

You know what? I've noticed the same thing with eating snacks etc., if you don't buy any, you won't eat any. It's amazing!

hashmush commented on Show HN: I made a site to tell the time in corporate corporate.watch... · Posted by u/steadycourse

TheSmoke · 10 months ago

every week I search at least once “which week is it” — kudos :)

hashmush · 10 months ago

Uhm? The site doesn't show what week it is..? It's currently week 9 of 2025, but the site shows W7 of Q1. (Maybe that's what you meant? Searching for the current week in the quarter?)