• 1 Post
  • 296 Comments
Joined 2 years ago
cake
Cake day: June 1st, 2023

help-circle



  • Ohh, SQLite isn’t “one” db. SQLite is file-based. I.e. a database in e.g. PostgreSQL (containing several tables, views, indexes, etc.) would translate to one SQLite file (e.g. mydatabase.db3 or myappdata.sqlite). And each app has its own file/database. If the file corrupts, then it’s only affecting that specific app. (However, SQLite is pretty robust.) And since these are just files, you can backup them together with the application. No need to export data or shutdown the database first.






  • On the receiving end of this controller, there’s probably just a relay shorting 2 wires from the boiler together - like the Honeywell BDR91.

    So, you could just replace that by some Shelly switch and wouldn’t have to use the proprietary radio protocol.

    On a sidenote: Those room controllers usually “learn” how long it takes to reach the target temperature (as this can be vastly different between summer and winter) and move the starting time accordingly. So they reach the target temperature at the programmed time. At least the more expensive ones do. You’d have to do something similar in your automation if you want that comfort. (Unless HA already has some code for that…)





  • This is because they own the gameplay

    Do they, though? They create the world, but the player is the one controlling the action.

    someone reading a book out loud publicly

    If I publicly read a book, I replay the contents verbatim. Basically an exact copy. But playing a game IMHO is more like fan-fiction. I’m making my own story and thus there should be no way to get any legal case against showing/publishing this to others.

    That being said, if you monetise your videos and make money from them, it becomes a whole different story.





  • If you spin up a Lemmy instance and subscribe to a community, all new posts and comments inside that community will be mirrored to your instance. As I’m subscribed to around 100 different communities, that was a LOT of traffic without me doing anything. That’s why I’ve given up on self-hosting Lemmy just for myself and went back to using lemmy.ml.

    However, I do self-host a GoToSocial server just for myself. It’s probably not necessary as mastodon.social isn’t going anywhere anytime soon, but if you’re on a smaller instance, it might be worth it. Also, you get to show off your own domain name. And, while other instances may block yours, your content stays online as long as YOU want it to. There’s no way for an external moderator to delete posts on your own server.

    People can find you via Boosts from others or by searching for your @username@domain.com.

    Maintaining my GoToSocial so far consisted of simply getting WatchTower to update the Docker container. Migration of data to a new version happens automatically. (Well, there was one accident where some pre-release version got released under the latest tag and I had to use the development branch for a few days … but that was an accident from the GtS-team and shouldn’t happen again.)




  • In Paris, France, government officials went around the inner city area and forcefully removed all unofficial key safes from buildings. That’s how all cities should handle this.

    However, some years ago there was a news story going around about one person that owns various different places in Berlin, all listed under different names on AirBnB and that person barely visits those places as he has cleaning people do everything in between bookings. They only pocket the huge amounts of money while doing nothing. And the description to find the door key was like “find the public bicycle rack and look for the broken bike with a pink frame, the key will be under the saddle” and there were specific instructions to not talk to anyone in that building. So they definitely knew that this was kind of a grey area…