InfoQ Homepage SQLite Content on InfoQ
-
Cloudflare D1 Provides Distributed SQLite for Cloudflare Workers
Soon to enter beta, D1 is Cloudflare's first step into the Cloud-based SQL storage arena. D1 is built on top of SQLite with the addition of a distributed replication mechanism, batch operation support, embedded compute, automatic backups and redundancy, and more.
-
SQLite 3.38 Improves JSON Queries, Error Messages, and More
SQLite 3.38.0 is the latest release of SQLite, bringing improved syntax for JSON queries, a new diagnostic interface, CLI enhancements, and more.
-
Google Logica Aims to Make SQL Queries More Reusable and Readable
Logica is a Datalog-like declarative logic programming language for database querying. It supports the creation of reusable abstractions to build complex queries and compiles to SQL, thus making it suitable for wide application.
-
Open-Source Shark ORM for iOS Aims to Replace Core Data for High-Performance, Multi-Threaded Apps
Shark is a new open-source ORM framework for iOS that aims to be an easy-to-use replacement for Core Data by providing high-performance and thread-safety. InfoQ has spoken with Adrian Herridge, creator of Shark.
-
SQLite 3.9 Supports JSON, Indexes on Expressions and More
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 Brings SQLite Alternative to Android
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 OpenTech Brings SQLite to Windows Phone and Windows Store
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 with Lightweight APIs
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.
-
Orubase Version 1 with Project Wizard, SQLite and Encryption Support
Syncfusion has announced the availability of Orubase Version 1 which ships with Project Wizard, SQLite and Encryption Support.
-
SQLite On WinRT, Metro, Windows 8 Mobile
SQLite is now supported on Windows RT, Windows 8 Metro Apps and will be supported on Windows Phone 8 for local application storage.
-
Simplified UI Development with MonoTouch.SQLite
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.
-
Disclosing How C#-SQLite Was Ported to .NET
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#.
-
SQLite Has Been Ported to .NET
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.
-
Article: A Fusion of Proven Ideas: A Look Behind S#arp Architecture
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.
-
NeverBlock and Non-Blocking Database Adapters
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.