Hi Ken,
Here's a couple of things you may want to consider.
If the database is to be used by more than one concurrent user at a time, then you will need record locking and perhaps transaction capablity as well (rollbacks, etc.). In this case, SQLite is out of the question as it's strictly a single user solution.
MySQL or PostgreSQL will both work fine. Here's a couple of Pro's/Con's for them:
1) MySQL is not really a 'free' solution. If you are creating a commercial product, you need to pay for it. See their website for details.
2) MySQL has probably better support and more online tutorials as it's more used.
3) PostrgreSQL works well and is free, but doesn't have 'native' RevDB support...IOW, you'll need to use the ODBC connector to get it working, and I'm not too sure how easy that is. You could check with Trevor or Pierre for more information.
All 3 databases (MySQL, SQLite, PostgreSQL) have a great following and have literally thousands of installations and helpful users.
HTH,
Chipp
Ken Ray wrote:
Hey, everyone, I need some database advice (or suggestions).
_______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
