Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
SunboX opened this issue Apr 23, 2017 · 2 comments
Open

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

SunboX opened this issue Apr 23, 2017 · 2 comments

Comments

@SunboX
Copy link
Member

SunboX commented Apr 23, 2017

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
Copy link
Collaborator

DecaTec commented Apr 24, 2017

Is there any need for this change?

@SunboX
Copy link
Member Author

SunboX commented Apr 24, 2017

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/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants