{"action":"created","issue":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/3242","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/3242/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/3242/comments","events_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/3242/events","html_url":"https://github.com/aspnet/EntityFramework/issues/3242","id":108518005,"number":3242,"title":"SQLite or SQLServer","user":{"login":"angelsix","id":4455939,"avatar_url":"https://avatars.githubusercontent.com/u/4455939?v=3","gravatar_id":"","url":"https://api.github.com/users/angelsix","html_url":"https://github.com/angelsix","followers_url":"https://api.github.com/users/angelsix/followers","following_url":"https://api.github.com/users/angelsix/following{/other_user}","gists_url":"https://api.github.com/users/angelsix/gists{/gist_id}","starred_url":"https://api.github.com/users/angelsix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/angelsix/subscriptions","organizations_url":"https://api.github.com/users/angelsix/orgs","repos_url":"https://api.github.com/users/angelsix/repos","events_url":"https://api.github.com/users/angelsix/events{/privacy}","received_events_url":"https://api.github.com/users/angelsix/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-09-27T06:42:31Z","updated_at":"2015-09-28T15:46:13Z","closed_at":null,"body":"Which do you recommend using on Linux. SQLite, or SQLServer (Mono SQL Client)?\r\n\r\nI am wondering if the full SQLServer will be natively supported within say 6-12 months and its worth me using that for now, or whether SQLite is the better option for linux?\r\n\r\nI expect the database to be fairly sized, nothing mad - likely 20-30 tables, 100,000 to 1,000,000 entries on average. However I would like the best scalable option and if the full SQLServer will be supported fully down the road, I'll start with that. "},"comment":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/comments/143784638","html_url":"https://github.com/aspnet/EntityFramework/issues/3242#issuecomment-143784638","issue_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/3242","id":143784638,"user":{"login":"angelsix","id":4455939,"avatar_url":"https://avatars.githubusercontent.com/u/4455939?v=3","gravatar_id":"","url":"https://api.github.com/users/angelsix","html_url":"https://github.com/angelsix","followers_url":"https://api.github.com/users/angelsix/followers","following_url":"https://api.github.com/users/angelsix/following{/other_user}","gists_url":"https://api.github.com/users/angelsix/gists{/gist_id}","starred_url":"https://api.github.com/users/angelsix/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/angelsix/subscriptions","organizations_url":"https://api.github.com/users/angelsix/orgs","repos_url":"https://api.github.com/users/angelsix/repos","events_url":"https://api.github.com/users/angelsix/events{/privacy}","received_events_url":"https://api.github.com/users/angelsix/received_events","type":"User","site_admin":false},"created_at":"2015-09-28T15:46:13Z","updated_at":"2015-09-28T15:46:13Z","body":"As far as a know, that doesnt have an Entity Framework provider. Also both of the others are cross-platform between Linux/Windows. I'm not sure if PostgreSQL is and I've had no experience with that at all so wouldnt really want to change from SQL Server if possible."}}