Skip Navigation

dan

@ dan @upvote.au

Posts
4
Comments
2751
Joined
3 yr. ago

Aussie living in the San Francisco Bay Area.Coding since 1998..NET Foundation member. C# fan https://d.sb/Mastodon: @dan@d.sb

  • Killer

    Jump

  • Linux will try SIGQUIT first, and you can immediately kill a process in Windows too. taskkill /f /im firefox.exe

  • Killer

    Jump

  • Wikipedia owner signs on Microsoft, Meta in AI content training deals

    Jump

  • I was going to ask why they need to pay given you can download a full copy of Wikipedia's database for free, but it makes sense that AI training is stressing their download servers and therefore they want to receive compensation for it.

    I'm still undecided about AI, but non-profits receiving payment from big companies that take advantage of their work is always a positive thing.

  • The #1 Programmer Excuse for Legitimately Slacking Off (2026 Edition)

    Jump

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

  • Self-hosting Odoo ERP for small business - bad idea?

    Jump

  • 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.

  • Experience on torrenting and hoarding with Raspberry Pi?

    Jump

  • 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.

  • Experience on torrenting and hoarding with Raspberry Pi?

    Jump

  • 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.

  • Experience on torrenting and hoarding with Raspberry Pi?

    Jump

  • 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.

  • Experience on torrenting and hoarding with Raspberry Pi?

    Jump

  • Consider using NFS instead of sshfs for more reliability.

  • Cheapest way to back up a lot of data?

    Jump

  • 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.

  • Man arrested for violating Japan’s anti-dueling law in downtown Tokyo

    Jump

  • Hopefully nobody lands on the same space as another player in Mario Party.

  • Cheapest way to back up a lot of data?

    Jump

  • 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.

  • Stop using MySQL in 2026, it is not true open source

    Jump

  • 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.

  • Stop using MySQL in 2026, it is not true open source

    Jump

  • 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.

  • Stop using MySQL in 2026, it is not true open source

    Jump

  • 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.

  • Cheapest way to back up a lot of data?

    Jump

  • 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.

  • Need advice for buying first hardware

    Jump

  • 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.

  • KDE goes vroom vroom 🚗! 2026 Mercedes-Benz CLA, the first car to run KDE's KWin, receives "Car of the Year" award

    Jump

  • Can you enable wobbly windows in the car?

  • Github Banned a Ton of Adult Game Developers and Won’t Explain Why

    Jump

  • I think sometimes people forget that one of the main features of Git is that it's decentralized. You don't need Github; just push your repo to a different remote.

    Everyone that clones the repo (usually) has a full copy of it, including all history, and theoretically you can clone the repo directly from their copy. Of course, that's often not practical, which is how we ended up with these centralized services.

    The main issue with losing a Github repo is the auxiliary non-Git-powered features of Github, like issue tracking.

  • Minneapolis mayor tells ICE to “get the f— out of’ city

    Jump

  • based mayor