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!

    • Sticky@lemmy.worldOPEnglish
      1·
      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.