{"action":"opened","issue":{"url":"https://api.github.com/repos/pharaun/Karmator/issues/114","labels_url":"https://api.github.com/repos/pharaun/Karmator/issues/114/labels{/name}","comments_url":"https://api.github.com/repos/pharaun/Karmator/issues/114/comments","events_url":"https://api.github.com/repos/pharaun/Karmator/issues/114/events","html_url":"https://github.com/pharaun/Karmator/issues/114","id":91419861,"number":114,"title":"Sqlite has ability of adding in custom functions.","user":{"login":"pharaun","id":100561,"avatar_url":"https://avatars.githubusercontent.com/u/100561?v=3","gravatar_id":"","url":"https://api.github.com/users/pharaun","html_url":"https://github.com/pharaun","followers_url":"https://api.github.com/users/pharaun/followers","following_url":"https://api.github.com/users/pharaun/following{/other_user}","gists_url":"https://api.github.com/users/pharaun/gists{/gist_id}","starred_url":"https://api.github.com/users/pharaun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pharaun/subscriptions","organizations_url":"https://api.github.com/users/pharaun/orgs","repos_url":"https://api.github.com/users/pharaun/repos","events_url":"https://api.github.com/users/pharaun/events{/privacy}","received_events_url":"https://api.github.com/users/pharaun/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/pharaun/Karmator/labels/core-feature","name":"core-feature","color":"fbca04"},{"url":"https://api.github.com/repos/pharaun/Karmator/labels/upstream","name":"upstream","color":"5319e7"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-06-27T05:47:21Z","updated_at":"2015-06-27T05:47:21Z","closed_at":null,"body":"Basically for some of the votable ranking stuff we would want to have some nicer math functions implemented, but sqlite doesn't have any built in, have to load either via dll files or feed the system a custom function.\r\n\r\ndirect-sqlite supports this, but persistent-sqlite does not, which is unfortunate because we are built on top of persistent-sqlite, and if we include direct-sqlite it causes the app to crash.\r\n\r\nLook into porting these features:\r\nhttps://hackage.haskell.org/package/direct-sqlite-2.3.15/docs/Database-SQLite3-Direct.html#g:9\r\n\r\nTo persistent-sqlite."}}