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

Activity

1. SunboX

   added

   1. to develop

   enhancement

   help wanted

   low

   on Apr 23, 2017
2. DecaTec commented on Apr 24, 2017

   

   DecaTec

   on Apr 24, 2017

   Collaborator

   More actions

   Is there any need for this change?
3. SunboX commented on Apr 24, 2017

   

   SunboX

   on Apr 24, 2017

   Last edited by SunboX

   MemberAuthor

   More actions

   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/