search

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

Support more DBMSes #42

Closed encratite closed 12 years ago

encratite commented 12 years ago

In particular MySQL is requested a lot. Uhkis also requested PostgreSQL support. This is not that difficult at this point. Just that one query with a view should probably be replaced by the old CTE string for PostgreSQL. Otherwise the current code is fairly portable except for the pragma use that is specific to SQLite.

encratite commented 12 years ago

Partially implemented in:

https://github.com/epicvrvs/RiotControl/commit/4b95fd67cdc362c9fa0e73b98fb52132b57a7901

Haven't added CTE support but made the pragma stuff conditional. In theory it could work with more DBMSes now, I'm just not sure if the temporary view works for that. The next problem is dealing with items. This is still SQLite sepcific syntax.

encratite commented 12 years ago

Added PostgreSQL support: https://github.com/epicvrvs/RiotControl/commit/3f2fcdbc6bb7fda0bde285da49b4742e01e85f73

I think this should do for now. Might add MySQL later.