{"action":"opened","issue":{"url":"https://api.github.com/repos/pydata/pandas/issues/14375","repository_url":"https://api.github.com/repos/pydata/pandas","labels_url":"https://api.github.com/repos/pydata/pandas/issues/14375/labels{/name}","comments_url":"https://api.github.com/repos/pydata/pandas/issues/14375/comments","events_url":"https://api.github.com/repos/pydata/pandas/issues/14375/events","html_url":"https://github.com/pydata/pandas/issues/14375","id":181646064,"number":14375,"title":"Could pandas be used as an alternative SQL backend?","user":{"login":"jdejoode","id":10449733,"avatar_url":"https://avatars.githubusercontent.com/u/10449733?v=3","gravatar_id":"","url":"https://api.github.com/users/jdejoode","html_url":"https://github.com/jdejoode","followers_url":"https://api.github.com/users/jdejoode/followers","following_url":"https://api.github.com/users/jdejoode/following{/other_user}","gists_url":"https://api.github.com/users/jdejoode/gists{/gist_id}","starred_url":"https://api.github.com/users/jdejoode/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jdejoode/subscriptions","organizations_url":"https://api.github.com/users/jdejoode/orgs","repos_url":"https://api.github.com/users/jdejoode/repos","events_url":"https://api.github.com/users/jdejoode/events{/privacy}","received_events_url":"https://api.github.com/users/jdejoode/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-10-07T11:29:53Z","updated_at":"2016-10-07T11:29:53Z","closed_at":null,"body":"I am so used to manipulating data with pandas that I don't want to fall back to SQL unless absolutely necessary. In fact, I'd rather not use SQL. Nonetheless SQL works better for out-of-core size data (obviously, that is not the primary focus of pandas, and yes I am aware of Dask). \r\n\r\nWould it be possible to use pandas on data that resides in an SQL database without importing it in memory. I am not asking whether it would be possible to access the data, but whether it would be possible to use pandas as backend to SQL. For instance: I write pandas code and SQL is executed in the background. I want to count all the values in a column, but I write `.value_counts()`. Do you see what I mean?\r\n\r\nDoes that make any sense? Apologies if my question is off-topic or naive?\r\n"}}
{"actor":{"display_login":"jdejoode"}}