Show threadSteve DuncanFeb 11
Another project I’m trying to get running is https://github.com/tcgoetz/GarminDB, also on Github, and it downloads #garmin watch data to a SQLite database. I have a comprehensive set of dashboards (I’m a data junky) based on this sort of data, and I'd love to have it load automatically. Unfortunately, I use #Tableau, and it doesn't talk to SQLite, so I'm trying to get the project to run using #Postgres. Not quite there yet, but making progress. #garmindb
卡拉今天看了什麼Feb 4, 2025

GitHub - tcgoetz/GarminDB: Download and parse data from Garmin Connect or a Garmin watch, FitBit CSV, and MS Health CSV files into and analyze data in Sqlite serverless databases with Jupyter notebooks.

Link📌 Summary:
GarminDB 是一套用於解析健康數據並操作 SQLite 資料庫的 Python 腳本。這些腳本能自動下載用戶在 Garmin Connect 的每日監測文件，提取睡眠、體重、靜息心率等數據，並將其存入資料庫。用戶可透過命令行或 Jupyter Notebook 圖表化資料，也能將活動數據匯出為 TCX 文件。此外，GarminDB 支援插件功能以擴展數據處理範圍，並透過版本管理保持資料庫更新。

🎯 Key Points:
- GarminDB 自動下載 Garmin Connect 的每日監測和活動文件。
- 提取並存儲睡眠、體重、靜息心率等數據為 JSON 檔案。
- 提供每日、每週、每月及每年的數據總結。
- 支援使用 Jupyter Notebook 進行數據分析與圖形化呈現。
- 透過插件擴展數據類型，支援第三方 Connect IQ 應用程式。

🔖 Keywords:
#GarminDB #SQLite #數據分析 #健康數據 #Python

GitHub - tcgoetz/GarminDB: Download and parse data from Garmin Connect or a Garmin watch, FitBit CSV, and MS Health CSV files into and analyze data in Sqlite serverless databases with Jupyter notebooks.

Download and parse data from Garmin Connect or a Garmin watch, FitBit CSV, and MS Health CSV files into and analyze data in Sqlite serverless databases with Jupyter notebooks. - tcgoetz/GarminDB

GitHub