{"action":"created","issue":{"url":"https://api.github.com/repos/Homebrew/homebrew-python/issues/197","labels_url":"https://api.github.com/repos/Homebrew/homebrew-python/issues/197/labels{/name}","comments_url":"https://api.github.com/repos/Homebrew/homebrew-python/issues/197/comments","events_url":"https://api.github.com/repos/Homebrew/homebrew-python/issues/197/events","html_url":"https://github.com/Homebrew/homebrew-python/pull/197","id":55917228,"number":197,"title":"apsw: new formula v3.8.8.1-r1","user":{"login":"msabramo","id":305268,"avatar_url":"https://avatars.githubusercontent.com/u/305268?v=3","gravatar_id":"","url":"https://api.github.com/users/msabramo","html_url":"https://github.com/msabramo","followers_url":"https://api.github.com/users/msabramo/followers","following_url":"https://api.github.com/users/msabramo/following{/other_user}","gists_url":"https://api.github.com/users/msabramo/gists{/gist_id}","starred_url":"https://api.github.com/users/msabramo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/msabramo/subscriptions","organizations_url":"https://api.github.com/users/msabramo/orgs","repos_url":"https://api.github.com/users/msabramo/repos","events_url":"https://api.github.com/users/msabramo/events{/privacy}","received_events_url":"https://api.github.com/users/msabramo/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-01-29T15:57:37Z","updated_at":"2015-01-29T17:00:02Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/Homebrew/homebrew-python/pulls/197","html_url":"https://github.com/Homebrew/homebrew-python/pull/197","diff_url":"https://github.com/Homebrew/homebrew-python/pull/197.diff","patch_url":"https://github.com/Homebrew/homebrew-python/pull/197.patch"},"body":"This offers both a SQLite library and a nice shell for SQLite.\r\n\r\nIt is nice to have it in Homebrew, because it is not available on PyPI. See http://rogerbinns.github.io/apsw/download.html#easy-install-pip-pypi\r\n\r\n```\r\n$ python -c \"import apsw;apsw.main()\"\r\nSQLite version 3.8.8.1 (APSW 3.8.8.1-r1)\r\nEnter \".help\" for instructions\r\nEnter SQL statements terminated with a \";\"\r\nsqlite>\r\n```\r\n\r\nCc: @rogerbinns"},"comment":{"url":"https://api.github.com/repos/Homebrew/homebrew-python/issues/comments/72061553","html_url":"https://github.com/Homebrew/homebrew-python/pull/197#issuecomment-72061553","issue_url":"https://api.github.com/repos/Homebrew/homebrew-python/issues/197","id":72061553,"user":{"login":"tdsmith","id":173889,"avatar_url":"https://avatars.githubusercontent.com/u/173889?v=3","gravatar_id":"","url":"https://api.github.com/users/tdsmith","html_url":"https://github.com/tdsmith","followers_url":"https://api.github.com/users/tdsmith/followers","following_url":"https://api.github.com/users/tdsmith/following{/other_user}","gists_url":"https://api.github.com/users/tdsmith/gists{/gist_id}","starred_url":"https://api.github.com/users/tdsmith/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tdsmith/subscriptions","organizations_url":"https://api.github.com/users/tdsmith/orgs","repos_url":"https://api.github.com/users/tdsmith/repos","events_url":"https://api.github.com/users/tdsmith/events{/privacy}","received_events_url":"https://api.github.com/users/tdsmith/received_events","type":"User","site_admin":false},"created_at":"2015-01-29T17:00:02Z","updated_at":"2015-01-29T17:00:02Z","body":"Let's do:\r\n\r\n```ruby\r\noption \"with-sqlite\", \"Build with brewed sqlite (instead of system sqlite)\"\r\ndepends_on \"sqlite\" => :optional\r\n```\r\n\r\nIf users say `brew install apsw`, they'll get a version built against system sqlite; if they say `brew install apsw --with-sqlite`, they'll get a version built against Homebrew's current sqlite.\r\n\r\nThis works by setting up the build environment to make either system or Homebrew sqlite more likely to be found. If you could verify that this behavior actually works by seeing which sqlite apsw picks up in either case, that'd be great."}}