Technical Summary
Biltong Production Calculations and Logistics
Description
Biltong is a delicious and nutritious air cured beef snack. This app automates recipe calculations for biltong production. The recipe management page (not accessable with the guest login) is used to easily create and edit recipes. The batch logistics page (not accessable with the guest login) performs calculations associated with batch scheduling, labeling, and tracking to assist in meeting compliance requirements.
Dev Ops
In managing the app development project, I generated a timeline, milestones, goals, and desired feature lists. I then broke these down into coding units to develop. Each of these features passed through an iterative improvement process of coding and testing.
HTML, CSS, and PHP for UI/UX
The app is a web app and is viewed through HTML pages generated using PHP code. Styling is organized into three tiers of CSS files. There is a global theme for my entire website. There is an app specific theme that specifies the styling applicable to multiple pages within the app. Individual pages have a CSS file for any styling intended for that page. The PHP code is used to include the header and footer information and to perform various user authentication checks (see 'Cybersecurity' section below). The app is responsive to mobile and desktop screen widths. The navigation menu is intuitive and snappy.
SQL and Database Admin (Data Engineering / Architecture)
I used SQL extensively throughout the app development process to set up the database tables. The various pages in the app use prepared SQL statements to query the database to generate page content. The database admin tasks associated with designing, implementing and querying the database were certainly some of my favorite parts of the app development process.
The database contains tables for users, pages, sessions, recipes, and production batches.
Statistics and Data Science
I eagerly look forward to posing questions and generating answers that involve math calculations.
Cybersecurity
Data security is an important component of any data management system. The login system authenticates users. User passwords are stored in encrypted form (not plaintext). Sessions are created and logged for each login. The connection between the database server and the client's device (mobile phone or computer) is encrypted via the HTTPS protocol so that data transer cannot be easily read while in transit. All database queries are performed via prepared SQL statements and all form inputs are sanitized before they are used to add robustness against SQL injection attacks. The navigation menu is generated based on the pages that the user's role is granted access to.
Last Updated: 2023-12-12