InfoQ Homepage SQLite Content on InfoQ
-
Scale Higher Per-Database Storage Limits and Create More Databases with Cloudflare D1 Open Beta
Cloudflare recently announced the open beta of its D1 serverless relational database built on SQLite. The open beta of D1 continues on earlier company investments, with the most recent enhanced performance. With the open beta of D1, the company adds higher per-database storage limits and the ability to create more databases.
-
Cloudflare Enhances Performance for Serverless Database D1
Cloudflare recently announced a revamp of its serverless relational database D1. Built on top of SQLite, D1 has a new architecture that provides better read and write performances and support for JSON functions.
-
HC-tree is a High-Concurrency Backend for SQLite Supporting Replication
HC-tree is a project aimed at building a new backend for SQLite specifically optimized for high-concurrency and lead-follower style replication. While still experimental, HC-tree can be used as an SQLite drop-in replacement, albeit with limitations.
-
Cloudflare Previews Serverless Database D1 Adding Transactions
Cloudflare recently unveiled more details about the serverless database D1, the new service supporting SQLite to store and query relational data globally with low latency. D1 is the first SQL database from the content delivery network company and will support transactions.
-
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.