encratite / RiotControl

An elaborate statistics tracking system for League of Legends. It used to be a centralised PostgreSQL based system but now it's a stand-alone SQLite application. It was written in C# and makes use of the LibOfLegends RTMP library. It is licensed under the terms of the GPLv3. Unfortunately I stopped working on it in 2013-08. Check out the website for a longer explanation.
http://riot.cont.ro.lt/
GNU General Public License v3.0
33 stars 15 forks source link

SQLite locking issue #81

Open encratite opened 11 years ago

encratite commented 11 years ago

SQLite will often result in simultaneous queries to fail, with the driver throwing an exception saying "database locked". This really shouldn't happen. I'm pretty close to just dumping SQLite entirely, because it's just that terrible. A workaround... which might make the system even slower... would be using mutexes for queries, which is absolutely outrageous.