{"action":"created","issue":{"url":"https://api.github.com/repos/savoirfairelinux/sous-chef/issues/353","repository_url":"https://api.github.com/repos/savoirfairelinux/sous-chef","labels_url":"https://api.github.com/repos/savoirfairelinux/sous-chef/issues/353/labels{/name}","comments_url":"https://api.github.com/repos/savoirfairelinux/sous-chef/issues/353/comments","events_url":"https://api.github.com/repos/savoirfairelinux/sous-chef/issues/353/events","html_url":"https://github.com/savoirfairelinux/sous-chef/issues/353","id":171924266,"number":353,"title":"Replace MariaDB by PostgreSQL","user":{"login":"erozqba","id":9809143,"avatar_url":"https://avatars.githubusercontent.com/u/9809143?v=3","gravatar_id":"","url":"https://api.github.com/users/erozqba","html_url":"https://github.com/erozqba","followers_url":"https://api.github.com/users/erozqba/followers","following_url":"https://api.github.com/users/erozqba/following{/other_user}","gists_url":"https://api.github.com/users/erozqba/gists{/gist_id}","starred_url":"https://api.github.com/users/erozqba/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/erozqba/subscriptions","organizations_url":"https://api.github.com/users/erozqba/orgs","repos_url":"https://api.github.com/users/erozqba/repos","events_url":"https://api.github.com/users/erozqba/events{/privacy}","received_events_url":"https://api.github.com/users/erozqba/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/savoirfairelinux/sous-chef/labels/database","name":"database","color":"d93f0b"},{"url":"https://api.github.com/repos/savoirfairelinux/sous-chef/labels/question","name":"question","color":"cc317c"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2016-08-18T15:06:02Z","updated_at":"2016-09-12T16:39:53Z","closed_at":null,"body":"I was trying to update the project to the version 1.10 of Django and I get a warning about the configuration of the MySQL server and a link to this part of the documentation: \r\n\r\n> WARNINGS:\r\n?: (mysql.W002) MySQL Strict Mode is not set for database connection 'default'\r\n        HINT: MySQL's Strict Mode fixes many data integrity problems in MySQL, such as data truncation upon insertion, by escalating warnings into errors. It is strongly recommended you activate it. See: https://docs.djangoproject.com/en/1.10/ref/databases/#mysql-sql-mode\r\n\r\nI really don't like the part \"... data truncation upon insertion ...\" but this was not the only thing that made me think in replacing MariaDB by PostgreSQL. We are storing JSON in the database and we are using an application for only that \"django-annoying\" but we have the possibility to use a JSONField of Django if we use PostgreSQL https://docs.djangoproject.com/en/1.10/ref/contrib/postgres/forms/#jsonfield \r\n\r\nI decided to try the project with PostgreSQL instead of MariaDB and I had an issue with SQLAlchemy, so I ask the question on Monday, august 8th, on the #feastproject IRC (there is already another issue #339 to talk about use SQLAlchemy or not.)\r\n\r\nI would like to get your opinions about the advantages or disadvantages of using PostgreSQL or MariaDB.  Thanks in advance!\r\n"},"comment":{"url":"https://api.github.com/repos/savoirfairelinux/sous-chef/issues/comments/246408539","html_url":"https://github.com/savoirfairelinux/sous-chef/issues/353#issuecomment-246408539","issue_url":"https://api.github.com/repos/savoirfairelinux/sous-chef/issues/353","id":246408539,"user":{"login":"erozqba","id":9809143,"avatar_url":"https://avatars.githubusercontent.com/u/9809143?v=3","gravatar_id":"","url":"https://api.github.com/users/erozqba","html_url":"https://github.com/erozqba","followers_url":"https://api.github.com/users/erozqba/followers","following_url":"https://api.github.com/users/erozqba/following{/other_user}","gists_url":"https://api.github.com/users/erozqba/gists{/gist_id}","starred_url":"https://api.github.com/users/erozqba/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/erozqba/subscriptions","organizations_url":"https://api.github.com/users/erozqba/orgs","repos_url":"https://api.github.com/users/erozqba/repos","events_url":"https://api.github.com/users/erozqba/events{/privacy}","received_events_url":"https://api.github.com/users/erozqba/received_events","type":"User","site_admin":false},"created_at":"2016-09-12T16:39:53Z","updated_at":"2016-09-12T16:39:53Z","body":"I respectfully disagree with you (@guillaumep, @madmath, @manumilou), because the only reason that you point out is \"We don't need to do it right now\" and not what is the best option for the project now and in the future.\r\n\r\nI think that MariaDB is a great DBMS and I have used it a lot more than PostgreSQL.\r\n\r\nBut for this project, I think PostgreSQL is a better choice because we need to store JSON right now and in the future if we need to add a feature like \"GIS\" we don't need to do a painful data migration. With PostgreSQL, all the logic that is handled in python to work with the JSON values will be easier and we will replace a custom Django app (django-annoying) by a field that is in Django itself. \r\n\r\nWe are working on a project that is not deployed in production yet and change to PostgreSQL right now will be a lot easier than later in the future. \r\n\r\nWhat is the point in not use a tool (PostgreSQL) that should make the development process easier and with fewer custom dependencies because we have already used other tool (MySQL) and added the dependency (django-annoying) ? \r\n\r\nWhat is the solid reason that has made us use MariaDB in the first place that we need a solid reason to replace it? \r\n\r\nEven when I read the differents comparison in the web, in general, PostgreSQL is less popular but better than MariaDB."}}
{"actor":{"display_login":"erozqba"}}