{"action":"created","issue":{"url":"https://api.github.com/repos/google/lovefield/issues/75","labels_url":"https://api.github.com/repos/google/lovefield/issues/75/labels{/name}","comments_url":"https://api.github.com/repos/google/lovefield/issues/75/comments","events_url":"https://api.github.com/repos/google/lovefield/issues/75/events","html_url":"https://github.com/google/lovefield/issues/75","id":105976305,"number":75,"title":"Why not store the schema separately ?","user":{"login":"mingodad","id":462618,"avatar_url":"https://avatars.githubusercontent.com/u/462618?v=3","gravatar_id":"","url":"https://api.github.com/users/mingodad","html_url":"https://github.com/mingodad","followers_url":"https://api.github.com/users/mingodad/followers","following_url":"https://api.github.com/users/mingodad/following{/other_user}","gists_url":"https://api.github.com/users/mingodad/gists{/gist_id}","starred_url":"https://api.github.com/users/mingodad/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mingodad/subscriptions","organizations_url":"https://api.github.com/users/mingodad/orgs","repos_url":"https://api.github.com/users/mingodad/repos","events_url":"https://api.github.com/users/mingodad/events{/privacy}","received_events_url":"https://api.github.com/users/mingodad/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-09-11T09:33:36Z","updated_at":"2015-09-11T18:03:03Z","closed_at":null,"body":"Hello !\r\nI've been looking at the mvidb and others and noticed that the rows are stored as json objects (repeating key:value on every row), would not be more better to store the schema info (col names, col positions, col types, constraints,...) on a separated \"table\" (aka data catalog) and store the rows as json arrays (no keys \"column names\" repeated) the database would be smaller and probably faster.\r\n\r\nCheers !"},"comment":{"url":"https://api.github.com/repos/google/lovefield/issues/comments/139614615","html_url":"https://github.com/google/lovefield/issues/75#issuecomment-139614615","issue_url":"https://api.github.com/repos/google/lovefield/issues/75","id":139614615,"user":{"login":"freshp86","id":7547039,"avatar_url":"https://avatars.githubusercontent.com/u/7547039?v=3","gravatar_id":"","url":"https://api.github.com/users/freshp86","html_url":"https://github.com/freshp86","followers_url":"https://api.github.com/users/freshp86/followers","following_url":"https://api.github.com/users/freshp86/following{/other_user}","gists_url":"https://api.github.com/users/freshp86/gists{/gist_id}","starred_url":"https://api.github.com/users/freshp86/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/freshp86/subscriptions","organizations_url":"https://api.github.com/users/freshp86/orgs","repos_url":"https://api.github.com/users/freshp86/repos","events_url":"https://api.github.com/users/freshp86/events{/privacy}","received_events_url":"https://api.github.com/users/freshp86/received_events","type":"User","site_admin":false},"created_at":"2015-09-11T18:03:03Z","updated_at":"2015-09-11T18:03:03Z","body":"Regarding storing the schema separately, see https://github.com/google/lovefield/issues/58.\r\n\r\nRegarding the potential performance gains by doing so, it would be worth experimenting. One problem I see though, is that there would be a performance penalty of converting the \"compact\" object payloads, to the format that is expected to be returned to the user. Today, the format we store in the DB, is the same as the one returned to the user, so there is minimal conversion penalty."}}