{"action":"created","issue":{"url":"https://api.github.com/repos/oysteinkrog/SQLite.Net-PCL/issues/111","labels_url":"https://api.github.com/repos/oysteinkrog/SQLite.Net-PCL/issues/111/labels{/name}","comments_url":"https://api.github.com/repos/oysteinkrog/SQLite.Net-PCL/issues/111/comments","events_url":"https://api.github.com/repos/oysteinkrog/SQLite.Net-PCL/issues/111/events","html_url":"https://github.com/oysteinkrog/SQLite.Net-PCL/issues/111","id":54592652,"number":111,"title":"Question: How to customize the connection string, to include custom PRAGMA settings?","user":{"login":"markgibaud","id":425594,"avatar_url":"https://avatars.githubusercontent.com/u/425594?v=3","gravatar_id":"","url":"https://api.github.com/users/markgibaud","html_url":"https://github.com/markgibaud","followers_url":"https://api.github.com/users/markgibaud/followers","following_url":"https://api.github.com/users/markgibaud/following{/other_user}","gists_url":"https://api.github.com/users/markgibaud/gists{/gist_id}","starred_url":"https://api.github.com/users/markgibaud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/markgibaud/subscriptions","organizations_url":"https://api.github.com/users/markgibaud/orgs","repos_url":"https://api.github.com/users/markgibaud/repos","events_url":"https://api.github.com/users/markgibaud/events{/privacy}","received_events_url":"https://api.github.com/users/markgibaud/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-01-16T16:11:44Z","updated_at":"2015-01-16T16:50:56Z","closed_at":null,"body":"I want to use the following connection string, how would I do this using SQLite-Net-PCL?\r\n\r\n```var connectionString = string.Format(\"{0}; New=true; Version=3;PRAGMA locking_mode=EXCLUSIVE; PRAGMA journal_mode=WAL; PRAGMA cache_size=20000; PRAGMA page_size=32768; PRAGMA synchronous=off;\",dbFilePath);```\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/oysteinkrog/SQLite.Net-PCL/issues/comments/70283297","html_url":"https://github.com/oysteinkrog/SQLite.Net-PCL/issues/111#issuecomment-70283297","issue_url":"https://api.github.com/repos/oysteinkrog/SQLite.Net-PCL/issues/111","id":70283297,"user":{"login":"markgibaud","id":425594,"avatar_url":"https://avatars.githubusercontent.com/u/425594?v=3","gravatar_id":"","url":"https://api.github.com/users/markgibaud","html_url":"https://github.com/markgibaud","followers_url":"https://api.github.com/users/markgibaud/followers","following_url":"https://api.github.com/users/markgibaud/following{/other_user}","gists_url":"https://api.github.com/users/markgibaud/gists{/gist_id}","starred_url":"https://api.github.com/users/markgibaud/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/markgibaud/subscriptions","organizations_url":"https://api.github.com/users/markgibaud/orgs","repos_url":"https://api.github.com/users/markgibaud/repos","events_url":"https://api.github.com/users/markgibaud/events{/privacy}","received_events_url":"https://api.github.com/users/markgibaud/received_events","type":"User","site_admin":false},"created_at":"2015-01-16T16:50:56Z","updated_at":"2015-01-16T16:50:56Z","body":"Thanks for the reply! I thought your twitter account looked a bit weird ;-)\r\n\r\nFrom what I can see in the source, that parameter ends up going into this method in ```SQLiteApiIOS```\r\n\r\n```public Result Open(byte[] filename, out IDbHandle db, int flags, IntPtr zvfs)\r\n        {\r\n            IntPtr dbPtr;\r\n            Result r = SQLiteApiIOSInternal.sqlite3_open_v2(filename, out dbPtr, flags, zvfs);\r\n            db = new DbHandle(dbPtr);\r\n            return r;\r\n        }```\r\n\r\nBut from the documentation here: https://www.sqlite.org/c3ref/open.html\r\nIt seems like there is no mention of pragmas.\r\n\r\nAm I missing something?\r\n\r\nI've also tried to set the pragmas manually, like this:\r\n\r\n\r\n```var pragmas = new List<string>()\r\n            {\r\n                \"PRAGMA journal_mode = WAL;\",\r\n                \"PRAGMA locking_mode=EXCLUSIVE;\",\r\n                \"PRAGMA cache_size=20000;\",\r\n                \"PRAGMA page_size=32768;\",\r\n                \"PRAGMA synchronous=off;\"\r\n            };\r\n\r\n            foreach (var pragma in pragmas)\r\n            {\r\n                var result = await ExecuteScalarAsync<string>(pragma);\r\n            }```\r\n\r\nBut when I read them back, they haven't changed from the defaults :-("}}