Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/tamain/public_html/_includes/cmsbclass.php on line 124 Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/tamain/public_html/_includes/custclass.php on line 126
This project consists of Web Services, a .Net Windows Application, PHP Website, Mobile Website, iOS App and Android App.
Some history – Deb, the cofounder of TechAnalysts, Inc. is the Guinness World Record holder for the largest Winnie the Pooh and Friends collection in the world. As such, we have everything stored in a database. But, like so many other things that start out as personal pet projects, the database was put together using Microsoft Access with a quick data entry screen and data tables, but really nothing else thought through. For example, there is no reporting capability in the system and there is no access to the data from outside of the walls of our home and office.
With over 7,000 unique items in the database, we thought it may be time to have access to the data from outside our network.
This series of postings will go through the process as we develop this complete system for Deb. Keep in mind that this is a personal project, but includes many aspects of development that we do for clients, so we thought this would make a great case study.
Because it's a personal project, however, it will always take a back seat to our client work, therefore it may be a while before we get through all the pieces of this project.
First, we needed to discuss what we wanted to accomplish. We came up with the following goals:
Based on the above goals, we determined that utilizing a web service to attach to the data would be our best route – this allows all of these disparate systems to get to the data without having to have multiple copies of the data lying around and without having to worry about compatibility across data access layers.
Our next post will examine the web service and how we develop that service.
In the meantime...
* photography by Journal/Sentinal's photographer, Michael Sears