Google Play’s 16 KB page size compatibility requirement

[aaldrichaes2]

It appears that this package does not support the upcoming Android requirement to support 16 KB memory pages.
https://android-developers.googleblog.com/2025/05/prepare-play-apps-for-devices-with-16kb-page-size.html

Libraries that do not support 16 KB:
base/lib/arm64-v8a/libe_sqlite3.so
base/lib/x86_64/libe_sqlite3.so

Will there be any added support for this?

[ericsink]

I am working on this and will hopefully have it ready soon.

[uwe-neuronation]

any progress here?

[ericsink]

This is fixed in SQLitePCLRaw 3.0, which should be out in the next week or so. See ericsink/SQLitePCL.raw#634

[phillippschmedt]

Hi @ericsink

thanks your help.

I have been using sqlite-net-sqlcipher and I am not very familiar with SQLitePCL.raw at all. Will I be able to use sqlite-net-sqlcipher together with version 3.0 of SQLitePCLRaw?
You said you are not publishing encryption builds anymore. I am not sure what that means as a user of sqlite-net-sqlcipher. As far as I understand you will not publish SQLitePCLRaw.bundle_e_sqlcipher anymore, does that mean the 16 KB Page size problem is only fixed if I am not using SQLitePCLRaw.bundle_e_sqlcipher?

Thanks a lot!

[ericsink]

@phillippschmedt

does that mean the 16 KB Page size problem is only fixed if I am not using SQLitePCLRaw.bundle_e_sqlcipher

Basically, yes.

The "fix" for this problem is in the way the native SQLite library is compiled. So the various SQLite libraries I maintain are now compiled properly for the 16 KB requirement, but since I'm not building SQLCipher anymore, that won't help your particular case.

You can purchase supported SQLCipher builds from Zetetic. Or you can purchase a license for SEE from sqlite.org and the corresponding nuget builds from SourceGear.

Currently (AFAIK) the only no-cost option for SQLite encryption is to build the libraries yourself.

[jerminContractor]

@praeclarum since the issue is now fixed in SQLitePCLRaw 3.0, are you going to provide a new release for this package as well? If yes, please let me know when should I expect a new version to be out?

[ericsink]

The update to SQLitePCLRaw 3.0 is not difficult, but not trivial. I can send a pull request if that would be helpful.

[jerminContractor]

@ericsink I am not looking to be a contributor, I only need to use it in my project. If that's fine by you, you can send the pull request.

[ericsink]

@jerminContractor My pull request comment was referring to a PR for this repo, sqlite-net, and was directed at @praeclarum

He is adding me as a maintainer of this project, so I'll be getting this fixed soon.

[xiufengpeng]

Thank you very much! Seems the latest .net maui nuget package sqlite-net-pcl doesn't have the 3.0 package. by any chance, do you know when the sqlite-net-pcl update will be released?

This is fixed in SQLitePCLRaw 3.0, which should be out in the next week or so. See ericsink/SQLitePCL.raw#634

[xiufengpeng]

Oops, just saw another thread #1282, really look forward to it. Thnx

[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 .

[MihaMarkic]

@ericsink After minor testing so far, database opens and no errors on read. Seems working. But didn't do a serious one yet.

[MihaMarkic]

While the combo I've been using so far (beta is from today's test)

<PackageReference Include="sqlite-net-pcl" Version="1.10.196-beta" />
<PackageReference Include="SQLitePCLRaw.provider.dynamic_cdecl" Version="3.0.2" />

throws at runtime

System.TypeInitializationException: The type initializer for 'SQLite.SQLiteConnection' threw an exception.
---> System.TypeLoadException: VTable setup of type SQLitePCL.SQLite3Provider_e_sqlite3 failed
at SQLite.SQLiteConnection..cctor()