Blue Iris is by far the most capable NVR, but it’s Windows-only so you’d need a Windows or Windows Server VM. For a basic setup, Frigate is more than sufficient.

I’d say try Frigate on your ThinkCentre and see how well it runs. I wouldn’t buy new hardware prematurely.

Do I understand that I could then share the igpu between Jellyfin and Docker/Frigate?

I’m not sure about containers like LXC, but generally you need SR-IOV or GVT-g support to share a GPU across multiple VMs. I think your CPU supports GVT-g, so you should be able to find a guide on setting it up.

It must be a lot of work to self-host DigitalOcean.

I meant more if people wouldn’t have found your app without Apple’s App Store. In that case, they’re essentially handling marketing for you.

No other app store is allowed to operate on Apple devices

That’s only true outside of Europe. In the EU, they were forced to allow third-party app stores. The US government doesn’t have the guts to do that, since they focus more on the needs/wants of companies, whereas the EU is really focused on consumer rights.

• Card companies take ~4%
• Patreon takes 10%

Does Patreon’s cut not include payment processing?

The other thing that’s ridiculous in the USA is how much credit card processing costs. Stripe is around 3%, while in countries it can be half of that (in Australia, it’s commonly around 1% for debit cards and 1.5% for credit cards).

Apple is doing nothing in this particular case, not in general. There’s cases where the 30% is more justified.

But you’re getting literally the same Patreon content.

PWAs aren’t great on iPhone… They intentionally limit some functionality to push people towards the App Store.

Some people want everything as apps for some reason.

Why does Apple feel they deserve a 30% cut? In cases like this, Apple aren’t providing any value at all.

• Apple aren’t providing the content - the creator is.
• Apple aren’t providing a platform for the content - Patreon is.
• Apple aren’t providing a platform for discovery - people aren’t finding Patreon creators solely via Apple products.

Sure, Apple are providing a payments platform, but why do they deserve 10x what Stripe charges?

Interesting case. If the plaintiff wins, I suspect this will mean that sites with videos won’t be able to use third-party analytics scripts (not just Meta pixel, but also things like Google Analytics), which would be a pretty large change for the industry.

I’d love to see first-party tracking become more popular again. I self-host Plausible for my sites, but I’ve considered switching to Swetrix.

uploads a copy of the key to their Microsoft Account

Microsoft added that feature because people kept losing their encryption keys and thus losing all their files if they need to have their computer replaced. They get complaints either way - privacy advocates complain when the key is backed up, and sysadmins/users complain when the key isn’t backed up.

Doesn’t Hikvision support RTSP?

Though, on the other hand, having the video saved offsite is useful because then anyone with physical access to your home can’t get rid of the video showing they’re there.

I have Blue Iris configured to send all alert videos to one of my storage VPSes via SFTP. As soon as someone is detected outside, the video clip is sent offsite.

The server and the PoE switch that powers the cameras are also on a UPS, which helps if the intruder tries to shut off the power at the main breaker (which, here in California, always needs to be located outside).

It’s in response to you saying isolate the cameras from the internet entirely

The cameras themselves should always be isolated. No internet access for the cameras at all. Your NVR can have network access, and is what would handle uploading the videos to internet storage somewhere.

Reolink

Any cameras that can operate entirely offline are good. Dahua and Hikvision are good too. Look for cameras with RTSP and ONVIF support. ONVIF is a standardized API for interacting with cameras and can handle things like pan/tilt/zoom, sending events from the camera to the NVR (eg motion detection), and a bunch of other things.

I use Blue Iris as my NVR, which is usually regarded as the best, but there’s other good software too (like Frigate), and hardware solutions too.

Just follow best practices - keep them isolated on a separate VLAN with no internet access. If you want remote access to your NVR, use a VPN like Tailscale.

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.

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.