{"action":"created","issue":{"url":"https://api.github.com/repos/rickbergfalk/sqlpad/issues/101","repository_url":"https://api.github.com/repos/rickbergfalk/sqlpad","labels_url":"https://api.github.com/repos/rickbergfalk/sqlpad/issues/101/labels{/name}","comments_url":"https://api.github.com/repos/rickbergfalk/sqlpad/issues/101/comments","events_url":"https://api.github.com/repos/rickbergfalk/sqlpad/issues/101/events","html_url":"https://github.com/rickbergfalk/sqlpad/issues/101","id":156042605,"number":101,"title":"HA Storage","user":{"login":"solomongifford","id":2894408,"avatar_url":"https://avatars.githubusercontent.com/u/2894408?v=3","gravatar_id":"","url":"https://api.github.com/users/solomongifford","html_url":"https://github.com/solomongifford","followers_url":"https://api.github.com/users/solomongifford/followers","following_url":"https://api.github.com/users/solomongifford/following{/other_user}","gists_url":"https://api.github.com/users/solomongifford/gists{/gist_id}","starred_url":"https://api.github.com/users/solomongifford/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/solomongifford/subscriptions","organizations_url":"https://api.github.com/users/solomongifford/orgs","repos_url":"https://api.github.com/users/solomongifford/repos","events_url":"https://api.github.com/users/solomongifford/events{/privacy}","received_events_url":"https://api.github.com/users/solomongifford/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-05-20T20:14:58Z","updated_at":"2016-05-25T01:51:52Z","closed_at":null,"body":"I love the idea of in memory persistent storage but it means the application cannot be run in an HA environment with multiple webheads.  Besides db.cache, the other dbs should really be able to be stored in an external database - has anyone done any work to support this?"},"comment":{"url":"https://api.github.com/repos/rickbergfalk/sqlpad/issues/comments/221452703","html_url":"https://github.com/rickbergfalk/sqlpad/issues/101#issuecomment-221452703","issue_url":"https://api.github.com/repos/rickbergfalk/sqlpad/issues/101","id":221452703,"user":{"login":"rickbergfalk","id":303966,"avatar_url":"https://avatars.githubusercontent.com/u/303966?v=3","gravatar_id":"","url":"https://api.github.com/users/rickbergfalk","html_url":"https://github.com/rickbergfalk","followers_url":"https://api.github.com/users/rickbergfalk/followers","following_url":"https://api.github.com/users/rickbergfalk/following{/other_user}","gists_url":"https://api.github.com/users/rickbergfalk/gists{/gist_id}","starred_url":"https://api.github.com/users/rickbergfalk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rickbergfalk/subscriptions","organizations_url":"https://api.github.com/users/rickbergfalk/orgs","repos_url":"https://api.github.com/users/rickbergfalk/repos","events_url":"https://api.github.com/users/rickbergfalk/events{/privacy}","received_events_url":"https://api.github.com/users/rickbergfalk/received_events","type":"User","site_admin":false},"created_at":"2016-05-25T01:51:52Z","updated_at":"2016-05-25T01:51:52Z","body":"One of the difficulties going down this route is everyone is going to have a different database backend preference. For relational databases, schema migrations would also need to be written, so that would need to be accommodated as well.\r\n\r\nSomething I wouldn't want to lose is the basic/standard installation simplicity. ```npm install sqlpad -g``` should always be enough to get started.\r\n\r\nI haven't been able to find an orm that supports the currently used database [nedb.js](https://github.com/louischatriot/nedb/).\r\n\r\nI wouldn't mind migrating to something like sqlite for the base install (the idea of being able to use SqlPad to query against its own database seems kinda fun, especially if SqlPad started to record usage statistics)\r\n\r\nI have a long list of todo items for sqlpad currently, so I don't see myself taking this challenge on any time soon. I wouldn't be opposed to someone else taking it on, provided all the above things are also solved and considered...\r\n"}}
{"actor":{"display_login":"rickbergfalk"}}