Technical Assessment - Data persistence

Flat File System

Pros:

• When organized well, it's easier to copy a patient records to another storage device.
• No extra application is needed to act as interface to the data.

Cons:

• Need to custom-build modules for complex query's / searches and file IO.

SQLLite

Pros:

• embeddable; xulrunner currently uses sqlite to store records
• no port-conflict because it is not a server

Cons:

• function names may change; (project impact medium. object-oriented coding is the remedy.)

MYSQL

Pros:

• robusts and handles advance sql features over SQLLite

Cons:

• heavier than SQLLite, due to numerous features
• port-conflicts may happen if used in a computer with running mysql
• requires a server and medium memory footprint
• an export module need to be created to transfer data

---

Discussion (The team decided to go for Sqlite.)