Migrate Away from SQL to MongoDB or Riak
SQL has plagued this project from the beginning. Let's to the popular thing, and ditch it.
Blueprint information
- Status:
- Started
- Approver:
- Duncan McGreggor
- Priority:
- High
- Drafter:
- None
- Direction:
- Approved
- Assignee:
- Duncan McGreggor
- Definition:
- Approved
- Series goal:
- None
- Implementation:
-
Good progress
- Milestone target:
- None
- Started by
- Duncan McGreggor
- Completed by
Related branches
Related bugs
Sprints
Whiteboard
Work items:
[oubiwann] Evaluate python asynchronous clients for riak and mongodb: DONE
Perform rough benchmarks of riak and mongodb via their async clients: WONTDO
* MongoDB wins due to maturity and ease of install and setup.
* we can always add support for additional nosql DBs in the future
[oubiwann] read through this page: http://
[oubiwann] remove mysql references: DONE
[oubiwann] remove mysql dependency: DONE
[oubiwann] remove pysqlite references: DONE
[oubiwann] remove sqlite dependency: DONE
[oubiwann] create documents for the current SQL schemas: DONE
* these have been converted to .yaml files now.
* from these, they can be loaded (as dict data), converted to JSON, and dumped into MongoDB
[oubiwann] add a mongodb backend for pymon: INPROGRESS
create unit tests for this (that don't touch any external systems): TODO
create integration tests that actually hit a mongodb instance: TODO
Work Items
Dependency tree
* Blueprints in grey have been implemented.
