[SHARE] GAB - Gekko Automated Backtests

[tommiehansen]

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 '�'

google did not turn up anything useful...

You would need to gzip decode it as well since there is not "UTF-8" in this case (it's binary data).