Custom Web Database Apps That I've Built
Nov 30, 2019
The list of apps below are some of the custom web database applications that I've built over the years. Some were in ProcessWire (PHP), some were in Perl, and one was from long ago in Clipper dBASE (included because it processed millions of dollars in invoices over many years).
► Web Help Ticket System
A webhelp ticket system that received input via email and web pages, and allowed attachments. It sent emails out to all the managers and team members listed, and allowed the web department to keep track of requests from editors and company stakeholders.
► Web Domain Management & Account Creation Application
A web domain management and account creation tool for a company that included a script run as root that would create domain accounts across multiple High Availability servers, all automatically (pulling data from a database system). This allowed one to create a web account on multiple servers, with all of the user and Apache settings required, in seconds, versus one hour or more. It also kept track of all of the domains and reduced human error.
► Business Success Analysis Program
An application that allowed users to log in and add business ideas and data that were then run through a series of algorithms to determine if they were good ideas that would bring success or not. The math was done by another person, but I took all those math specs and created the interface to run everything.
► Web Database Framework and Management Application
A web database framework and management application that was used to manage data in MySQL databases, but was also used to create complex web database applications like those below. It contains pre- and post-processing "hooks" to allow all kinds of actions to take place, and is driven by data dictionary and "action" scripts that are unique to each database application, allowing it to be vastly extensible. These are some of the web database applications that I created with the framework:
► Web Discussion Forum
A web discussion forum that used the typical threaded methodology of parents and children.
► MySQL Backup Script
A mysql backup script that won "Unix Tool of the Month," and has been used for many years, by various clients and companies.
► Simple Form Processor
A form processor that also had pre- and post-processing hooks, that could be used to extend functionality.
► Desktop Invoicing System
A desktop invoicing system for a company that used it for ten years and processed millions of dollars in invoices. It was created in Clipper dBASE.
Client TestimoniesHere are some testimonies about my work from clients, as well as work supervisors.
For a complete list, with client names and companies, click the Client Testimonies page.
► “He is truly a valuable asset who can deliver sustainable, efficient and effective operational results.”
► “I have. . .seen firsthand his expert problem-solving and project management skills in action.”
► “He. . .goes the extra mile to make sure the process is complete. He’s logical, clever and thorough. . . . very responsive; extremely knowledgeable; reliable; and a real pleasure to work with.”
► “Peter is a rare combination of talent, competence and responsibility. My only regret is that I did not find him sooner!”
► “We’ve processed millions of dollars in invoices with this program. . . . It has been an enjoyable and trouble-free program.”
► “His integrity and professionalism are rare commodities these days. I have no compunctions in highly recommending him to anyone needing database development.”
► “His calm demeanor, quick understanding of our business issues and high technical competence were key. . .He's smart, reliable and extremely competent (plus an all-around nice guy). He's a pleasure to work with, and will be an important asset to anybody looking to upgrade their digital team.”