Starbase: SQLite on the Edge
Starbase is a scalable database solution utilizing SQLite and Cloudflare Durable Objects, supporting ACID transactions, easy installation via command line, and resources for creating HTTP-accessible SQLite servers.
Read original article
Starbase is a scalable, zero-configuration database solution built on Cloudflare Durable Objects, designed to provide a plug-and-play experience with SQLite. It offers a straightforward installation process via a command line script. The platform is focused on enhancing SQLite's capabilities, particularly in supporting ACID transactions, which are crucial for ensuring data integrity. Additionally, it provides resources for developers to create their own HTTP-accessible SQLite database servers using Cloudflare Durable Objects. Starbase aims to keep users informed with a strategy guide that includes the latest tips, features, and updates.
- Starbase is a scalable database solution based on SQLite and Cloudflare Durable Objects.
- It supports ACID transactions for improved data integrity.
- Users can install Starbase easily using a command line script.
- The platform offers resources for building HTTP-accessible SQLite database servers.
- A strategy guide is available to keep users updated on features and best practices.
Related
Appropriate Uses for SQLite
SQLite is a lightweight, serverless database engine ideal for local data storage in embedded systems, supporting low to medium traffic websites, data analysis, and serving as a cache, but unsuitable for high concurrency.
Show HN: Node.js ORM to query SQL database through an array-like API
Qustar is a TypeScript library for querying SQL databases, supporting PostgreSQL, SQLite, MySQL, and MariaDB, with a high-level query builder and immutable queries for safe reuse.
SQLite is not a toy database
SQLite is a versatile, serverless database management system that supports advanced features, efficiently handles large datasets, and is suitable for small web applications, countering misconceptions about its limitations.
Zero-latency SQLite storage in every Durable Object
Cloudflare's Durable Objects now feature zero-latency SQLite storage, enabling synchronous SQL queries, enhancing performance, supporting scalability, allowing fast writes with data durability, and offering point-in-time recovery within 30 days.
SlateDB – An embedded database built on object storage
SlateDB is an embedded storage engine using object storage for high durability and scalability. It features a zero-disk architecture, tunable performance, and supports multiple readers with a single writer.
- Many users question how Starbase differs from Cloudflare's recent SQLite offerings, particularly regarding features and architecture.
- There are concerns about data loss and the implementation of query caching, with some users expressing skepticism about the system's reliability.
- Several comments highlight the website's design, with mixed opinions on its aesthetic appeal versus the clarity of the product's explanation.
- Users are curious about the technical aspects, such as database-level locking, concurrency, and isolation properties.
- Some commenters express excitement about the potential of the technology, while others seek clarification on its operational requirements and dependencies on Cloudflare.
20 commentsDO implements a very comprehensive strategy to mitigate data loss in DO backed by SQLite. But Starbase seems to add a layer of query caching on the application level, which seems to be naively implemented (I might be misunderstanding, please correct if I'm wrong).
[1] https://starbasedb.com/blog/developing-acid-transaction-supp...
Update: bug in redirection: https://starbasedb.com/blog/blog/blog/blog/blog/blog/develop...
Zero-latency SQLite storage in every Durable Object
D1 is SQLite
Pretty excited about this tech, it really flips the script on the concept of a DB per user / sharding approach which used to be costly at the schema/physical db level.
What is the architecture overview? Does each worker have a copy or do all of them work on the same DB files? How does it handle concurrent workers and db locking? Is SQLite native locking mechanism sufficient in this application?
Last time I saw that was zendesk with their Buddha's and weird tonal audio devices.
Edited for corrected semi-colon because I'm haunted by a grammar-nazi.
I'm not sure if I misunderstood something, but using a global queue/lock to enforce isolation properties seems to be just a little disingenuous for a dbms. It works, but it's odd to talk about isolation in a system with zero concurrency. It's like saying a bicycle gets infinite miles per gallon in fuel efficiency.
Related
Appropriate Uses for SQLite
SQLite is a lightweight, serverless database engine ideal for local data storage in embedded systems, supporting low to medium traffic websites, data analysis, and serving as a cache, but unsuitable for high concurrency.
Show HN: Node.js ORM to query SQL database through an array-like API
Qustar is a TypeScript library for querying SQL databases, supporting PostgreSQL, SQLite, MySQL, and MariaDB, with a high-level query builder and immutable queries for safe reuse.
SQLite is not a toy database
SQLite is a versatile, serverless database management system that supports advanced features, efficiently handles large datasets, and is suitable for small web applications, countering misconceptions about its limitations.
Zero-latency SQLite storage in every Durable Object
Cloudflare's Durable Objects now feature zero-latency SQLite storage, enabling synchronous SQL queries, enhancing performance, supporting scalability, allowing fast writes with data durability, and offering point-in-time recovery within 30 days.
SlateDB – An embedded database built on object storage
SlateDB is an embedded storage engine using object storage for high durability and scalability. It features a zero-disk architecture, tunable performance, and supports multiple readers with a single writer.