MySQL

MySQL is a database software that stores and retrieves website data in an efficient way. Content management systems rely on MySQL for nearly everything they do. Similarly, we rely on this database management as we design and build custom web applications and functionality for our clients.

WalletCard Certification Management WordPress Extension

  • Agency Partner: 12th Street Consulting
  • Year(s): 2015
WalletCard offers a novel way for employers to issue certifications to employees who have completed coursework or training modules and proven their ability to perform certain tasks or jobs. After creating a business profile, employers can create certifications for any number of learning requirements, and once an employee has achieved the proper qualifications, certifications can be assigned to the employee. The employee also visits their account and verifies the certificates that have been granted them. Our agency partner 12th Street Consulting commissioned us to assist in building out the client’s website to perform these functions. Together we created a prototype which extended Wordpress's user model with a more complex structure, and built a custom theme that extended WordPress functionality.

T-Mobile Data Collection and Processing

  • Agency Partner: Blue Sky Projects
  • Year(s): 2007
After having worked on several projects with Marc Rapport of Blue Sky Projects, we were invited to participate in a project for our biggest “name” client--an enterprise client. T-Mobile’s testing department were making use of robotics to perform tasks on handsets, but the data set returned was indecipherable. The client’s senior engineers weren’t inclined to write a middle-tier application, so we stepped in. We placed two developers on-site for three weeks to work in a classified wing of their Bellevue campus headquarters. We built an internal application to collect the data in a database, and then sort and filter that data to display it in a more useful way, complete with search capability. We then set up a local WAMP server to allow them to run the app locally.

Encore Capital SugarCRM Loan Processing

  • Agency Partner: Blaze Enterprises
  • Year(s): 2008-2012
In 2008, Blaze Enterprizes approached us with a project for Damon Maletta from Encore Capital, who was finding success in Restaurant micro-loans. Damon needed one place to control his sales channel, his accounts, and his contract flow, and also wanted a better website presence to attract new business and educate customers. We constructed a backend built on top of SugarCRM that managed all aspects of the loan underwriting process (status, documents, communications, credit) and a Wordpress site for his web presence that would interface with his backend platform.

Truck-Lite Drupal Conversion

  • Agency Partner: Sirius
  • Year(s): 2016
Truck-Lite is a producer of LED safety lighting, forward lighting, wiring harnesses and other lighting solutions for trucks; and Sirius was tasked with their website redesign. Twelve23 was contracted to complete the content management system in Drupal to complement the site's eCommerce platform. The work involved setting up the web servers, creating a Drupal template, and adding custom functionality to Drupal for ease of use with Truck-Lite's specific content needs.