Orchard Recovery Custom Proprietary Database

Design of Custom Proprietary Database for Orchard Recovery Center, built with PHP, HTML, SCSS, JavaScript, MySQL.

This site provides Orchard Recovery Center with a custom MySQL database that gives staff access to information about current and past clients, online training resources (including reminders when they are due), maintenance requests, human resource documents, staff scheduling, staff vacations and so much more.

Over the last years the project has evolved

• From HTML, CSS, jQuery, PHP performing MySQL database queries.
• To PHP generated HTML, SCSS compiled to CSS, JavaScript, PHP performing MySQL database queries.
• To PHP/JavaScript generated HTML, SCCS compiled to CSS, PHP performing MySQL database queries through custom API and returning the results through JSON allowing the JavaScript to update the page.

At the current moment I’m in the process of moving the entire application to an Astro application using Drizzle ORM to dynamically populate results using Server Islands. This is the constant continous improvement to enhance security and speed of the system.

In addition to staff interrogating the database to view/update results, I have implemented several Raspberry Pi kiosk applications to display client schedules, weather and information video’s at various locations around the facility.