search

praeclarum / sqlite-net

Simple, powerful, cross-platform SQLite client and ORM for .NET
MIT License
4.03k stars 1.42k forks source link

SQLite version and how to upgrade it #1234

Closed pme442 closed 3 months ago

pme442 commented 3 months ago

I have a cross-platform Xamarin Forms app. I also have a .NET Maui app that is build in .NET 8 which is showing me the same results.

When I run the following code, it returns: sqlversion = 3.39.2: string query = string.Format(@"SELECT SQLITE_VERSION()"); var sqlversion = _db.ExecuteScalar(query); Debug.WriteLine("sqlversion = " + sqlversion);

All of my Nuget packages are updated to the latest. For example, in my iOS.csproj: sqlite-net-pcl = 1.9.172 sqlite-net-sqlcipher = 1.9.172
SQLitePCLRaw.bundle_e_sqlcipher = 2.1.8 SQLitePCLRaw.bundle_green = 2.1.8

Where is it getting 3.39.2 from?
Is there something else I need to update in order to bump it up? I need it to be at 3.44.0 or higher.

pme442 commented 3 months ago

Found my answer. The version is coming from e_sqlcipher (which is not up-to-date). If I open the database without encryption, the version is the most current (3.45).