Wednesday, January 11, 2006
Mediaspot's IMS Go Live
MediaSpot’s Inventory Management and Sales System go live. It did run with a couple of errors. LOL… It’s really different when you are the one who develop and at the same time doing the testing. I’m glad that it was my cousin’s store there was not too much pressure when the errors pop up. LOL.. Right now, I managed to finish all the bugs that were found.
There was a little delay on the time frame of the deployment of the project due to the fact that I was using CSLA .NET rather than doing in using datasets. I know that doing it datasets will give me the speed in development, but I wanted it to be in object oriented approach in dealing with the business process and another reason is that I’m a fan of Rockford Lhotka. LOL…
For the backend I was using MySQL latest version to take advantage with stored procedures, views and triggers. Why not MS-SQL? I guess the reason is clear MySQL is for free. =) But when I’ve found out the SQL 2005 Express is for free, it was too late because I was halfway doing it in MySQL. So my plan later is to create a database in SQL 2005 Express and modify the application to choose what type of backend database server to use.
I have no regrets using MySQL, at least I did have a chance to know SQL syntax in MySQL. The shift from MS-SQL to MySQL during developing the stored procedures wasn’t that hard. I’ve found some bugs in MySQL and I’ll be sending it MySQL to clarify if is really a bug or the feature is not supported.
MediaSpot is a store the sales a variety gadgets for cell phones, computers, digital cameras, DVD and MP3 players. It is located on JQS, which is beside UC Banilad Campus.