Update to SQLitePCLRaw 3.0

[ericsink]

This work is in progress, currently in a branch called raw3.

This will fix #1280 and #1272, which appear to be dupes of each other.

[ericsink]

One change in SQLitePCLRaw 3.0 is that I no longer build and distribute e_sqlcipher, so the package SQLitePCLRaw.bundle_e_sqlcipher is deprecated. So in this branch I have removed the corresponding sqlite-net nuget package.

[ericsink]

Another change in SQLitePCLRaw 3.0 is that SQLitePCLRaw.bundle_green is deprecated. It was always intended only for use by sqlite-net, and its presence causes all kinds of confusion, so I took the opportunity to get rid of it. I have implemented the same capability directly here in the raw3 branch.

[dartasen]

Thank you so much for your work @ericsink 😄

[jerminContractor]

@ericsink thank you so much. Can you please provide a tentative date as to when this will be done so I can plan my project development accordingly.

[ericsink]

Any day now, I hope. We're still sorting out transition issues for me getting more involved.

[archergod]

Hey @ericsink do we have any timeline on this. Your last message says any day now, but it is 2 weeks old message. I was hoping we get it last week. No pressure really just asking.. I understand it is done when you get chance or solve it.

[ericsink]

I just need a couple things from @praeclarum but I'm having trouble getting in contact with him.

[ericsink]

Okay, here's something to try. I haven't tested this yet, but please tell me if it works.

1. Remove the reference to sqlite-net-pcl and add the package sqlite-net-e. It's a pre-release.
2. Add the package SourceGear.sqlite3 version 3.50.4.2.

The sqlite-net-e package is another form of sqlite-net, but instead of depending on SQLitePCLRaw.bundle_green, it depends on SQLitePCLRaw.config.e_sqlite3 version 3.0, which is configured to look for a library with e_sqlite3 as the base name, and SourceGear.sqlite3 provides that.

I still need to write up a better explanation, but I'm curious about feedback on this.

Note that this solution does not emulate the so-called "green" behavior, wherein the e_sqlite3 library is used everywhere but iOS. That implementation is done in a branch here, but I can't push it up to nuget.org without some help from @praeclarum .

[wolframliermann]

Hi @ericsink,

Many thanks for your investigations. I tried out your solution, but it didn't remove the 16 KB warning when I started the app.

[ericsink]

Is the build out folder cleaned out? What version of the dotnet tools are you using? What other packages are in your project?

[wolframliermann]

Thank you! I will test this on Monday and then let you know.

[johncdoherty]

@ericsink Initial tests of the above approach seem to be working properly for my iOS and Android .NET 9.0 MAUI app (it removes the 16kb warnings and SQLit operations are functioning correctly) after swapping the NuGet packages:

<PackageReference Include="sqlite-net-pcl" Version="1.9.172" />

with

<PackageReference Include="sqlite-net-e" Version="1.10.0-beta2" />
<PackageReference Include="SourceGear.sqlite3" Version="3.50.4.2" />