{"action":"created","issue":{"url":"https://api.github.com/repos/mapbox/node-sqlite3/issues/660","repository_url":"https://api.github.com/repos/mapbox/node-sqlite3","labels_url":"https://api.github.com/repos/mapbox/node-sqlite3/issues/660/labels{/name}","comments_url":"https://api.github.com/repos/mapbox/node-sqlite3/issues/660/comments","events_url":"https://api.github.com/repos/mapbox/node-sqlite3/issues/660/events","html_url":"https://github.com/mapbox/node-sqlite3/pull/660","id":159323595,"number":660,"title":"Enable foreign key support by default","user":{"login":"babignano","id":652227,"avatar_url":"https://avatars.githubusercontent.com/u/652227?v=3","gravatar_id":"","url":"https://api.github.com/users/babignano","html_url":"https://github.com/babignano","followers_url":"https://api.github.com/users/babignano/followers","following_url":"https://api.github.com/users/babignano/following{/other_user}","gists_url":"https://api.github.com/users/babignano/gists{/gist_id}","starred_url":"https://api.github.com/users/babignano/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/babignano/subscriptions","organizations_url":"https://api.github.com/users/babignano/orgs","repos_url":"https://api.github.com/users/babignano/repos","events_url":"https://api.github.com/users/babignano/events{/privacy}","received_events_url":"https://api.github.com/users/babignano/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-06-09T03:56:45Z","updated_at":"2016-06-10T03:57:02Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/mapbox/node-sqlite3/pulls/660","html_url":"https://github.com/mapbox/node-sqlite3/pull/660","diff_url":"https://github.com/mapbox/node-sqlite3/pull/660.diff","patch_url":"https://github.com/mapbox/node-sqlite3/pull/660.patch"},"body":"Enables Foreign Key support by default. \r\n\r\nForeign Key support is disabled in SQLite 3.x by default and is only enabled via a build flag as in the PR or a pragma setting `PRAGMA foreign_keys = ON;` each time a connection is established - which is not feasible in our app as connections are opened and closed through an ORM (We are using Sails and waterline-sqlite3) so we have no visibility over the connections being opened and closed.\r\n\r\nI would suspect this would break a lot of existing apps but at least we can have the conversation."},"comment":{"url":"https://api.github.com/repos/mapbox/node-sqlite3/issues/comments/225087755","html_url":"https://github.com/mapbox/node-sqlite3/pull/660#issuecomment-225087755","issue_url":"https://api.github.com/repos/mapbox/node-sqlite3/issues/660","id":225087755,"user":{"login":"coveralls","id":2354108,"avatar_url":"https://avatars.githubusercontent.com/u/2354108?v=3","gravatar_id":"","url":"https://api.github.com/users/coveralls","html_url":"https://github.com/coveralls","followers_url":"https://api.github.com/users/coveralls/followers","following_url":"https://api.github.com/users/coveralls/following{/other_user}","gists_url":"https://api.github.com/users/coveralls/gists{/gist_id}","starred_url":"https://api.github.com/users/coveralls/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coveralls/subscriptions","organizations_url":"https://api.github.com/users/coveralls/orgs","repos_url":"https://api.github.com/users/coveralls/repos","events_url":"https://api.github.com/users/coveralls/events{/privacy}","received_events_url":"https://api.github.com/users/coveralls/received_events","type":"User","site_admin":false},"created_at":"2016-06-10T03:57:01Z","updated_at":"2016-06-10T03:57:01Z","body":"\n[![Coverage Status](https://coveralls.io/builds/6540663/badge)](https://coveralls.io/builds/6540663)\n\nCoverage remained the same at 85.793% when pulling **bbc7f5dc37893579003fbf6ba9435d646357f5d7 on playground-xyz:master** into **f5dd456331d48ec5560df517b69a8f4087c74e29 on mapbox:master**.\n"}}
{"actor":{"display_login":"coveralls"}}