Monthly Archives: June 2012

SQLite on Windows 8

sqlite370_bannerThe amazing little SQLite database engine now officially supports Windows 8 Metro style applications. It sounds like this was done with the full endorsement of Microsoft so you should have no trouble including it in your Metro style apps and get the blessing of our friendly Windows Store custodians. I believe this covers Windows Phone 8 as well. Here is the news:

SQLite version 3.7.13 adds support for WinRT and metro style applications for Microsoft Windows 8. The 3.7.13 release is coming sooner than is usual after the previous release in order to get this new capability into the hands of developers. To use SQLite in a metro style application, compile with the -DSQLITE_OS_WINRT flag. Because of the increased application security and safety requirements of WinRT, all database filenames should be full pathnames. Note that SQLite is not capable of accessing databases outside the installation directory and application data directory. This restriction is another security and safety feature of WinRT. Apart from these restrictions, SQLite should work exactly the same on WinRT as it does on every other system.

Thanks D. Richard Hipp!

Update: I’ve started a miniseries on SQLite with C++ in Visual Studio Magazine. You can read the first installment here. I also cover SQLite in my new course, 10 Practical Techniques to Power Your Visual C++ Apps.

Did we just kill the mouse?

mouseMany people seem to think that Windows 8 has abandoned the traditional keyboard/mouse duo in favor of touch as the primary human interface device. It struck me that this is not quite accurate. Yes, using the mouse seems to be less central and my first impression is that it is harder to navigate with the mouse but the keyboard seems as powerful as ever. If you are a big keyboard junky like me then you will be happy to note that Windows 8 is just as easy to navigate as Windows 7. I find touch to be more intuitive in Windows 8 (and Windows Phone) than the mouse was in Windows 7. On the other hand, the mouse provides a level of accuracy that is not yet available with touch. I cannot imagine using Photoshop or designing circuit board schematics without a mouse.