Hi, After successfully using SQLite on an embedded device, we are now thinking of using SQLite in a PC application.
This would be used in place of an MS Access database on a local/network disk. I believe that SQLite should be quicker for both transactions and queries than Access. The one draw back that comes to mind maybe portability (i.e. accessing data outside of the application), although the data would be portable across machines (PC, Mac, Unix, etc) should we ever need it to be in the future. Is there any webpage, or does anyone have any information comparing the benefits of the two. I can only find comparisons between MySQL and PostgreSQL. This information would aid us greatly in deciding whether to use SQLite or stick with Access. Any help/advice will be gratefully received. Mark DISCLAIMER: This information and any attachments contained in this email message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return email, and delete the original message immediately.
