For the best experience on desktop, install the Chrome extension to track your reading on news.ycombinator.com
Hacker Newsnew | past | comments | ask | show | jobs | submit | history | JSR_FDED's commentsregister

All this mucking about with harnesses and context is really just Markdown engineering.

I’m using GL.inet to support family on an old intel MacBook Air in Europe, from Asia. Best purchase ever. I set the quality to low so that the latency isn’t too bad. I basically want to be able to help them with reading email, using their bank’s website, and government services. I bought the MacBook Air as well (intel ones are dirt cheap), dedicated for this purpose - so the KVM and MBA are one fixed unit in a dedicated corner of a desk.

Only thing I wish I could find a remote solution for is scanning a QR code with their phone. Does anyone have any ideas for this?


Small nit: uuid7 is 128 bits (16 bytes) by definition. So there’s no need to convert it to binary. It already is. Unless you’re working with a stringified version of the uuid7.

Oh yes, I meant don’t store as an ID in its string format!

It's just s dumb as storing dates as strings, but people still do it.

But SQLite does not have a native datetime type so you have to use strings

You can use an integer

How do I know the time zone of an integer? Sure there are plenty of cases where one doesn't care, but there are also many cases where the original time zone is important.

The integer is a UTC time so it can be sorted. If you need the time zone you store than in a smaller field.

This has edge cases that are infrequent but messy because it depends presumes timezone changes are transitive across time and they often aren’t.

Eg I save a date 18 months in the future in US Western time at 0600. 3 months from now the US gets rid of Daylight Savings. You saved it as 1400 UTC (which was correct), which is now an hour off because the local time zone is different.

Encoding it in local time fixes that, because it delays the TZ conversion until you need it and your times stay correct as long as you update tzdb like once a month.


other comment said it already, timezone information is not saved. Easiest is just to use a string.

But also one of the recommended ways of doing it, as it has no native Datetime type.

In batches

Radical idea, hear me out…instead of establishing a base in Argentina “motivated by concerns about the future of the United States”, he could take a tiny portion of his wealth and actually contribute to building the right future for the United States.

Why would he do that when he's gained and spent so much of his wealth building the wrong one?

Beautifully expressed. Using AI to remove even more opportunities for human contact is a tragedy.

If I understand the article correctly, the Italians and the Dutch use the same hand gestures to explain to children the concepts of Pizza and Marijuana respectively.

I mean, they do go well together.

There might be something interesting here. The AI writing means I’ll never know.


It sucks. The dumb diagrams as well - do we really need two boxes and an arrow to repeat what was described in a simple line of text just before?

Wow, yes, those are a pisstake. I hadn't seen them when reading the article because I used reader mode.

I'm seeing a lot more of those ai generated graphics which are shiny and flashy but ultimately say nothing.

If only that girl/boy in high school would have gone out with these people we wouldn’t have to deal with this nonsense.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search:

HN For You