(04-20-2018, 01:41 AM)tommiehansen Wrote: Yes, it's a db and the blobs are gzipped (try running 10 000 runs for 2+ years of data and check the db size) and thus not that easily readable through ordinary db management software.
You could however use the db as is and then write a script that does everything you're talking about. It's a simple db, it doesn't care how you use it or from where. :-)
Thank you very much for your reply.
I have to admit I don't get how I could use the db "as-is". Could you point me to the code in GAB that uses the db so I can see how the blobs are taken out of the db? Or any other general pointer as to how I would go about doing that? Thank you very much.
Edit: I tried to do this with
Code:
import sqlite3
import zlib
db = sqlite3.connect('gab_kraken.db')
rows = db.execute('select * from results')
but python tries to convert to text and fails horribly:
Code:
sqlite3.OperationalError: Could not decode to UTF-8 column 'strat' with text '�'