this post was submitted on 18 Jun 2023
17 points (100.0% liked)

Selfhosted

40041 readers
749 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

  1. Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.

  2. No spam posting.

  3. Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.

  4. Don't duplicate the full text of your blog or github here. Just post the link for folks to click.

  5. Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).

  6. No trolling.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 1 year ago
MODERATORS
 

Hi all (First Lemmy post, yay!)

Does anyone have recommendations for a way to capture, archive and visualize arbitrary data in one convenient location. I'm talking about arbitrary/misc. stuff like electricity usage, gas usage, body weight, spending, mileage, habit tracking etc... Essentially looking for a super solution that can be easily interfaced with, has convenient methods of browsing, filtering, and visualizing, and can (obviously, based on post location) be self hosted.

I currently use mint, beestat, Google Fit, Samsung Health and probably a few others as my trackers/monitors of my personal and home data, but I've always been curious about finding a solution where I have complete control over my personal data once it's captured by the various sources, assuming I can get my hands on it via exporting manually or otherwise.

For background, My experience level is pretty minimal. I have unRAID running on an old desktop PC, hosting a file share and gitlab container. I can scrape python programs together easy enough, but databases and web tech will take some learning.

I'm interested in ways any of you intelligent folks may have figured out how to manage your personal data! Thanks in advance for sharing!

top 14 comments
sorted by: hot top controversial new old
[–] hoodlem@hoodlem.me 5 points 1 year ago

I use Home Assistant for similar purposes, with Influx DB and Grafana. There are many integrations to automatically populate data. For example, I have heart rate data from my Apple Watch flow in so I can view it in Grafana.

[–] ben@l.twos.dev 4 points 1 year ago (2 children)

I’d look at karlicoss’s personal data infrastructure for inspiration (or perhaps deterrent).

[–] Sticky@lemmy.world 3 points 1 year ago (1 children)

Deterrent is right. That graph is terrifying! I feel their frustration regarding getting data from Android apps. Part of what got me started thinking about this was when I realized that the years of data I entered into my fitness pal was suddenly locked behind a subscription service :-( Thanks for sharing!

[–] 3laws@lemmy.world 2 points 1 year ago (1 children)

Wait My Fitness Pal went subscription model? Also, pay once, export once, cancel?

[–] Sticky@lemmy.world 0 points 1 year ago (1 children)

Not entirely, just for some features, including data export past a certain date iirc. I probably will wind up doing just that though if I cannot figure out how to get the data off my phone. Right now the phone app is the only place I can even see that the data exists, so I'm slightly afraid of changing anything in mfp lest it 'sync' my data out of existence 😕

[–] 3laws@lemmy.world 1 points 1 year ago

Oof on that last one. I know for experience how some apps handle sync and poof data is gone forever.

[–] lupec@lemmy.lpcha.im 2 points 1 year ago

Damn, that's as fascinating as it is daunting. Some impressive dedication in there regardless!

[–] klangcola@reddthat.com 3 points 1 year ago

It's not exactly what you're asking for, but you should check out the opensource Android app Track & Graph. It's also on F-Droid

It's a local app though, I don't think it has any sync function.

[–] lupec@lemmy.lpcha.im 3 points 1 year ago (1 children)

Brainstorming a bit, I think wiring up InfluxDB, Grafana plus some convenient way of inputting all those data sources sounds ideal. As a time series database, keeping track of how data evolves over time is InfluxDB's whole thing, Grafana or similar would be for visualizing said data. I guess the complicated part would be getting your data sources to write to it in a convenient way, not sure if there's a generic enough project out there already.
Looking around a bit, not too dissimilar to what this blog post has done.

[–] Sticky@lemmy.world 3 points 1 year ago

Thanks for the suggestions. At a quick glance, grafana looks to be perfect for the visualization aspect (at least in terms of capabilities). Glad to see there are free utilities for that and I might not have to resort to chicken scratch html/pyplot :-) I have yet to dig into influxDB still...

[–] balance_sheet@lemmy.world 3 points 1 year ago (2 children)

Honestly, I think using more than Excel for this might be an overkill.

[–] andrew@lemmy.stuart.fun 3 points 1 year ago

I'm not here on self-hosted for underkill 😉

[–] Sticky@lemmy.world 1 points 1 year ago* (last edited 1 year ago)

I've never liked dealing with excel for anything other than manual work. It's data integrations have grown beyond my familiarity, and I've never liked any of the python libraries I've used for reading and writing excels formats. Go accessible with something like CSV, and you lose most things of value that excel can offer.

Currently though, this is my strategy. I've got folders of Excel sheets that I manually add exports of various things to, but I'm missing the piece that ties it all together, and I'd sure love to do less of the work manually.

[–] styx@lemmy.world 1 points 1 year ago

Nextcloud notes support markdown. It may be a starting point.

load more comments
view more: next ›