Architecture Database Access

Jump to bottom

Sam Richard edited this page Aug 16, 2016 · 1 revision

Database Access

Holmes will need to interact with a database.

Requirements

Retrieve content based on Global Unique ID (GUID)
Translate input plugin schema to DB engine
Save content to database based on content/schema matching in input plugin
Remove entries based on GUID
Update entries based on GUID

TODO

Flesh out DB requirements
Compare and contrast existing DB options. Open SQL or noSQL
- Ease of setup
  - on a server
  - locally
- Existing Node modules for interactions
  - popularity
  - user base
  - features available
research
- local dev setup
  - sqlite
  - how to ship db for local dev?
- production
  - postgres