I am investigating which would be the most appropriate RDMS to use for a new Intranet based application. I have rounded down my choice to two candidates - SQLite and MySQL.
The application needs to be available to about twenty users on a daily basis, with most of those users making no more than five 'write' transactions a day, and around twenty 'read' transactions a day. Depending upon its success the application may well develop to incorporate other datasets and users - so the RDMS needs to be able to develop without difficulty. IMHO SQLite looks as though it would be the fastest to develop and with the least resources required but after reading some SQLite documentation: "A good rule of thumb is that you should avoid using SQLite in situations where the same database will be accessed simultaneously from many computers over a network filesystem." I am concerned that even though I expect light usage it is likely that multiple users will access the same database concurrently. Would I be correct in assuming that MySQL is a safer (longterm) bet? Thanks for any and all responses Len -- View this message in context: http://www.nabble.com/Most-appropriate-Web-based-database-%28Newbie%29-t1404628.html#a3780531 Sent from the SQLite forum at Nabble.com.
