This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 31%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
I am struggling to figure out which database I should use in my UWP C++/WinRT app. Since the SQL query is similar, it does not matter if I use MSSql, MySql, or SQLite. For the most part I want to use just the basic types of SQL queries. No advanced features. I have used SQLite in a previous project as well as MSSql in a MFC project. The MFC code does not seem to be similar to anything in C++/WinRT as I can't seem to find corresponding API calls for the SQL functions. I am leaning towards SQLite, but I am not sure this will be a good choice as I am still learning UWP. Thoughts on the subject. Thanks.
You can use SQL Server Compact
I used it in a freeware in C++/Win32, with OLEDB and it works very fine (better than SQLite that I used first)
No, don't use SQL Server Compact. Microsoft stopped working with Compact Edition quite a few years back, so it is out of date.
I'm an SQL Server guy, and I don't much about UWP and WinRT. But I don't think SQL Server runs on WInRT. For simple stuff, SQLite may be the best choice. (But again, it's outside my area.)
SQL Server Compact works perfectly on Windows 10
I got absolutely no problem with all the users of my freeware for more than 10 years
And performances are a lot better than SQLite, in particular for complex queries (as I said I used SQLite first, but I had freezes on some queries, so it was unusable and I had to replace it with SQL CE)
I did a little checking and SQL Server Compact most certainly can be used in Win10 and the latest update was back in 2020 so it also seems to still be getting regular updates. The VSIX package has both SQLite and SQL Server Compact in the same package. I will try the compact one and see if it works for me. Thanks.