Recently released SQLite 3.9 provides a number of new features and enhancements, including support for JSON encoding/decoding, full text search version 5, indexes on expressions, eponymous virtual tables and more.
Realm is an open-source, object oriented, mobile database. Last month, Realm for Android was released, less than 3 months after the iOS version was first available and it comes with a fluent, strongly typed API.
Microsoft is now offering an official version of SQLite for Windows Phone, Windows Store, and .NET 4.5. The library is available as a Portable Class Library, so developers can use as a basis for their own portable libraries.
SQLite WinRT Wrapper has been released on CodePlex which provides lightweight APIs for the development of Windows Phone 8 applications. It includes functions for opening a database, execution and creation of SQL statement in addition to binding parameters and iteration over statement results.
Syncfusion has announced the availability of Orubase Version 1 which ships with Project Wizard, SQLite and Encryption Support.
SQLite is now supported on Windows RT, Windows 8 Metro Apps and will be supported on Windows Phone 8 for local application storage.
When working with iOS and MonoTouch, you may find yourself needing to display data from a SQLite table. While this can be done directly by building up your own UITableViewController, the process can be quite time consuming with quite a bit of boilerplate code. Jeffrey Stedfast has found a way to reduce simple table binding to what’s basically a single method with MonoTouch.SQLite.
InfoQ announced the porting of SQLite to .NET two weeks ago. Because the community showed special interest in this project, we interviewed Noah Hart, the developer who did it, to find out how SQLite was re-written in C#.
Noah Hart has ported SQLite3 to C#. While the first port is slower than the original, the project opens the way for SQLite to be used in .NET managed projects without using P/Invoke or unsafe code.
In this article Billy McCafferty presents S#arp Architecture, an ASP.NET MVC architectural framework meant to leverage current best practices in architecting ASP.NET web applications by providing a project code template which uses Domain-Driven Design techniques and has built-in support for NHibernate, Castle Windsor and SQLite.
Besides Postgres, NeverBlock now also supports MySQL through the new MySQLPlus adapter. We talked to two of the developers of MySQLPlus and discussed NeverBlock and non-blocking database adapters with developers of Ruby's Oracle and SQLite interfaces.
SQLite is an open source database that has been growing in popularity. It's footprint is small and is used in a wide-variety of types of applications.
A Ruby driver for HSQLDB has been released on RubyForge by Jared Richardson. The driver relies on Java Bridge technology (quite different than JRuby) to interop with the Java-based HSQLDB (formerly HypersonicSQL) open-source database.
SQLite is a lightweight database engine written in C. Designed to be cross-platform, it doesn't have any external dependencies and only takes about 250 KB of disk space. Though it doesn't support all of SQL92, it is suitable for smaller projects, especially ones that need cross-platform support. And to top it all off, the source code is in the public domain.