https://www.wgtn.ac.nz/law/nzlostcases/
Client: Geoff McClay
Document: Upgrade of NZ Lost Cases site Sept 2017.
/wiki/spaces/TD/pages/377716770
Our recommendations/findings
Update database
Create 'views' across the tables
Can run SQL queries
Is on supported ITS DB version
Build an API (Application programming interface)
Creates a service to deliver the data to a web site
Search and retrieve results across defined field
Create filters and pagination across data results
Extensible
Build Web site in a CMS
Easy to maintain and update basic content
More developer support for improvements
Security patches actively maintained
Example of a site using a built for purpose API with a Web site in a CMS