SQLite Programming Tutorials & Engineering Articles

The chDB Durable Layer keeps agent memory fast to query locally while making its analytical state recoverable across laptops, CI jobs, and short-lived sandboxes.

Use ClickHouse to load Parquet files into MySQL, explore remote data, and run MySQL queries with table functions and named collections.

Every NVIDIA CUDA Toolkit release adds functionality and performance improvements that help developers get more from NVIDIA GPUs and the broader NVIDIA software…

Google has officially released version 1.0 of the Agent Development Kit (ADK) for Kotlin, achieving full feature parity with the Python and Java ADK cores to enable idiomatic, multi-agent AI development. Built on Kotlin Multiplatform (KMP), the framework leverages Kotlin Symbol Processing (KSP) for zero-reflection, type-safe function calling, alongside advanced orchestration capabilities like human-in-the-loop workflows and context compaction. Additionally, the release introduces a robust suite of Android-first extensions, allowing mobile developers to integrate local models via LiteRT-LM, cloud reasoning through Firebase AI, session persistence using Room, and semantic memory powered by AppSearch.

Enterprise work spans messages, decisions, projects, and obligations that change over time. An AI agent that starts without this context must reconstruct it…

ClickGap reviews merged ClickHouse changes, executes reproducers, rejects false positives, and attributes regressions to specific commits.

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.