undefined | Better HN

story

0 pointsjoeconway12y ago0 comments

I really feel your pain. The reason why I love this meter so much is that it doesn't require a £50 USB cable (The usb is built into the meter) the proprietry software is a standalone jar on the USB device which is amazingly quite good. But best of all when you plug the USB device in it mounts as removable storage with a db.sqlite file which is easily accessible and a simple .dump reveals the sensible DB schema. It's really refreshing to be able to get my data and do what I want with it.

0 comments

morganherlocker12y ago

Thanks for the tip. I will buy this and try it out, open sourcing any scripts I can write that will assist in the extraction. Do you know of any existing tools?

pjscott12y ago

If it's a sqlite database with a reasonable schema, you can probably get a surprising amount of mileage out of a few simple SQL queries and this command-line tool:

https://www.sqlite.org/sqlite.html

In particular, the CSV output mode could be handy for getting query results into other programs.

omh12y ago

Seconding the recommendation. I have this meter for the same reason.

You need to use the Bayer software to talk to it (I'd recommend actually installing the software rather than using the copy from the meter itself). But then the readings are stored in a standard sqlite database without any obfuscation etc. It uses some sort of hash so you can't actually modify things, but for just getting the raw numbers I didn't have any trouble.

j / k navigate · click thread line to collapse