question

DavidHoffman-6474 avatar image
0 Votes"
DavidHoffman-6474 asked DavidHoffman-6474 commented

Which Database should I use in my C++/WinRT application?

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.

sql-server-generalwindows-uwpc++
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Castorix31 avatar image
3 Votes"
Castorix31 answered DavidHoffman-6474 commented

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)


· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.)

0 Votes 0 ·
Castorix31 avatar image Castorix31 ErlandSommarskog ·

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)

1 Vote 1 ·

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.

0 Votes 0 ·