= 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

----

[wiki:TechnicalAssessments:persistence_discuss Discussion] (The team decided to go for Sqlite.)