This project is to build and setup a web service that stores records in a table (called the Data-Depot)
The client would be able to invoke methods as ADD, UPDATE, FIND and DELETE rows from the depot
Fields to include
Code - Bar code of item, (this is the primary key), Description, price, Category, Date and time a item was added, what client did add the row, date and time updated, what client updated that row, a counter of how many times this row was searched for
On client Side
In order to ADD a row the client would send something like to the server:
action="ADD UPDATE" , client="MY STORE", client password="my_secret_code",
code="12345678901234", Description="Fresh Milk",price="1.23", category="dairy", This would tell the service
a. to see if this client is setup for service (client and client password are found in database on server for access and was right to ADD)
b. search item table if code "12345678901234" was not found in data-depot ADD item to data-depot and return to client "ADDED"
c. if item is found and the action also includes "UPDATE" update data with new data (in real life this update would be a bit more complex like what to add when and we would also have much more fields in the table but for now do a simple update)
d. if client send code="12345678901234", client="MY STORE", client password="my_secret_code",action="FIND" and it is found in the depot then send back code="12345678901234", Description="Fresh Milk",price="1.23"
e. would need also a table to keep track of all actions the services provided for statistic
f. the primary code would need to be indexed for speed purpose
in real life this would be a bit more complex but i'm staring out as a proof of concept
We would also need to track statistics what store was using the service and in what way
Include the words Blue Magic in your offer
I believe MySQL or MSSQL would be the best choice. (My main concern is the speed how fast a FIND of a row could be found and returned, only one row would be asked at a given time but many stores could ask the same time for data).
I have a ARVIXE account that could host the depot and it should be installed there. I also have a cloud based windows 2012 server I would like to have the source code on it and being able to compile. Tell me what tools I would need to have in order to compile the project. I would give you access to that computer
I want to have phpMyAdmin or something similar installed as well in order to be able to administer the database remotely