Reminder : Sqlite is already inside #Windows 10 – no need to include it in your #UWP apps !

, , Comments Off on Reminder : Sqlite is already inside #Windows 10 – no need to include it in your #UWP apps !

I have read, as a maybe a lot of you, that Sqlite is now shipped with Windows 10 : it’s true. Let’s see how you can target it.

I am a big fan of the sqlite-net github project and I nearly alwayse include it’s 2 sources file in my projects needing to do some Sqlite. If youd dig in the source file, you will see that it declares a lot of DllImport using “sqlite3”. This mean that you have to include the sqlite3.dll in your app and that it will be shipped with it. Since the threshold version, you can use the version shipped with Windows10 by replacing all this “Sqlite3” by “winsqlite3”. That’s it !

winsqlite

Why you may want to do this

  • Your app package will be smaller.
  • Faster : the dll should be already loaded by the OS when you need it.
  • You won’t have to install the Sqlite VSIX package.
  • You will be on the same version of Sqlite than Windows (Youpi!).

Why you may NOT want to do this

  • You won’t be using the latest version of Sqlite. If you depend of the latest available fix, it won’t be available.
  • Sqlite may be updated by Windows and bring breaking changes to your app.

The full doc (for C++) is available on MSDN : https://msdn.microsoft.com/vi-vn/windows/uwp/data-access/sqlite-databases

Happy coding !