Various projects I have completed outside of work. If you have any questions please get in touch.
- Create new job application
- Search job applications over any field
- Edit existing job applications
- Create a report showing job applications over a time period (required as proof of seeking work)
- Configuration options – number of items on the summary page and width of columns
- Application tracking sparkline-like graph on each page
- Create new blog post (news item)
- Edit existing blog post
- Delete previous blog post
- Blog entry editor with HTML tag insertion and preview function
- Optionally Tweets when a new entry is created.
- Current Cost power consumption meter data published to iPhone. Using Perl, RRDTool and iWebKit.
- Network connected temperature sensor. Using Arduino, MQTT and Perl.
- Waterrower S4 monitor data logger. Using Perl and MySQL.
- Waterrower S4 data output to Excel spreadsheet. Using a Perl.
I have created a job application-tracking database for use at home. The system is built with PHP and with a backend database using MySQL and is hosted on a RaspberryPi. Overall it has taken around three days to complete.
The summary page shows a user defined number job applications, with the newest at the top and the oldest at the bottom. Each application has a unique ‘ID’, which in this summary view provides a link to the editing option. The ‘role’ column provides a URL to the job application details on the relevant web site on which the role was advertised. Finally the ‘contact email’ column presents a ‘mailto’ link for the contact person at the advertising agency.
Each job application record contains some 16 fields. Including a status field and an optional ‘Follow up’ flag, used to indicate particularly interesting roles.
I produced a brief video showing the database in action – this was created before the system was finished.
If you have any questions please let me know.