[RESOLVED] Point Of Sale : DB - MYSQL

[batori]

Hi guys,

I would like to create a POS system for a day store ... but im not quite sure what to do at the back of it ...

Need to load items from a db or mysql, with images, prices, stock number, ecc and being able to manipulate all that ...

So basically im not sure what would be the best way to start all of that....is it by having a DB or a MYSQL connection to all that...


Any advice or guidelines would be greatly appreciated!


Cheers!

[si_the_geek]

I would definitely recommend setting up the database first, as any changes there will affect the code etc, and the changes could easily be big enough to mean it would be better to re-write the program than modify it.

A very important part of setting up the database is planning what the tables will be, and I recommend spending some time thinking carefully about the details of the information you will want to store (eg: should stock number be text or numeric? ...if you are using barcodes or similar, should it be possible to have several of them linked to the same stock number?)

You may find it useful to read some of the articles in the "Design" section of our Database Development FAQs/Tutorials (at the top of the Database Development forum), particularly the one about Normalisation.