Databases - Which to choose for PHP-Based Stock System
Posted: Wed May 13, 2009 6:10 am
Hello all,
I am currently re-designing a stock system for a client. At the moment it is saving records into tabloes using PHP MyAdmin in WAMP Server 2.0.
Is this a feasible way of storing records or would another approach such as using separate .sql or .db files be better? The program runs locally on the clients machine so security is not much of a problem.
Another question while I think about it: is it better to use the mail() function to handle outward emails such as stock reports, or would it be more efficient to use the PEAR libraries? I know the differences between the 2 approaches but not the advantages.
Thanks in advance!
EDIT: Or even as .xml files?
I am currently re-designing a stock system for a client. At the moment it is saving records into tabloes using PHP MyAdmin in WAMP Server 2.0.
Is this a feasible way of storing records or would another approach such as using separate .sql or .db files be better? The program runs locally on the clients machine so security is not much of a problem.
Another question while I think about it: is it better to use the mail() function to handle outward emails such as stock reports, or would it be more efficient to use the PEAR libraries? I know the differences between the 2 approaches but not the advantages.
Thanks in advance!
EDIT: Or even as .xml files?