I was thinking of using SQLite on top of k3s/Longhorn to replicate it. Anyone do something similar? Folks mention light steam and aws but Jeff Bezos’s biceps are too much for me to handle.
I've had pretty terrible experiences with SQLite and Longhorn/NFS.
It's just not the right database for pretty much ANY network based filesystem, where the locking primatives aren't as robust, and you might get two processes trying to hit it at the same time.
As someone who runs a fairly big personal cluster backed by a mix of giant NFS storage for media, and relatively large longhorn SSD drives for configs/temp data...
I avoid sqlite backing like the plague. It will get corrupted. Period. It's not the db for this use-case, and I'll take postgres/maria/mysql/mongo/ANYTHING else over it.
If you do it - back it up ALL THE TIME, because it's going to get corrupted.
Also games are for leisure. The same thing is true in Hollywood—hundreds of crew members getting paid small wages relative to their long hours and a few stars getting millions.
I think part of the problem is that source code is always in flux. So to think of the satisfaction of completing a project seems difficult to imagine.
Big corporations invent new “features” and then axe them, even if the products are delightful; venture capitalists obsessed with building to exit on profit alone; open source developers trying to make a name for themselves by building something in Rust to improve performance by 5%.
Compare that to something like architecture or woodworking, gardening, baking, painting—creating real tangible things.
My recommendation is combine the two: use arduinos and/or raspberry PI to automate water delivery in your garden. Stuff like that that you can experience the value at first-hand. :)
