Feeling a little bad, two questions from you guys in a week!
So I am about to embark on a project including Point of Sale, Inventory Management, Client management, (quite in depth).
The difference is any information regarding Clients will be stored locally throughout the day and then uploaded to external servers allowing any customer to access an up to date online account of their purchases.
The current competitors use .mdb files to store their data, which is fine, but we would prefer to use MySQL (or possibly PostgreSQL if that's how you spell it). Is it possible to create a solid file and run a MySQL database from it? Like StoreDB.MYSQL?
And also, if there are going to be 5 computers all accessing the one database through the network in the store, is running from a file the best way to go? Or would it be better to run some sort of server on the host computer and access that from the slaves?
Any thoughts?