search

desytech / kubot

Lendbot for Kucoin
GNU General Public License v3.0
2 stars 2 forks source link

Introduce database persistence #12

Closed desytech closed 3 years ago

desytech commented 3 years ago

We want to be able to store several market or historical data in a database. We want to access the database entities via ORM. The database framework should support migrations. We should also discuss which database type is most appropriate for this use case.

desytech commented 3 years ago

ORM Evaluated peewee ORM like the SQLite integration combined with the performance, schema migration and JSON SQLite extension. If we use SQLite or some kind of other embedded database systems we have to share it via docker volume mount. http://docs.peewee-orm.com/en/latest/peewee/playhouse.html?highlight=migration#schema-migrations http://docs.peewee-orm.com/en/latest/peewee/sqlite_ext.html#sqlite-json1

Visualization I like to analyze the collected data with Grafana in the future. Unofficial SQLite Extension available here: https://github.com/fr-ser/grafana-sqlite-datasource. More evaluation necessary.