payload: {"action":"created","issue":{"url":"https://api.github.com/repos/ericsink/SQLitePCL.raw/issues/325","repository_url":"https://api.github.com/repos/ericsink/SQLitePCL.raw","labels_url":"https://api.github.com/repos/ericsink/SQLitePCL.raw/issues/325/labels{/name}","comments_url":"https://api.github.com/repos/ericsink/SQLitePCL.raw/issues/325/comments","events_url":"https://api.github.com/repos/ericsink/SQLitePCL.raw/issues/325/events","html_url":"https://github.com/ericsink/SQLitePCL.raw/issues/325","id":548297348,"node_id":"MDU6SXNzdWU1NDgyOTczNDg=","number":325,"title":"Bring back the SQLitePCLRaw.provider.sqlite3 packages","user":{"login":"bricelam","id":1226749,"node_id":"MDQ6VXNlcjEyMjY3NDk=","avatar_url":"https://avatars2.githubusercontent.com/u/1226749?v=4","gravatar_id":"","url":"https://api.github.com/users/bricelam","html_url":"https://github.com/bricelam","followers_url":"https://api.github.com/users/bricelam/followers","following_url":"https://api.github.com/users/bricelam/following{/other_user}","gists_url":"https://api.github.com/users/bricelam/gists{/gist_id}","starred_url":"https://api.github.com/users/bricelam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bricelam/subscriptions","organizations_url":"https://api.github.com/users/bricelam/orgs","repos_url":"https://api.github.com/users/bricelam/repos","events_url":"https://api.github.com/users/bricelam/events{/privacy}","received_events_url":"https://api.github.com/users/bricelam/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2020-01-10T21:23:27Z","updated_at":"2020-01-13T15:07:21Z","closed_at":null,"author_association":"NONE","body":"Using the system version of SQLite is a bit ugly in 2.x:\r\n\r\n```csharp\r\nclass NativeLibraryAdapter : IGetFunctionPointer\r\n{\r\n    readonly IntPtr _library;\r\n\r\n    public NativeLibraryAdapter(string name)\r\n        => _library = NativeLibrary.Load(name);\r\n\r\n    public IntPtr GetFunctionPointer(string name)\r\n        => NativeLibrary.TryGetExport(_library, name, out var address)\r\n            ? address\r\n            : IntPtr.Zero;\r\n}\r\n```\r\n``` csharp\r\nSQLite3Provider_dynamic_cdecl\r\n    .Setup(\"sqlite3\", new NativeLibraryAdapter(\"sqlite3\"));\r\nSQLitePCL.raw.SetProvider(new SQLite3Provider_dynamic_cdecl());\r\n```\r\nIt gets even harder on .NET Framework where NativeLibrary isn't available.\r\n\r\nNewer versions of PROJ--used by the SpatiaLite extension--are only compatible with the system-installed version of SQLite. (see https://github.com/dotnet/efcore/issues/16667) So having an easier way to use the system version would be nice."},"comment":{"url":"https://api.github.com/repos/ericsink/SQLitePCL.raw/issues/comments/573708139","html_url":"https://github.com/ericsink/SQLitePCL.raw/issues/325#issuecomment-573708139","issue_url":"https://api.github.com/repos/ericsink/SQLitePCL.raw/issues/325","id":573708139,"node_id":"MDEyOklzc3VlQ29tbWVudDU3MzcwODEzOQ==","user":{"login":"ericsink","id":3877005,"node_id":"MDQ6VXNlcjM4NzcwMDU=","avatar_url":"https://avatars2.githubusercontent.com/u/3877005?v=4","gravatar_id":"","url":"https://api.github.com/users/ericsink","html_url":"https://github.com/ericsink","followers_url":"https://api.github.com/users/ericsink/followers","following_url":"https://api.github.com/users/ericsink/following{/other_user}","gists_url":"https://api.github.com/users/ericsink/gists{/gist_id}","starred_url":"https://api.github.com/users/ericsink/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ericsink/subscriptions","organizations_url":"https://api.github.com/users/ericsink/orgs","repos_url":"https://api.github.com/users/ericsink/repos","events_url":"https://api.github.com/users/ericsink/events{/privacy}","received_events_url":"https://api.github.com/users/ericsink/received_events","type":"User","site_admin":false},"created_at":"2020-01-13T15:07:21Z","updated_at":"2020-01-13T15:07:21Z","author_association":"OWNER","body":"This wouldn't be hard to do, and probably makes sense.\r\n\r\nAt the beginning of my dev cycle for 2.0, one of my goals was to reduce the number of packages and providers.  The sheer number of them causes a lot of confusion.  I made some progress, but in general, this goal seems to be unreachable.  There are so many edge cases.  SQLitePCLRaw is almost entirely about edge cases.\r\n"}}
other: {"actor":{"display_login":"ericsink"}}