{"action":"created","issue":{"url":"https://api.github.com/repos/TotalFreedom/TotalFreedomMod/issues/411","labels_url":"https://api.github.com/repos/TotalFreedom/TotalFreedomMod/issues/411/labels{/name}","comments_url":"https://api.github.com/repos/TotalFreedom/TotalFreedomMod/issues/411/comments","events_url":"https://api.github.com/repos/TotalFreedom/TotalFreedomMod/issues/411/events","html_url":"https://github.com/TotalFreedom/TotalFreedomMod/issues/411","id":54674335,"number":411,"title":"MySQL Branch","user":{"login":"Wild1145","id":2974377,"avatar_url":"https://avatars.githubusercontent.com/u/2974377?v=3","gravatar_id":"","url":"https://api.github.com/users/Wild1145","html_url":"https://github.com/Wild1145","followers_url":"https://api.github.com/users/Wild1145/followers","following_url":"https://api.github.com/users/Wild1145/following{/other_user}","gists_url":"https://api.github.com/users/Wild1145/gists{/gist_id}","starred_url":"https://api.github.com/users/Wild1145/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Wild1145/subscriptions","organizations_url":"https://api.github.com/users/Wild1145/orgs","repos_url":"https://api.github.com/users/Wild1145/repos","events_url":"https://api.github.com/users/Wild1145/events{/privacy}","received_events_url":"https://api.github.com/users/Wild1145/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TotalFreedom/TotalFreedomMod/labels/Enhancement","name":"Enhancement","color":"009800"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-01-17T20:37:15Z","updated_at":"2015-01-22T22:20:48Z","closed_at":"2015-01-20T17:54:10Z","body":"Mainly for a project I am hoping to run that will depend on TFM, it would be nice if TFM had a more extensive use of MySQL, even if it was on its own branch. This is mostly so I dont have to edit TFM and have conflict issues and may help others in the future, but I just wanted to find out how feasible this would be as a setup. "},"comment":{"url":"https://api.github.com/repos/TotalFreedom/TotalFreedomMod/issues/comments/71111139","html_url":"https://github.com/TotalFreedom/TotalFreedomMod/issues/411#issuecomment-71111139","issue_url":"https://api.github.com/repos/TotalFreedom/TotalFreedomMod/issues/411","id":71111139,"user":{"login":"JeromSar","id":1307863,"avatar_url":"https://avatars.githubusercontent.com/u/1307863?v=3","gravatar_id":"","url":"https://api.github.com/users/JeromSar","html_url":"https://github.com/JeromSar","followers_url":"https://api.github.com/users/JeromSar/followers","following_url":"https://api.github.com/users/JeromSar/following{/other_user}","gists_url":"https://api.github.com/users/JeromSar/gists{/gist_id}","starred_url":"https://api.github.com/users/JeromSar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JeromSar/subscriptions","organizations_url":"https://api.github.com/users/JeromSar/orgs","repos_url":"https://api.github.com/users/JeromSar/repos","events_url":"https://api.github.com/users/JeromSar/events{/privacy}","received_events_url":"https://api.github.com/users/JeromSar/received_events","type":"User","site_admin":false},"created_at":"2015-01-22T22:20:48Z","updated_at":"2015-01-22T22:20:48Z","body":"@WickedGamingUK There's virtually no limitations of using SQLite. The process is exactly the same except that data is transferred directly from the application to the file, completely bypassing the network step thus being more speedy. Additionally, there's less endpoints of failure (SQL server might be down, connection issues, connection timeouts, etc). Lastly, we'd have to find an offsite host for our SQL database, which might cost money and drastically reduce performance.\r\n\r\nAnother import aspect to consider is transfer speed. Because SQLite databases are hosted locally, it's latency is nearly negligible. This allows SQLite operations to be executed on the primary thread. If the database would be hosted offsite, this would introduce such a significant increase of latency that all SQL operations would have to be executed on a separate thread, both decreasing performance and app complexity (remember that events and commands have less than one tick to execute).\r\n\r\nAll in all, it's not worth the hassle nor does it provide any significant benefit for TFM."}}