{"action":"created","issue":{"url":"https://api.github.com/repos/roundware/roundware-server/issues/184","labels_url":"https://api.github.com/repos/roundware/roundware-server/issues/184/labels{/name}","comments_url":"https://api.github.com/repos/roundware/roundware-server/issues/184/comments","events_url":"https://api.github.com/repos/roundware/roundware-server/issues/184/events","html_url":"https://github.com/roundware/roundware-server/issues/184","id":47766734,"number":184,"title":"Change Roundware Database system?","user":{"login":"eosrei","id":195061,"avatar_url":"https://avatars.githubusercontent.com/u/195061?v=3","gravatar_id":"","url":"https://api.github.com/users/eosrei","html_url":"https://github.com/eosrei","followers_url":"https://api.github.com/users/eosrei/followers","following_url":"https://api.github.com/users/eosrei/following{/other_user}","gists_url":"https://api.github.com/users/eosrei/gists{/gist_id}","starred_url":"https://api.github.com/users/eosrei/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eosrei/subscriptions","organizations_url":"https://api.github.com/users/eosrei/orgs","repos_url":"https://api.github.com/users/eosrei/repos","events_url":"https://api.github.com/users/eosrei/events{/privacy}","received_events_url":"https://api.github.com/users/eosrei/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/roundware/roundware-server/labels/blocker","name":"blocker","color":"fbca04"},{"url":"https://api.github.com/repos/roundware/roundware-server/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/roundware/roundware-server/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2014-11-04T21:20:48Z","updated_at":"2015-03-16T18:27:54Z","closed_at":null,"body":"Roundware Server is currently using MySQL, but there has been discussion about changing database systems. If we are going to make a drastic change, such as the database system, is ideal to do it now since we *probably* know of all existing installations. It'll be much easier to make the change now since it won't need to be so thoroughly documented and tested.\r\n\r\nOther database options:\r\n* MariaDB\r\n* PostGreSQL\r\n* Mongo? Couch? SQLite?!\r\n\r\nIt seems to me that PostgreSQL is probably the best option since it will/should make it far easier to support #98 plus all other GIS related features. A database converter: https://github.com/lanyrd/mysql-postgresql-converter Lots of discussion: http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL\r\n\r\n "},"comment":{"url":"https://api.github.com/repos/roundware/roundware-server/issues/comments/81855379","html_url":"https://github.com/roundware/roundware-server/issues/184#issuecomment-81855379","issue_url":"https://api.github.com/repos/roundware/roundware-server/issues/184","id":81855379,"user":{"login":"probabble","id":3421159,"avatar_url":"https://avatars.githubusercontent.com/u/3421159?v=3","gravatar_id":"","url":"https://api.github.com/users/probabble","html_url":"https://github.com/probabble","followers_url":"https://api.github.com/users/probabble/followers","following_url":"https://api.github.com/users/probabble/following{/other_user}","gists_url":"https://api.github.com/users/probabble/gists{/gist_id}","starred_url":"https://api.github.com/users/probabble/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/probabble/subscriptions","organizations_url":"https://api.github.com/users/probabble/orgs","repos_url":"https://api.github.com/users/probabble/repos","events_url":"https://api.github.com/users/probabble/events{/privacy}","received_events_url":"https://api.github.com/users/probabble/received_events","type":"User","site_admin":false},"created_at":"2015-03-16T18:27:54Z","updated_at":"2015-03-16T18:27:54Z","body":"I haven't... how many deployments need to be migrated?\n\nOn Mon, Mar 16, 2015 at 11:25 AM, Brad Erickson <notifications@github.com>\nwrote:\n\n> @probabble <https://github.com/probabble> I see you are working on this\n> process. Have you looked into the data conversion options?\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/roundware/roundware-server/issues/184#issuecomment-81854517>\n> .\n>\n"}}