Autistic tech enthusiast and entrepreneur

Sysadmin, Moderator, Technician, Lizard owner, Minecrafter.

Wanna play Minecraft? check out https://gifted-minecraft.com

  • 3 Posts
  • 41 Comments
Joined 2 years ago
cake
Cake day: July 12th, 2023

help-circle




  • Haui@discuss.tchncs.deOPtoSelfhosted@lemmy.worldSonos is down…
    link
    fedilink
    English
    arrow-up
    2
    ·
    2 years ago

    Sounds awesome. I have like 6 small speakers and a tv bar. Not ready to drop them rn since I too want to be able to listen to music taking a shower while my wife listens to something else in the living room. I’m pretty sure people will have figured this out somehow. Time to find some audiophile selfhosted community. :) Besides that, I tend to ask myself why does a service have no viable/selfhosted competition. Most times it is anticompetitive behavior afaik but we’re unable to see it because they’re discreet.


  • Haui@discuss.tchncs.deOPtoSelfhosted@lemmy.worldSonos is down…
    link
    fedilink
    English
    arrow-up
    2
    ·
    2 years ago

    I have barely anything to add to that. Awesome thoughts. Sonos has since fallen out of grace with me as well (same as apple) but I own both brands still since I don’t throw things away if I can help it and exchanging them rn would only hurt me. So I try to make do until the very last moment and then I will switch. I’m stubborn like that.

    Speaking of old music: I’m a violinist and mostly listen to bach (mostly performed by hilary hahn). I have visited two of her concerts and plan on buying her album(s) on vinyl once I get wifi on my vinyl player. Other than that its mostly CCR. So old music is my favorite as well.

    Thank you very much for elaborating. I’ll see to it that I at least have a fall back library soon. :)


  • Haui@discuss.tchncs.deOPtoSelfhosted@lemmy.worldSonos is down…
    link
    fedilink
    English
    arrow-up
    5
    ·
    2 years ago

    Thanks for answering. I do the same with my blu rays and dvds but I haven’t had local music for years so I will have to look at that.

    My problem also is that not apple music is down but sonos, which is not a subscription service but physical hardware that I have bought. The old „kill switch“ problem so to speak.

    I‘ll look into finding a solution that makes me able to go around online obligation.

    Have a good day. :)





  • Thanks for answering so fast! :)

    I’m not deep enough to know if telegraf can do this. It has “plugins” that work okayish. Not a lot to configure. I suppose I could start going into the nitty gritty but I would abolutely love to avoid it. I have like 10+ services running on my server and I can’t go this deep without an IT team and with a job. :)

    In this special case, it is uptime I’m after and influxdb throws a table at me that looks like this:

    then I use this to get the data into grafana:

    from(bucket: "telegraf")
      |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
      |> filter(fn: (r) => r["_measurement"] == "system")
      |> filter(fn: (r) => r["_field"] == "uptime_format")
      |> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
      |> yield(name: "last")
    

    And what turns up is this:

    Now, having worked with SQL before, there is a way to just show the “2 days, 18:02” bit instead of two values and without manually selecting the host each time in SQL, I just don’t know how to do it in flux.

    I hope this makes sense. Have a good one. :)