Decide what database we want
LiteDB would be the easiest to implement.
Oracle would be the easiest to create more database functionality.
LiteDb
pros
*Single file download (no server needed to run)
*Implemented with c#
cons
*All Database transactions are made through code
*More difficult if we want to add triggers/constraints/etc.
*No UI to interact with
*More difficult to add Procedures
Oracle Db
pros
*UI for interacting with DB
*SQL Code I've used before I can reuse here
* Easier to setup the Database structure and nice visual
cons
* Windows machine (work laptop can do)
* Needs Server to run DB (don't believe running locally would be hard)
Decide what database we want
LiteDB would be the easiest to implement.
Oracle would be the easiest to create more database functionality.
LiteDb
pros
*Single file download (no server needed to run)
*Implemented with c#
cons
*All Database transactions are made through code
*More difficult if we want to add triggers/constraints/etc.
*No UI to interact with
*More difficult to add Procedures
Oracle Db
pros
*UI for interacting with DB
*SQL Code I've used before I can reuse here
* Easier to setup the Database structure and nice visual
cons
* Windows machine (work laptop can do)
* Needs Server to run DB (don't believe running locally would be hard)