Readit News logoReadit News
tmountain commented on Avoid UUID Version 4 Primary Keys in Postgres   andyatkinson.com/avoid-uu... · Posted by u/pil0u
sbuttgereit · 10 hours ago
You might have missed the big H2 section in the article:

"Recommendation: Stick with sequences, integers, and big integers"

After that then, yes, UUIDv7 over UUIDv4.

This article is a little older. PostgreSQL didn't have native support so, yeah, you needed an extension. Today, PostgreSQL 18 is released with UUIDv7 support... so the extension isn't necessary, though the extension does make the claim:

"[!NOTE] As of Postgres 18, there is a built in uuidv7() function, however it does not include all of the functionality below."

What those features are and if this extension adds more cruft in PostgreSQL 18 than value, I can't tell. But I expect that the vast majority of users just won't need it any more.

tmountain · 9 hours ago
Sticking with sequences and other integer types will cause problems if you need to shard later.
tmountain commented on The Whole App is a Blob   drobinin.com/posts/the-wh... · Posted by u/valzevul
tmountain · 12 hours ago
I built a language app when it first became viable with GPT and also went the avatar as UI route. It presents a unique set of challenges nd constraints, but I spent the most time just trying to get the mouth to sync with the audio. Fun experience for sure. Regarding learning languages, I have stopped building and relying on apps, as I spend too much time mucking with the app and not enough time on the language. The highest potency practice I have found is transcribing podcasts. It’s a major headache, but it really pushes you forward regarding listening, writing, and spelling.
tmountain commented on Modern Walkmans   walkman.land/modern... · Posted by u/classichasclass
Gud · 6 days ago
So then they are NOT exceptionally durable?

If you must baby them and can’t use them in your car..

tmountain · 3 days ago
Long term archival of just about anything is a challenge. My original point was that they ca serve this use case.
tmountain commented on Modern Walkmans   walkman.land/modern... · Posted by u/classichasclass
al_borland · 7 days ago
As someone who grew up with cassette tapes, I don’t anticipate this fad lasting too long. They were very inconvenient. With most technology I see resistance from people not wanting to move on. I don’t remember seeing that with cassettes. The only downside of CDs was that you couldn’t record from the radio and Napster eventually solved that better than radio ever did.

Minidisc is the format I have some nostalgia for. It never blew up, but it felt like the best of both worlds. You could record from the radio like a digital cassette tapes, and even trim out the DJ and reorder tracks… and give them names. You could also buy them like a CD. From a digital file you could use a TOSlink cable to get a great quality recording at home. And the later ones even played MP3s directly. It could really do it all.

tmountain · 6 days ago
Tapes are exceptionally durable when cared for properly. Here's a video of a guy that tests for loss of quality after 1,000 plays.

https://youtu.be/_dgJ4hRHBiw?si=IpjzdgAHJ4Q9yvb5

Quality is indistinguishable from the first playback. Tapes have a bad reputation because most people used them in the cars, which is the equivalent of storing them in an oven on a daily basis. A lot of car stereos were very cheap, and that lead to a lot of cassettes being damaged when they would have been fine otherwise.

Regarding the quality argument. Again, it's going to depend on the media and the equipment. I have a very nice Marantz tape deck, and I use chrome tapes with it. When recorded and played back with dolby noise reduction, it sounds pretty damn good!

https://youtu.be/jVoSQP2yUYA?si=db7QjRt37ENiLMFX

I say this as someone that also owns a very nice turntable and has a digital FLAC media collection, so I'm not married to tapes in any way. They're just something fun to goof around with (and mostly to give my kid a more tangible experience with playing music at home).

Regarding convenience, I can't argue that they're the least convenient media. That said, I'm an album guy, so I like to listen to recordings in their entirety most of the time.

tmountain commented on CATL expects oceanic electric ships in three years   cleantechnica.com/2025/12... · Posted by u/thelastgallon
zeristor · 9 days ago
Cars have regenerative breaking which is a help in urban areas.

Ships tend to go not change course nearly as much on a several day journey. I guess a propellor could run in reverse for regenerative breaking, but it wouldn’t help much.

tmountain · 9 days ago
Isn’t regenerative braking reclaiming otherwise wasted energy from necessary deceleration? Running the propeller in reverse would result in having to apply equal or greater energy to regain the current speed, so it’s a net loss of energy if I’m understanding the suggestion properly.
tmountain commented on Yt-dlp: External JavaScript runtime now required for full YouTube support   github.com/yt-dlp/yt-dlp/... · Posted by u/bertman
cantor_S_drug · a month ago
You are a digital hoarder. I have taken so many pics that I wouldn't even bother to look back that them (do we ever?) but Google memories is really a neat feature, it refreshes memories. I think you should run a similar service to refresh memory of your favourite videos like they are on speed dail.
tmountain · a month ago
I'm an amateur photographer. Lately, I've taken to making curated collections from my "slush feeds". Meaning, going through a particular trip, time period, moment and grabbing the best photos, and parceling them out to a dedicated album. Makes for a much better experience and fun to share with friends/family.
tmountain commented on You will own nothing and be (un)happy   racc.blog/you-will-own-no... · Posted by u/showthemfangs
Aldipower · a month ago
"It’s funny how “ownership” in the digital world has become an illusion. You don’t really own your apps, your music, or even your tools anymore."

That's your decision. I've published an music album on Bandcamp. You can buy it, I'll send you a real physical tape and you can _download_ high quality FLAC you own then.

If you like to own things, you have all the possibilities.

But I agree, we maybe tend to forget about high quality stuff, if we consume conveniently low quality streaming content for example on Spotify.

tmountain · a month ago
This is why I collect vinyl records, make my own cassette tapes and have a fairly huge DAS drive with all my media (movies, music, photos, etc). Ironically, I use Plex (non free), but I can pivot very easily if needed.
tmountain commented on Automatically Translating C to Rust   cacm.acm.org/research/aut... · Posted by u/FromTheArchives
jurschreuder · a month ago
In a way this is strange because there us a huuuge new area of vulnerabilities caused by LLMs writing code that DWARFS the read/write out of array bounds issues C has.
tmountain · a month ago
I understand the issues related to LLM leaking and re-distributing "private" information, but I'm curious which category of concerns you're referring to. Would you mind giving some context (genuinely curious) ?
tmountain commented on How the brain's activity, energy use and blood flow change as people fall asleep   massgeneralbrigham.org/en... · Posted by u/XzetaU8
submeta · 2 months ago
Tangential: Have had sleep disorders my whole life. Until I read an article here about melatonin (an article that was about substances that have an effect on longevity). So I started taking melatonin every night, 0.5mg. I must say: Never had this kind of deep sleep. Over such a long period of weeks (since I started taking it). My Garmin watch has a sleep tracker. And it confirms that I get way more deep sleep.
tmountain · 2 months ago
My understanding has always been that you habituate to melatonin after a few days. Is this not true?
tmountain commented on Apple M5 chip   apple.com/newsroom/2025/1... · Posted by u/mihau
paxys · 2 months ago
M5 is 4-6x more powerful than M4, which was 5x more powerful than M3, which was 4x more powerful than M2, which was 4x more powerful than M1, which itself was 6x faster than an equivalent Intel processor. Great!

Looking at my Macbook though, I can say with utmost certainty that it isn't 4000x faster than the Intel one I had 5 years ago.

So, where is the disconnect here? Why is actual user experience not able to keep up with benchmarks and marketing?

tmountain · 2 months ago
Probably synthetic benchmarks that don't represent actual bottlenecks in application usage. How much of what you are doing is actually CPU bound? Your machine still has to do I/O, and even though that's "very fast" these days, it's not happening inside your CPU, so you'll only see the actual improvements when running workloads that benefit from the performance improvements (i.e., complex calculations that can live in the CPU and its cache).

u/tmountain

KarmaCake day3841October 6, 2009
About
https://dailyvim.blogspot.com/

https://parcero.ai/

https://verbose.ly

View Original