locked
Using SQLite in Windows 8.1? RRS feed

  • Question

  • The documentation on retargeting your project in visual studio 2013 says the current version of SQLite may not be supported as part of windows 8.1 project but to check the visual studio readme for workarounds. I've checked the visual studio readme and cannot find a workaround.

    At the moment I'm unable to actually test any new windows 8.1 features in my application because I can't build it because it gives me the message "The SDK "SQLite for Windows Runtime" depends on the SDK "Microsoft.VCLibs, version=11.0", which is incompatible with projects targeting platform version "8.1".

    What can I do to work around this in the meantime?

    Stefan

    Friday, June 28, 2013 10:45 PM

Answers

  • Good news, a prebuilt one is now available from here: http://www.sqlite.org/download.html.  I don't know whether it was there before and I missed it, or it just appeared... anyway hopefully this will help others looking for it
    • Marked as answer by StefanOlson Saturday, June 29, 2013 1:12 AM
    • Unmarked as answer by StefanOlson Saturday, July 6, 2013 7:59 PM
    • Marked as answer by StefanOlson Saturday, July 6, 2013 7:59 PM
    Saturday, June 29, 2013 1:12 AM
  • @Klaus - it is important to note that SQLite is not a Microsoft product.  I only say that because it is not aligned with any "RTM" feature set for us.  They have an active development team that continually improves the SQLite product with regular releases.

    Choosing SQLite is an excellent choice for local db support if you need that.  It isn't the only choice, but certainly the most portable.


    Tim Heuer | Program Manager, XAML | http://timheuer.com/blog | @timheuer

    (if my post has answered your question, please consider using the 'mark as answer' feature in the forums to help others)

    Thursday, July 11, 2013 4:56 PM

All replies

  • Unfortunately there is no workaround due to the library dependency. You will need the updated version of SQLLite to get this scenario working. Maybe a good idea to post this same question on the SQLLite forum/support page.

    Thanks,

    Prashant.


    @prashantphadke || Windows Store Developer Solutions #WSDevSol || Want more solutions? See our blog, Windows Store & Phone Developer Solutions

    Saturday, June 29, 2013 12:16 AM
    Moderator
  • I believe you'll need a sqlite DLL built for 8.1. I don't know when a prebuilt one will be available, but you could try building it yourself. Sqlite site may have more details.
    Saturday, June 29, 2013 12:17 AM
    Moderator
  • Good news, a prebuilt one is now available from here: http://www.sqlite.org/download.html.  I don't know whether it was there before and I missed it, or it just appeared... anyway hopefully this will help others looking for it
    • Marked as answer by StefanOlson Saturday, June 29, 2013 1:12 AM
    • Unmarked as answer by StefanOlson Saturday, July 6, 2013 7:59 PM
    • Marked as answer by StefanOlson Saturday, July 6, 2013 7:59 PM
    Saturday, June 29, 2013 1:12 AM
  • Hi, how should we add reference to the downloaded SQLite DLL in visual studio 2013?
    Tuesday, July 9, 2013 9:39 AM
  • @parsanna - download their Extension SDK: http://www.sqlite.org/download.html and then you will be able to reference it.

    Tim Heuer | Program Manager, XAML | http://timheuer.com/blog | @timheuer

    (if my post has answered your question, please consider using the 'mark as answer' feature in the forums to help others)

    Tuesday, July 9, 2013 3:24 PM
  • @parsanna,

    Be aware that whilst you can create an application and debug it on your local machine you won't be able to deploy anything using sqlite, due to problems described here: http://social.msdn.microsoft.com/Forums/windowsapps/en-US/9f9fa8fa-aa36-472d-88de-2e5df02e8a11/why-am-i-having-a-problem-using-sqlite-on-my-tablet

    Tuesday, July 9, 2013 9:00 PM
  • Hey Tim,

    btw: thanks again for your very helpful, entertaining and competent presentation at the BUILD conference (sorry to hear, your "Calisto Baby is dying", as you said it :-) ), I again enjoyed your talk as much as I enjoyed it last time you spoke at the MVP summit, and in this context:

    Will be or is SQLite considered best practice to integrate local Database functionality in WinRt Apps ... at this time? Or, to put it another way: would it be worth waiting for - for example - SQLite becoming more mature with the RTM of 8.1 aaaand maybe because there could be the chance for an alternative whatever that might be?

    Or, if you would start with your own Win RT app, and you wanted to be as sure as one could be at this time that there would not be another baby at stake in the future, would you consider picking SQLite for that task to end yourself at this time?

    Best from Germany and many thanks

    Klaus
    Microsoft VB MVP
    (and not at all ashamed of it! :-) )

    Thursday, July 11, 2013 7:29 AM
  • @Klaus - it is important to note that SQLite is not a Microsoft product.  I only say that because it is not aligned with any "RTM" feature set for us.  They have an active development team that continually improves the SQLite product with regular releases.

    Choosing SQLite is an excellent choice for local db support if you need that.  It isn't the only choice, but certainly the most portable.


    Tim Heuer | Program Manager, XAML | http://timheuer.com/blog | @timheuer

    (if my post has answered your question, please consider using the 'mark as answer' feature in the forums to help others)

    Thursday, July 11, 2013 4:56 PM
  • Thanks, Tim!
    Saturday, July 20, 2013 3:18 PM
  • I keep receiving error messages whenever I attempt to add the x86 debug dll to my project.

    Is there anything specifically I need to do in addition to or before referencing the dll?

    Thursday, August 1, 2013 2:14 PM
  • @Bizmonger -- don't reference the DLL directly, reference the SDK package (Add Reference -> Windows -> Extensions).  SQLite is a native DLL and can't be directly referenced as you are trying.

    Tim Heuer | Program Manager, XAML | http://timheuer.com/blog | @timheuer

    (if my post has answered your question, please consider using the 'mark as answer' feature in the forums to help others)

    Thursday, August 1, 2013 2:19 PM
  • Thanks for the quick response. I'm not sure how to reference the SDK package. SQLite does not show up as an extension like it use to before I migrated to 8.1. I even rebooted my machine after downloading the SDK.

    When I attempt to browse to the files that I downloaded, the default filter is set to type DLL.

    What step am I missing?

    Thanks again.

    Thursday, August 1, 2013 2:52 PM
  • @Scott - if you have re-targeted to 8.1, you'll need their preview bits for SQLite -- http://sqlite.org/download.html -- one of the top links.

    Tim Heuer | Program Manager, XAML | http://timheuer.com/blog | @timheuer

    (if my post has answered your question, please consider using the 'mark as answer' feature in the forums to help others)

    Thursday, August 1, 2013 3:18 PM
  • Hey I downloaded and installed the assembly from that site but the SQLite extension does not appear when I attempt to add the reference.

    I usually rely on NuGet and things just work when adding a reference / extension through the Manage NuGet menu item.

    Thursday, August 1, 2013 4:18 PM
  • @Scott -- when you say "assembly" from that site, what do you mean?  You want the VSIX download in the first section (pre-release).  Double-click the VSIX and it will install the Extension SDK.  Again, you don't want direct DLL download (or reference here).

    sqlite-winrt81-201307110309.vsix is the file you want.


    Tim Heuer | Program Manager, XAML | http://timheuer.com/blog | @timheuer

    (if my post has answered your question, please consider using the 'mark as answer' feature in the forums to help others)

    Thursday, August 1, 2013 6:55 PM
  • I'm running Windows 8.1 with the default IE browser version for it.

    When I download the sqlite-winrt81-201307110309.vsix file and unzip it, I only see the extension.vsixmanifest file.

    I do not see any "vsix" file extension in the list of files after extracting the files from the conmpressed folder.

    When I double-click extension.vsixmanifest, it launches VS2013 and displays XML.

    Sorry if I'm just not getting it, but I sincerely do not see a file that I can just run as an install.

    Sincerely Scott Nimrod / AKA Bizmonger

    Friday, August 2, 2013 10:41 AM
  • @Bizmonger - rename your downloaded .zip to .vsix and double-click it.

    Tim Heuer | Program Manager, XAML | http://timheuer.com/blog | @timheuer

    (if my post has answered your question, please consider using the 'mark as answer' feature in the forums to help others)

    • Proposed as answer by Scott Nimrod Monday, August 5, 2013 10:58 AM
    Friday, August 2, 2013 8:39 PM
  • Thanks Tim.

    I had to launch the CommandLine and use the Rename command to rename the file with the vsix extension. I was then able to launch the install process via the command line.

    Monday, August 5, 2013 11:00 AM