How Fly.io Uses SQLite

This article by Ben Johnson explains two major new features added to Litestream's Virtual File System (VFS): writable mode and background hydration.

This article explains the design and implementation of Sprites, Fly. io's new product offering instant-creation Linux VMs with 100GB durable storage backed by object storage.

Fly. io introduces 'Sprites' — durable, persistent cloud computers designed as an alternative to ephemeral sandboxes for AI coding agents.

Litestream VFS is a new SQLite plugin that enables querying databases directly from S3-compatible object storage without downloading the entire database.

Thomas Ptacek argues that every developer should build an LLM agent to truly understand the technology, demonstrating through progressive Python code examples that a functional agent with tool use ...

The article discusses Corrosion, a novel service discovery system developed by Fly. io that addresses the challenges of state synchronization in distributed systems.

Litestream v0. 5.

The article discusses a complex concurrency bug encountered in Fly. io's Anycast router, implemented in Rust.

Litestream is an open-source tool designed to enhance the reliability of SQLite applications by enabling them to recover data from object storage.

The article discusses the operationalization of Macaroon tokens at Fly. io, detailing their implementation, benefits, and challenges.

The article features an exit interview with JP Phillips, a key member of the Fly. io engineering team, who reflects on his four years at the company.

The article discusses the complexities and solutions involved in migrating stateful applications on Fly.

The article discusses the development of an open-source AI image description service using large language models (LLMs) like LLaVA and tools such as Ollama and PocketBase.

The article discusses Fly. io's innovative approach to enhancing WireGuard's performance and scalability by implementing Just-In-Time (JIT) peer configuration.

The article discusses the implementation of Macaroons, a flexible and user-editable security token system designed to enhance API security.

Fly. io introduces Fly Kubernetes (FKS), a new implementation of Kubernetes that runs on its platform, allowing users to leverage Kubernetes tooling while benefiting from Fly. io's infrastructure.

The article discusses the new features of Fly. io, a public cloud platform designed to run applications closer to users for improved performance.

The article discusses the innovative approach of using LiteFS to eliminate the API layer between services by shipping SQLite databases directly to clients.

The article discusses LiteFS, a tool for managing SQLite databases in a distributed environment, focusing on how it ensures application-level consistency.

The article discusses the integration of Bun, a JavaScript runtime aiming for complete Node. js API compatibility, with Fly. io, a platform for deploying applications.

LiteFS Cloud is a new service from Fly. io that provides managed backups and point-in-time restores for LiteFS, a distributed SQLite database.

The article discusses Fly. io's recent fundraising efforts, including a total of $95 million raised from investors like A16Z, Intel Capital, and EQT Ventures.

The article discusses the Fly Replay feature on Fly. io, which allows applications to reroute HTTP requests based on the 'fly-replay' header.

The article discusses the evolution of Fly. io's scheduling system, detailing the transition from traditional orchestrators like Kubernetes and Nomad to a custom-built solution called flyd.

The article discusses the introduction of Write-Ahead Logging (WAL) mode in LiteFS, a distributed file system for SQLite databases.

The article discusses the development of Fly Postgres, a database offering by Fly. io, detailing its evolution from a platform without durable storage to an automated database solution.

LiteFS is an open-source distributed file system designed for SQLite, enhancing its capabilities for full-stack applications.

This article provides a comprehensive guide on creating a scale-to-zero Minecraft server using Terraform and Fly Machines.

The article explains how the SQLite Virtual Machine operates, detailing the processes of parsing, optimizing, and executing SQL queries.

The article explores how SQLite scales read concurrency through its Write-Ahead Logging (WAL) mechanism, contrasting it with the traditional rollback journal.

This article discusses the process of building a remote in-browser IDE using Fly.

This article explores how SQLite implements ACID properties through its rollback journal mechanism.

The article discusses Fly. io's storage volumes, focusing on recent enhancements such as the ability to extend volume sizes and perform self-service snapshot restores.

The article delves into the internals of SQLite, focusing on how it manages data using pages and B-trees.

The article discusses the launch of Laravel Bytes, a new resource for deploying Laravel applications globally on Fly. io.

This article discusses a memory leak issue encountered in the Rust-based proxy, fly-proxy, and details the process of identifying and resolving the leak.

The article provides a detailed log of updates and changes made at Fly. io over the past week, highlighting new features, fixes, and improvements to enhance user experience and system performance.

The article discusses the advantages of using SQLite as a central database for full-stack applications, emphasizing its reliability and performance.

The article discusses recent updates and improvements made by Fly. io to enhance application performance and security.

The article discusses the introduction of free PostgreSQL databases on Fly. io, emphasizing the addition of 3GB of persistent volume space to their free tier, which is essential for small projects.

The article discusses how to utilize Datasette, a tool for sharing and exploring datasets, in conjunction with Fly, a platform for deploying applications.