SQLite for Windows and Windows Phone: Data Definition

SQLite

SQLite WinRT allows Windows and Windows Phone developers to create and manipulate database objects through the SQLite Data Definition Language (DDL). SQLite supports DDL statements including CREATE, ALTER, and DROP to work with objects like Tables, Indexes, Triggers, and Views.  This is complimented by simplified, dynamic data types including INTEGER, NULL, REAL, TEXT, and BLOB.  Admittedly, this takes some … Read more SQLite for Windows and Windows Phone: Data Definition

SQLite for Windows and Windows Phone: Installation

SQLite

SQLite WinRT empowers Windows and Windows Phone developers to build mobile enterprise apps using Windows Runtime (WinRT) APIs to work with the world’s most popular mobile database. SQLite advantages include cross-platform (OS + Processor) support, speed, ACID reliability, and support for indexes, views, foreign keys, and triggers.  Developers of SQLite apps on iPhones, iPads and Android devices … Read more SQLite for Windows and Windows Phone: Installation

Getting Started with SQLite on Windows 8 > Installation

SQLite

Over the summer of 2012, Microsoft announced support for SQLite on both Windows 8 and Windows Phone 8. This is exciting news because it allows developers to build enterprise and consumer apps that utilize the world’s most widely used embedded database engine.  We all know that there’s no such thing as ubiquitous wireless connectivity and … Read more Getting Started with SQLite on Windows 8 > Installation