Database framework for sql queries, execute and rollbacks In database management, it’s useful to define atomic blocks. And let’s say if something fails within this block, you can always revert to the initial state before any of the transaction happens.
Below is a nifty framework,
Execute the query while not changing the state in the database. If there’re any errors along within the atomic block, you capture the error under exception area.
Setting up a database for my Jarvis As I run more sophiscated trading strategies, I require a proper database for training parameters and records.
Previously, I was using a mix of SQLite, RDA and CSV files - but going forward I will be using Mysql (workbench) to house my data.
Below is an example of database tables for my market neutral strategies. I will be using these tables for the following,