SQLite Programming Tutorials & Engineering Articles

Building a great AI agent isn’t just about choosing the right models. The harness is the architecture surrounding the model. How it renders context…

A walkthrough of adding OpenTelemetry instrumentation to two ASP.NET services — an Order API and a Payment Service — and shipping traces, logs, and metrics to ClickStack, with auto-correlated signals and cross-service trace waterfalls out of the box.

ClickHouse was released in open source on Jun 15 2016, ten years ago. Since then, it became the most popular open source analytical database with more than 2000 contributors.

chDB embeds a full ClickHouse query engine inside an agent's own process, turning data access, memory, and federation into local function calls instead of network round trips, cutting the latency, retries, and token waste that come with remote queries.

How Airbnb built a Kubernetes sidecar to deliver dynamic configuration reliably at scale.

How to transition from stateless chatbots to production-grade agents capable of managing long-running enterprise workflows, such as HR onboarding, that span days or weeks. It introduces the Agent Development Kit (ADK) and its architectural shifts, specifically using durable state machines and persistent session storage to ensure an agent never loses context during "idle time" or server restarts. By leveraging event-driven webhooks and multi-agent delegation, the tutorial demonstrates how to build resilient systems that "sleep" during pauses and wake up to resume complex tasks with high reasoning accuracy.

This blog post introduces a suite of six protocols, such as MCP and A2A, designed to eliminate custom integration code by standardizing how AI agents access data and communicate. Using a "kitchen manager" agent as a practical example, it demonstrates how these tools handle complex tasks like real-time inventory checks, wholesale commerce via UCP, and secure payment authorization through AP2. By leveraging the Agent Development Kit (ADK), developers can also implement A2UI and AG-UI to deliver interactive dashboards and seamless streaming interfaces to users.

By Bo Xu, Danny Zhang, and Rohit Arunachalam

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 demonstrates how to port a Matrix homeserver from traditional infrastructure (Synapse on VPS) to Cloudflare Workers, creating a serverless, zero-maintenance deployment with automatic p...

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.

The craft of engineering is rapidly changing. We built our own coding agent to accelerate faster.

The Universal Commerce Protocol (UCP) is an open-source standard developed by Google to facilitate seamless commerce experiences across various platforms.

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

The article discusses the implementation of Offline Mode in Notion, a feature that allows users to create, edit, and view pages without an internet connection.

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

Shopify open-sources Tangle, an ML experimentation platform built to solve six common failure modes in machine learning development.

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 enhancements made to the testing experience for Cloudflare Workflows, a durable execution engine for multi-step applications.

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.

This article discusses the development of an AI Agent that incorporates human input using Knock and Cloudflare's Agents SDK.

The article discusses optimizing Vanna's text-to-SQL inference using NVIDIA NIM to enhance analytics performance.

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.

This article provides a simplified introduction to CUDA, NVIDIA's parallel computing platform, and programming model.

The article discusses advancements in Cloudflare's Agents SDK, focusing on the integration of the Model Context Protocol (MCP) for AI agents, authentication and authorization enhancements, and the ...

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

The article discusses the development of Ramp's MCP server, which utilizes the Model Context Protocol (MCP) to enable natural language interaction with business data via a SQL interface.

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.

This article discusses the implementation of a Medallion architecture for Bluesky data using ClickHouse, focusing on the challenges of handling high-volume JSON event streams.

The article discusses the significant performance improvements of Cloudflare Queues, which utilize Durable Objects to enhance message processing speed and efficiency.

The article discusses the challenges and solutions involved in scaling the AI Gateway on the Cloudflare Developer Platform, specifically focusing on extending log storage capabilities from 30 minut...

The article discusses the development of Vectorize, a distributed vector database built on Cloudflare’s Developer Platform.

The article summarizes Cloudflare's 2024 Birthday Week, highlighting major announcements and innovations aimed at enhancing customer experience and contributing to the broader Internet community.

Cloudflare has developed a new container platform that leverages GPUs for running various applications across its global network.

Builder Day 2024 introduced 18 significant updates to the Cloudflare Workers platform, emphasizing improvements based on developer feedback. Key features include persistent logging, enhanced Node.