I do have to agree with this. I was in a similar situation and had to use sqlite (due to size constraints) as a backend for a php site. The locks make it very problematic for multiple processes to access.
-Jason //------------------------------// Jason R. Kretzer Lead Application Developer ja...@gocodigo.com<mailto:ja...@gocodigo.com> //------------------------------// “quidquid latine dictum sit altum videtur" From: André Somers <an...@familiesomers.nl<mailto:an...@familiesomers.nl>> To: "interest@qt-project.org<mailto:interest@qt-project.org>" <interest@qt-project.org<mailto:interest@qt-project.org>> Subject: Re: [Interest] sqlite Bo Thorsen schreef op 17-4-2015 om 13:48: On 04/17/2015 10:25 AM, Graham Labdon wrote: Hi My application makes use of an sqlite database that needs to be shared amongst multiple instantiations of the application. Can anyone please suggest how I can implement this such that if one instantiation of the application updates the database then any other instantiations that are running get notified. You can't do this. There is no mechanism in sqlite to notify other applications that something has changed. You are going to have to implement an IPC system for this. In fact: don't do that at all. Don't use sqlite for simultanious access by several processes. We did (against recommendation of the engineers, management forced a 'quick fix' to get a feature in), and we're still sorry for it. You'll end up in hack-upon-hack to make it sort-of-work, but it is no end of pain and sooner or later will end up in data corruption in your data base. Sqlite is very nice as a small, local, simple database, but it is no replacement for running a real database server. If you need concurrent access by multiple processes, use a database that is built for that kind of thing. MySql, PostgreSql, whatever. André _______________________________________________ Interest mailing list Interest@qt-project.org<mailto:Interest@qt-project.org> http://lists.qt-project.org/mailman/listinfo/interest ----- No virus found in this message. Checked by AVG - www.avg.com Version: 2015.0.5863 / Virus Database: 4331/9540 - Release Date: 04/14/15
_______________________________________________ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
