{"action":"created","issue":{"url":"https://api.github.com/repos/FreshRSS/FreshRSS/issues/416","labels_url":"https://api.github.com/repos/FreshRSS/FreshRSS/issues/416/labels{/name}","comments_url":"https://api.github.com/repos/FreshRSS/FreshRSS/issues/416/comments","events_url":"https://api.github.com/repos/FreshRSS/FreshRSS/issues/416/events","html_url":"https://github.com/FreshRSS/FreshRSS/issues/416","id":27257660,"number":416,"title":"Supporter PostgreSQL","user":{"login":"PodCol","id":3834374,"avatar_url":"https://avatars.githubusercontent.com/u/3834374?v=3","gravatar_id":"","url":"https://api.github.com/users/PodCol","html_url":"https://github.com/PodCol","followers_url":"https://api.github.com/users/PodCol/followers","following_url":"https://api.github.com/users/PodCol/following{/other_user}","gists_url":"https://api.github.com/users/PodCol/gists{/gist_id}","starred_url":"https://api.github.com/users/PodCol/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PodCol/subscriptions","organizations_url":"https://api.github.com/users/PodCol/orgs","repos_url":"https://api.github.com/users/PodCol/repos","events_url":"https://api.github.com/users/PodCol/events{/privacy}","received_events_url":"https://api.github.com/users/PodCol/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/FreshRSS/FreshRSS/labels/Framasoft","name":"Framasoft","color":"6A5687"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/FreshRSS/FreshRSS/milestones/9","html_url":"https://github.com/FreshRSS/FreshRSS/milestones/2.0.0","labels_url":"https://api.github.com/repos/FreshRSS/FreshRSS/milestones/9/labels","id":506246,"number":9,"title":"2.0.0","description":"Évolutions futures","creator":{"login":"Alkarex","id":1008324,"avatar_url":"https://avatars.githubusercontent.com/u/1008324?v=3","gravatar_id":"","url":"https://api.github.com/users/Alkarex","html_url":"https://github.com/Alkarex","followers_url":"https://api.github.com/users/Alkarex/followers","following_url":"https://api.github.com/users/Alkarex/following{/other_user}","gists_url":"https://api.github.com/users/Alkarex/gists{/gist_id}","starred_url":"https://api.github.com/users/Alkarex/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Alkarex/subscriptions","organizations_url":"https://api.github.com/users/Alkarex/orgs","repos_url":"https://api.github.com/users/Alkarex/repos","events_url":"https://api.github.com/users/Alkarex/events{/privacy}","received_events_url":"https://api.github.com/users/Alkarex/received_events","type":"User","site_admin":false},"open_issues":68,"closed_issues":3,"state":"open","created_at":"2013-12-05T19:34:19Z","updated_at":"2015-10-24T19:57:34Z","due_on":null,"closed_at":null},"comments":37,"created_at":"2014-02-10T11:20:16Z","updated_at":"2016-01-06T08:56:27Z","closed_at":null,"body":"Certains ont PostgreSQL et non MySQL d'installé sur leur serveur/hébergement. Postgre en plus de MySQL et sqlite, et le monde entier sera ravi :+1: "},"comment":{"url":"https://api.github.com/repos/FreshRSS/FreshRSS/issues/comments/169270155","html_url":"https://github.com/FreshRSS/FreshRSS/issues/416#issuecomment-169270155","issue_url":"https://api.github.com/repos/FreshRSS/FreshRSS/issues/416","id":169270155,"user":{"login":"Damstre","id":13200173,"avatar_url":"https://avatars.githubusercontent.com/u/13200173?v=3","gravatar_id":"","url":"https://api.github.com/users/Damstre","html_url":"https://github.com/Damstre","followers_url":"https://api.github.com/users/Damstre/followers","following_url":"https://api.github.com/users/Damstre/following{/other_user}","gists_url":"https://api.github.com/users/Damstre/gists{/gist_id}","starred_url":"https://api.github.com/users/Damstre/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Damstre/subscriptions","organizations_url":"https://api.github.com/users/Damstre/orgs","repos_url":"https://api.github.com/users/Damstre/repos","events_url":"https://api.github.com/users/Damstre/events{/privacy}","received_events_url":"https://api.github.com/users/Damstre/received_events","type":"User","site_admin":false},"created_at":"2016-01-06T08:56:27Z","updated_at":"2016-01-06T08:56:27Z","body":"C'est bon ça tourne ! un problème de casse sur les noms de colonnes, maintenant tout à l'air de rouler. Je vais faire le tour, voir s'il n'y a pas d'autres endroits où cela peut poser des problèmes, je nettoie le code et je vous envoie ça.\r\n\r\nQuelques questions au passage, concernant le cache_nbUnread et les stats en général, pourquoi on ne crée pas une vue directement dans la bdd qui les conserve ?\r\nJ'ai eu la flemme de réécrire les requêtes d'update en postgresql, du coup je fais l'update avec des triggers, ça marche mais je trouve ça un peu bourrin..."}}