Linus Torvalds is probably clever enough to create something like that. The Linux kernel sure could take advantage of it.

I know this comment is a bit old, but do you have any recommendations on how to learn about building custom Odoo modules? I’m an experienced developer (with over 20 years experience) but am new to Odoo. I’ve learnt some things by looking at the code for OCA modules (I had to debug an issue with the Plaid bank statement integration) but am interested in any resources you found useful.

Samba is good too, but needs some config tweaking to hit top speeds on faster networks (5Gbps, 10Gbps or more). Probably not relevant here since the Pi only has a gigabit Ethernet port.

I was thinking more about metadata for the torrent client, or for other apps, like Plex or whatever else is running on the Pi. Logs, but also databases (if they store any) and things like that.

Get rid of the SD card and only use the SSDs. It’s a common point of failure with Pis - SD cards aren’t designed for frequent writes.

Consider using NFS instead of sshfs for more reliability.

Definitely… I use Borgbackup for my backups, which encrypts the backups before sending them to the remote server. Not all use cases can do that though, so sometimes it’s useful to have filesystem-level encryption.

Oops, I didn’t know about the SX line, and didn’t know they had auction servers with large amounts of disk space. Thanks!! I’m not familiar with all of Hetzner’a products.

For pure file storage (ie you’re only using SFTP, Borgbackup, restic, NFS, Samba, etc) I still think the storage boxes are a good deal, as you don’t have to worry about server maintenance (since it’s a shared environment). I’m not sure if supports encryption though, which is probably where a dedicated server would be useful.

One of SQLite’s recommended use cases is as an alternate to proprietary binary formats: https://sqlite.org/appfileformat.html. Programs often store data in binary files for performance, but you get a lot of the same functionality included with SQLite (fast random access, concurrent usage, atomicity, updates that don’t need to rewrite the whole file, etc) without having to implement a file format yourself.

I’m not sure if this is still the case, but Facebook’a HHVM used to store the compiled bytecode for the whole site in a single SQLite database: https://docs.hhvm.com/docs/hhvm/advanced-usage/repo-authoritative/. Every pageload loaded the bytecode for all required files from the DB.

SQLite is underrated. I’ve used it for high traffic systems with no issues. If your system has a large number of readers and a small number of writers, it performs very well. It’s not as good for high-concurrency write-heavy use cases, but that’s not common (most apps read far more than they write).

My use case was a DB that was created during the build process, then read on every page load.

MariaDB is not always a drop-in replacement. There’s several features that MySQL has that MariaDB doesn’t, especially related to the optimizer (for some types of queries, MySQL will give you a more optimized execution plan compared to MariaDB). It’s also missing some newer data types, like JSON (which indexes the individual fields in JSON objects to make filtering on them more efficient).

MariaDB and MySQL are both fine. Even though MySQL doesn’t receive as much development any more, it doesn’t really need it. It works fine. If you want a better database system, switch to PostgreSQL, not MariaDB.

AWS Glacier would be about $200/mo, PLUS bandwidth transfer charges, which would be something like $500. R2 would be about $750/mo

50TB on a Hetzner storage box would be $116/month, with unlimited traffic. It’d have to be split across three storage boxes though, since 20TB is the max per box. 10TB is $24/month and 20TB is $46/month.

They’re only available in Germany and Finland, but data transfer from elsewhere in the world would still be faster than AWS Glacier.

Another option with Herzner is a dedicated server. Unfortunately the max storage they let you add is 2 x 22TB SATA HDDs, which would only let you store 22TB of stuff (assuming RAID1), for over double the cost of a 20TB storage box.

Do you mean 12600K, or do you really mean 2600K? These days, I wouldn’t use anything older than 9th gen, especially if you plan on doing any video transcoding with Jellyfin (transcoding means converting the video to a different format while streaming, usually to reduce bandwidth usage when watching videos away from home).

See if there’s any e-waste recyclers in your area. A lot of companies are throwing out systems that don’t officially run Windows 11, so you can sometimes find systems with 8th and 9th gen Intel Core processors for very cheap.

Can you enable wobbly windows in the car?

I didn’t realise they have unprotected streams 👀

usually cable channels lock down their streams pretty well, with CDN URLs that either expire or have a single-use token in them.

If you’re not getting 100% full strength signal, it is literally unwatchable.

It depends… Sometimes it’s terrible, while other times even low signal strength is fine. I only get around 65% signal strength and 75% signal quality for one channel (ABC, I think?), and it still works fine with no stuttering.

I use a HDHomeRun TV tuner, so I can place the antenna where I get the best signal, and the HDHomeRun transmits it over my LAN.

At least NBC is a broadcast station, so you can watch it for free using an antenna. I have an indoor antenna in my garage, connected to a HDHomeRun.

Huh, interesting. TIL videos can have non-square pixels.

THE CHEESE IS UNDER THE SAUCE

Rewriting existing systems is one of the riskiest things a company can do, so old codebases are going to be around for a long time.

Those old COBOL codebases likely contain 50 years of bug fixes for every possible edge case. It’d take a long time to rewrite everything and ensure feature parity, and there’s usually not a significant business reason to rewrite it (after all, a successful end result is just that the system behaves exactly the same as the old one).

The COBOL language is still getting updates, too.