Locals Know is a social travel application for the iOS and Android platforms. We worked on a web-based RESTful API used by the mobile applications to pull data from the server. Much of the structure for the API was already built by a previous developer. However, the existing code base had several outstanding issues. First of all, the database schema did not match the intended design of the app, and there were some other issues. We restructured the database, wrote migrations, modified the API responses, and fixed several other bugs. Beyond bug fixes, we also added additional API end points for new features and helped troubleshoot some issues with the API requests from the iOS application.
As well as dealing with the RESTful API, we built a client-facing web interface to allow users to view this content outside of the native mobile apps. Using the responsive design features in Twitter Bootstrap, we built this web interface to render on desktop web browsers, tablets, and mobile browsers.
In addition, to support this web interface, and the social nature of the app, we built a custom URL shortener system to aid in sharing content via Twitter and Facebook. The URL shortener created compact URLs, uniform in length, with no discernible pattern, guaranteed to be unique.
Partnering with our client, we worked on ongoing basis, managing the database and IT systems for Liquis, an asset management and corporate liquidation company. We built a custom FileMaker application which managed nearly every aspect of the company’s day-to-day operations. This included tracking of incoming trucks, pallets, and assets; automatically importing product photos for online sales, ODBC import/export with MSSQL-based eBay listing tool, Blackthorne; complex financial report generation; and automated pick and shipping systems. We also built a web interface, allowing clients to log in and view complete status of items entrusted to the company in real time. During this project, we used FileMaker Pro, PHP, MySQL, MS SQL, eBay Blackthorne, ODBC, rsync, Groovy, UPS Shipping XML API, Java printing APIs, among others technologies.