GravitySpoiled

Which switches can you recommend?

Can you get them in bulk for a cheaper price?

What's the advantage of the zigbees? I can get both bulbs, wifi and zigbee for ~5 bucks.

I tried reading a lot of articles/ posts. This is all confusing. Some write zigbee is better with battery because wifi lamps need to stay connected with wifi. But the zigbee lamps need to stay connected with zigbee (however they communicate. must be waves as well) as well, does it consume less power? What's the range of these hubs? Wifi is available everywhere. Do I need multiple hubs?

I want to connect them to home assistant, so arguments like zigbee can be better automated should fall short as well, right? I already have one wifi lamp which is automated enough for my taste. What shall I more automate than turn off at x and turn on at y.

And I haven't even read properly into zwave or matter.

Any advice would be greatly appreciated!

Is there a good open source smart home system? What do you guys use? Which brand to buy?

How is OpenHAB?

I tried home assistant but I can't manage to get it working with my reverse proxy.

• install troi first https://github.com/metabrainz/troi-recommendation-playground
• put following into a shell file python -m troi.cli weekly-jams USERACCOUNT -u -y
• open crontab -e and put @weekly filelocation And it'll push your weekly jams to your account

It's an alternative jellyfin + radarr + sonarr (jellyseer) front end. It's in very early stages but it looks and feels so good. I read on the issues that work will progress but there needs to be a lot of planning.

Anyway, it looks good! star it and watch out for the next release

I just found this and haven't seen it here before. It's a great dictionary app

I want to share this as I wanted this for a long time. Finally, I sat down and wrote it. It merges the listens and star ratings of two accounts USER_ID_OLD and USER_ID_NEW. If you want to use it yourself, you have to replace those values with your values. The upper part is descriptive to explore the database and find the fields.

Use at your own risk. backup first. cp navidrome.db navidrome.db.bu. Found mistakes? Please report. Read all lines prior to executing.

# open database
sqlite3 navidrome.db

# show content
.tables

# show users
SELECT * FROM user;

# delete all playlists
DELETE FROM playlist;

PRAGMA table_info(annotation);

SELECT user_id, item_id, play_count FROM annotation ORDER BY play_count DESC LIMIT 10;

UPDATE annotation AS a
SET play_count = (
    SELECT SUM(play_count) 
    FROM annotation AS b 
    WHERE b.item_id = a.item_id
);

UPDATE annotation AS a
SET rating = (
    SELECT MAX(rating)
    FROM annotation AS b 
    WHERE b.item_id = a.item_id
);

UPDATE annotation AS a
SET starred = (
    SELECT MAX(starred)
    FROM annotation AS b 
    WHERE b.item_id = a.item_id
);

UPDATE annotation AS a
SET play_date = (
    SELECT MAX(play_date)
    FROM annotation AS b 
    WHERE b.item_id = a.item_id
);


DELETE FROM annotation
WHERE ROWID NOT IN (
    SELECT MIN(ROWID)
    FROM annotation
    GROUP BY item_id
);

UPDATE annotation SET user_id='USER_ID_OLD' WHERE user_id='USER_ID_NEW';

SELECT user_id, item_id, play_count FROM annotation ORDER BY play_count DESC LIMIT 10;

.quit

Edit: reading it again, it might only work correctly if there are two users.

I stumbled upon Troi. Troi can generate music recommendations https://github.com/metabrainz/troi-recommendation-playground

There's also a playlist generator https://listenbrainz.org/explore/lb-radio/ try it with "tag:edm" or "tag:rock".

It needs to be integrated into available services and mature a bit but then it can become a spotify replacement. It needs more users for more scrobbles as well. This is awesome! Imagine having automated playlists in a subsonic server based on public popularity.

Such info was usually only available to companies like spotify. This is amazing.

I am moving from docker to podman and selinux because I thought that podman is more secure and hence, the future. I thought the transition will be somewhat seamless. I even prepaired containers but once I migrated I still ran into issues.

minor issue: it's podman-compose instead of podman compose. The hyphen feels like a step back because we moved from docker-compose to docker compose. But thT's not a real issue.

podman does not autostart containers after boot. You have to manually start them, or write a start script. Or create a systemd unit for each of them.

Spinning up fresh services works most of the time but using old services that worked great with docker are a pain. I am wasting minutes after minutes because I struggle with permissions and other weird issues.

podman can't use lower number ports such that you have to map the ports outside of the machine and forward them properly.

Documentation and tutorials are "all" for docker. Github issues are "all" for docker. There isn't a lot of information floating around.

I'm still not done and I really wonder why I should move forward and not go back to docker. Painful experience so far. https://linuxhandbook.com/docker-vs-podman/ and following pages helped me a lot to get rid of my frustration with podman.