{"action":"created","issue":{"url":"https://api.github.com/repos/Fermat-ORG/fermat/issues/5767","repository_url":"https://api.github.com/repos/Fermat-ORG/fermat","labels_url":"https://api.github.com/repos/Fermat-ORG/fermat/issues/5767/labels{/name}","comments_url":"https://api.github.com/repos/Fermat-ORG/fermat/issues/5767/comments","events_url":"https://api.github.com/repos/Fermat-ORG/fermat/issues/5767/events","html_url":"https://github.com/Fermat-ORG/fermat/issues/5767","id":145337454,"number":5767,"title":"Is there a need for a new addon wrapping a non-sql database?","user":{"login":"Luis-Fernando-Molina","id":9479367,"avatar_url":"https://avatars.githubusercontent.com/u/9479367?v=3","gravatar_id":"","url":"https://api.github.com/users/Luis-Fernando-Molina","html_url":"https://github.com/Luis-Fernando-Molina","followers_url":"https://api.github.com/users/Luis-Fernando-Molina/followers","following_url":"https://api.github.com/users/Luis-Fernando-Molina/following{/other_user}","gists_url":"https://api.github.com/users/Luis-Fernando-Molina/gists{/gist_id}","starred_url":"https://api.github.com/users/Luis-Fernando-Molina/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Luis-Fernando-Molina/subscriptions","organizations_url":"https://api.github.com/users/Luis-Fernando-Molina/orgs","repos_url":"https://api.github.com/users/Luis-Fernando-Molina/repos","events_url":"https://api.github.com/users/Luis-Fernando-Molina/events{/privacy}","received_events_url":"https://api.github.com/users/Luis-Fernando-Molina/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":13,"created_at":"2016-04-02T05:13:36Z","updated_at":"2016-04-05T09:22:30Z","closed_at":null,"body":"Discussion started on slack like this:\r\n\r\n\r\nsytolk [6:40 PM] \r\nI see that its have DAOs and fermat Database layer to persist data in sqlite. Its have easy way to do that if you use JOOQ I have use it in server its have maven and gradle plugin http://www.jooq.org/doc/3.7/manual/code-generation/codegen-gradle/ that generate POJOs and DAOs from DB structure automatically and this will work in Android too (I have not tested on Android but its have gradle plugin)\r\n\r\nhttps://github.com/etiennestuder/gradle-jooq-plugin\r\n\r\nhttps://www.youtube.com/watch?v=jR4OtA8kArQ (edited)\r\n\r\nsytolk [6:48 PM] \r\nCan I have sqlite.db SQL export for the server node. I dont know if Android app will use sqlite ?\r\n\r\nacosta_rodrigo [8:36 PM] \r\ndoing the DAOs classes is one of the most time consuming part of some plugins...if you can investigate if this alternative is suitable would be a great time saver for all\r\n\r\nyayotron [11:25 PM] \r\nI doubt we can get that to work, at least not without reestructuring the database manager plugin or getting rid of it. The way JOOQ works is way different than our currently database management structure.\r\n\r\nfranklinmarcano1970 [11:38 PM] \r\nbesides that, that kind of ORM tools even help much, our data model scheme is aimed directly working with the SQLite database and not oriented class and from there create data schemas, but would not hurt more alternatives.\r\n\r\nfurszy [11:44 PM] \r\nSorry, I just read it. Last year i proposed the same idea, a mapper-object relationship embedded database like Perst without success for time reasons.  Now is a good time to improve our database-system with a nice document explaning every future change.\r\n2  \r\n\r\nfranklinmarcano1970 [11:48 PM] \r\n:+1:\r\n\r\n\r\n----- Today April 2nd, 2016 -----\r\nacosta_rodrigo [12:27 AM] \r\nuploaded an image: sql.jpg \r\nAdd Comment\r\nsytolk [7:04 AM] \r\nI have switch using ORM from Hibernate to Jooq 3-4 years befor and think its better but if you have experience with other ORM @furszy ?\r\n\r\nluis-fernando-molina [7:06 AM] \r\nThe current database addon is a wrapper of an sql-like database abstracting the rest of the plugins of which one exactly and at the same time of the operating system.  This doesn't mean Fermat could not have an alternative non-sql wrapper that plugins might use. The condition to do that is the same: it should abstract plugins of the underlying technology specialty if that technology is os dependant.  Those are my two cents to this discussion. (edited)"},"comment":{"url":"https://api.github.com/repos/Fermat-ORG/fermat/issues/comments/205726843","html_url":"https://github.com/Fermat-ORG/fermat/issues/5767#issuecomment-205726843","issue_url":"https://api.github.com/repos/Fermat-ORG/fermat/issues/5767","id":205726843,"user":{"login":"Luis-Fernando-Molina","id":9479367,"avatar_url":"https://avatars.githubusercontent.com/u/9479367?v=3","gravatar_id":"","url":"https://api.github.com/users/Luis-Fernando-Molina","html_url":"https://github.com/Luis-Fernando-Molina","followers_url":"https://api.github.com/users/Luis-Fernando-Molina/followers","following_url":"https://api.github.com/users/Luis-Fernando-Molina/following{/other_user}","gists_url":"https://api.github.com/users/Luis-Fernando-Molina/gists{/gist_id}","starred_url":"https://api.github.com/users/Luis-Fernando-Molina/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Luis-Fernando-Molina/subscriptions","organizations_url":"https://api.github.com/users/Luis-Fernando-Molina/orgs","repos_url":"https://api.github.com/users/Luis-Fernando-Molina/repos","events_url":"https://api.github.com/users/Luis-Fernando-Molina/events{/privacy}","received_events_url":"https://api.github.com/users/Luis-Fernando-Molina/received_events","type":"User","site_admin":false},"created_at":"2016-04-05T09:22:30Z","updated_at":"2016-04-05T09:22:30Z","body":"\r\n@jgpestana please create a bounty for this addon. @sytolk will provide you with the definition document when he finds time for that. Thank you. "}}