{"action":"opened","issue":{"url":"https://api.github.com/repos/courageousillumination/paragon/issues/20","repository_url":"https://api.github.com/repos/courageousillumination/paragon","labels_url":"https://api.github.com/repos/courageousillumination/paragon/issues/20/labels{/name}","comments_url":"https://api.github.com/repos/courageousillumination/paragon/issues/20/comments","events_url":"https://api.github.com/repos/courageousillumination/paragon/issues/20/events","html_url":"https://github.com/courageousillumination/paragon/issues/20","id":149483831,"number":20,"title":"μSQL","user":{"login":"courageousillumination","id":4268960,"avatar_url":"https://avatars.githubusercontent.com/u/4268960?v=3","gravatar_id":"","url":"https://api.github.com/users/courageousillumination","html_url":"https://github.com/courageousillumination","followers_url":"https://api.github.com/users/courageousillumination/followers","following_url":"https://api.github.com/users/courageousillumination/following{/other_user}","gists_url":"https://api.github.com/users/courageousillumination/gists{/gist_id}","starred_url":"https://api.github.com/users/courageousillumination/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/courageousillumination/subscriptions","organizations_url":"https://api.github.com/users/courageousillumination/orgs","repos_url":"https://api.github.com/users/courageousillumination/repos","events_url":"https://api.github.com/users/courageousillumination/events{/privacy}","received_events_url":"https://api.github.com/users/courageousillumination/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/courageousillumination/paragon/labels/enhancement","name":"enhancement","color":"84b6eb"},{"url":"https://api.github.com/repos/courageousillumination/paragon/labels/help%20wanted","name":"help wanted","color":"128A0C"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-04-19T14:48:23Z","updated_at":"2016-04-19T14:48:23Z","closed_at":null,"body":"So this i more of a proposal than an issue. I've realized that what I really want is SQL + a sleek interface. Right now, we're kind of emulating that with resources, but I was thinking: \"what if we just give users SQL?\" We'd basically create a table per variable then allow the user to run queries on that table. So this proposal I suppose can be split into two parts:\r\n1) Prototype this with sqlite. Can we get everything we want out of it?\r\n2) The problem with this approach is that databases aren't meant to do thousands - millions of tables, even if each of those tables is small. Perhaps we write our own database with this use case specifically in mind (I like the name μSQL). Or maybe there's some non traditional database we can use? Or maybe this is just premature optimization and it won't be a problem?"}}