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