Dump to SQLite database

57 views
Skip to first unread message

Robert Kosara

unread,
Mar 17, 2010, 9:39:16 PM3/17/10
to FitBit Developers
Hi,

this is great work! I don't know what's taking so long for them to
release an API, but this is a great stop-gap. I've used the API to
download all my data since I got it towards the end of October last
year, works great.

I've cloned the repository and added a little script that dumps the
data into a sqlite database rather than CSV files. It takes the
filename for the database (SQLite works on a single, self-contained
file) from the config file. It's set up so it can be run for the same
day repeatedly and will add data as it's being added (because you
might not sync your fitbit all the time or even every day). It also
calculates daily sums for easier plotting of longer periods.

My clone is here: http://github.com/eagereyes/python-fitbit


Best,

Robert

Wade Simmons

unread,
Mar 18, 2010, 1:30:46 AM3/18/10
to FitBit Developers
On Mar 17, 7:39 pm, Robert Kosara <rkos...@gmail.com> wrote:
> this is great work! I don't know what's taking so long for them to
> release an API, but this is a great stop-gap. I've used the API to
> download all my data since I got it towards the end of October last
> year, works great.

Awesome. I'm glad to see someone else has tried the code and it's
working out for them.

> I've cloned the repository and added a little script that dumps the
> data into a sqlite database rather than CSV files. It takes the
> filename for the database (SQLite works on a single, self-contained
> file) from the config file. It's set up so it can be run for the same
> day repeatedly and will add data as it's being added (because you
> might not sync your fitbit all the time or even every day). It also
> calculates daily sums for easier plotting of longer periods.
>
> My clone is here:http://github.com/eagereyes/python-fitbit

Dumping to SQLite is a great idea; thanks for implementing it! If you
don't mind, I'll go ahead and merge your script upstream to make sure
other people can find them. I'm sure other people would love the data
in SQLite (I know I'll start using it).

Thanks,

Wade

Robert Kosara

unread,
Mar 18, 2010, 8:01:28 AM3/18/10
to fitbit-d...@googlegroups.com
Absolutely! I've sent you a pull request.
Reply all
Reply to author
Forward
0 new messages