search

nextcloud / windows-universal

📱 Nextcloud Windows Mobile app
https://www.microsoft.com/store/apps/9nblggh532xq
Mozilla Public License 2.0
59 stars 34 forks source link

Use build in SQLite of Windows 10 Anniversary Update (Build 14393) #117

Open SunboX opened 7 years ago

SunboX commented 7 years ago

Instead of SQLite.Net-PCL use the wrapper Microsoft.Data.Sqlite (Nuget) for the build in SQLite database of the Windows 10 Anniversary Update (Build 14393)

DecaTec commented 7 years ago

Is there any need for this change?

SunboX commented 7 years ago

Not now, app size will be smaller and the app will start faster (if another app already made use of the build in SQLite before)

This comes with some advantages:

  • Your application size reduces since you don’t download your own SQLite binary and package it as part of your application
    • Note: Microsoft.Data.SQLite (used in the example below) currently has an issue where both SQLite3.dll and WinSQLite.dll are loaded in memory whenever a .NET Native version of your application is run. This is a tracked issue that will be addressed in subsequent updates of the library.
  • You can depend on the Windows team to update the version of SQLite running on the operating system with every release of Windows.
  • Application load time has the potential to be faster since the SDK version of SQLite will likely already be loaded in memory.

See: https://blogs.windows.com/buildingapps/2017/02/06/using-sqlite-databases-uwp-apps/