• 1 Post
  • 12 Comments
Joined 2 years ago
cake
Cake day: July 1st, 2023

help-circle
  • As an example, what I do with n8n to hook services together:

    • We use Zello in firefighting to document the incident with short verbal notes or take pictures. Voice gets transcribed, sent to MQTT for dashboards, taken by Telegraf to influx. Pictures and mp3s get downloaded from zello, put into minio, linked back with the metadata and also sent to influx. Finally all is displayed in chronological order on a Dashboard. Zello, Minio, MQTT, influx all glued together with n8n.
    • Another one is the appsmith app for equipment maintenance. We need reports and appsmith is bad at that. n8n queries the Source pgsql, formats it to JSON, sends it to an online service to generate a PDF (with a template), downloads the PDF and puts it into Nextcloud.

    There is more, but just as two examples. Quite easy in n8n, because many integrations are preconfigured (e.g. Nextcloud), but also plain REST API if necessary (zello).

    All without AI…

    Edit: Forgot one, Rocket Chat to keep everybody updated on a bunch of stuff, e.g. new maintenance report available, message on the day of a training, based on caldav. Also all with n8n.





  • dfense@lemmy.worldOPtoSelfhosted@lemmy.worldVersion Dashboard
    link
    fedilink
    English
    arrow-up
    9
    ·
    7 months ago

    Wow, thanks for all the great answers so far. As for why not latest:

    1. Read a lot online and read multiple times it’s “bad practice”
    2. Own experience: had latest on an app which crashed and wouldn’t come up again. Got the backup of the persistent volume back and then had the problem that latest at that point is not the same as latest when I spun it up. Actually had no idea which version I was running last and consequently what I would need to pull to fit my backup. In case I have to restore my cluster, this problem is multiplied.
    3. I run NixOS on everything, so I am clearly biased towards reproducibility.
    4. I am running Services for family and a fire brigade (nothing mission critical, just support stuff, but still…). Stability is important, as sometimes I do not have the time to immediately react to an issue. I prefer a lazy Sunday morning to update/fix and then leave it alone and stable.

    So, probably a combination of latest for low criticality and pinned on critical stuff (e.g. authentication, access, etc.)



  • At the end of the day you have to trust someone (Bitwarden, Hoster, Hardware Manufacturer…). It comes down to your threat profile and what you personally accept as a risk vs. effort (or convenience). For me Bitwarden was acceptable, but I switched to self hosting Vaultwarden ca. 3 years ago. Main reasons being the advanced features (sharing some passwords with the family, setting up a tech savvy friend to take over my vault should I get hit by a bus, etc.). I did not have any relevant downtime of that service in years.





  • I am using appsmith for the app, with a pgsql db. Then n8n to query pgsql with its JSON functions and finally sending it to apitemplate.io to generate a PDF from the JSON and a template. The PDF then goes into nextcloud. With apitemplate you get 50 executions a month for free, which is enough for my use case. Hope this helps. (The use case is an equipment maintenance tool for the SCBAs of our fire brigade, where I need reporting for proving that maintenance was carried out)



  • Years ago I consulted for a French company and analyzed their processes. Heavily depended on Excel. They all pronounced Excel Sheet as “Excel Shit”. All day long it was sentences like"…and then I make an Excel Shit here", “… then I give the Shit to my colleague”. It was glorious… (and technically they were right).