{"action":"created","issue":{"url":"https://api.github.com/repos/influitive/apartment/issues/336","repository_url":"https://api.github.com/repos/influitive/apartment","labels_url":"https://api.github.com/repos/influitive/apartment/issues/336/labels{/name}","comments_url":"https://api.github.com/repos/influitive/apartment/issues/336/comments","events_url":"https://api.github.com/repos/influitive/apartment/issues/336/events","html_url":"https://github.com/influitive/apartment/issues/336","id":164820630,"number":336,"title":"JDBC connection pooling","user":{"login":"ari","id":27023,"avatar_url":"https://avatars.githubusercontent.com/u/27023?v=3","gravatar_id":"","url":"https://api.github.com/users/ari","html_url":"https://github.com/ari","followers_url":"https://api.github.com/users/ari/followers","following_url":"https://api.github.com/users/ari/following{/other_user}","gists_url":"https://api.github.com/users/ari/gists{/gist_id}","starred_url":"https://api.github.com/users/ari/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ari/subscriptions","organizations_url":"https://api.github.com/users/ari/orgs","repos_url":"https://api.github.com/users/ari/repos","events_url":"https://api.github.com/users/ari/events{/privacy}","received_events_url":"https://api.github.com/users/ari/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2016-07-11T11:58:51Z","updated_at":"2016-07-13T09:01:23Z","closed_at":null,"body":"Apologies for using your task tracker to ask questions, but I couldn't find a more suitable mailing list. Let me know where to go if that's your preference.\r\n\r\nThis gem looks really interesting, but I'm unclear on how it handles connection pooling with JDBC. Let's say I had 500 tenants in a single application, would that result in 500 separate JDBC connection pools if I was running jruby with warbler/tomcat?\r\n\r\nObviously the database would not cope happily with so many connection pools (especially if each had several open connections).\r\n\r\nOr do you manage a single pool, using a common user/pass that can access all databases/schemas, and then just switch the database before each SQL query? Isn't that schema switching adding a lot of SQL overhead, or is that reasonably minor in production?"},"comment":{"url":"https://api.github.com/repos/influitive/apartment/issues/comments/232298447","html_url":"https://github.com/influitive/apartment/issues/336#issuecomment-232298447","issue_url":"https://api.github.com/repos/influitive/apartment/issues/336","id":232298447,"user":{"login":"richpeck","id":1104431,"avatar_url":"https://avatars.githubusercontent.com/u/1104431?v=3","gravatar_id":"","url":"https://api.github.com/users/richpeck","html_url":"https://github.com/richpeck","followers_url":"https://api.github.com/users/richpeck/followers","following_url":"https://api.github.com/users/richpeck/following{/other_user}","gists_url":"https://api.github.com/users/richpeck/gists{/gist_id}","starred_url":"https://api.github.com/users/richpeck/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/richpeck/subscriptions","organizations_url":"https://api.github.com/users/richpeck/orgs","repos_url":"https://api.github.com/users/richpeck/repos","events_url":"https://api.github.com/users/richpeck/events{/privacy}","received_events_url":"https://api.github.com/users/richpeck/received_events","type":"User","site_admin":false},"created_at":"2016-07-13T09:01:23Z","updated_at":"2016-07-13T09:01:23Z","body":"How do you handle Rails migrations etc, or don't you change the schema at all?"}}
{"actor":{"display_login":"richpeck"}}