#
SQLite Programming Tutorials & Engineering Articles
143 SQLite tutorials, guides, and engineering insights from Fly.io, Cloudflare, NVIDIA, and more
Companies Using This
SQLite Articles & Tutorials
Filter:
JSONBench now compares 27 database engines. ClickHouse still leads on a billion JSON documents. Explore the results and run the benchmark yourself.
5 min read
Includes Code
--
To start, here’s the status quo: every Fly Machine gets a private IPv6 address, and every other Machine in your organization can reach it. We call that network 6PN. It’s what my-db.internal points at, and it’s how your app server talks to your databa
Daniel Botha, Peter Cai
12 min read
Includes Code
--
Durable workflows, running inside your service with no separate orchestration cluster.
Andriy Sergiyenko
7 min read
Includes Code
--
ClickHouse 26.10 introduces function composition, more flexible joins, faster GROUP BY queries, disk spilling for IN subqueries, an experimental columns cache, and Freeform and SQLite formats.
26 min read
Includes Code
--
Use this open-source tool to correlate workload-scoped logs, metrics, and scheduler state into a reproducible diagnosis on your own cluster.
Elizabeth Goodman
9 min read
Includes Code
--
Meet GroeneAI, ClickHouse’s autonomous engineering agent that contributed more than 3,000 merged pull requests in under seven months.
21 min read
Includes Code
--
When work on Sprites started, it was a new kind of infra for a new kind of product. So when we couldn’t find the right filesystem in the pasta section, we made our own. It was clever, and that’s exactly why we didn’t like it. This post introduces its
Daniel Botha
7 min read
Includes Code
--
How our engineering team ran Gemini 4 Argon unattended overnight with .agents/skills and /goal mode to cut in-memory session prep overhead by 40% in long sessions and speed up cold imports by 21% in Google's open-source Python Agent Development Kit (ADK).
Practical lessons from KGMON’s KDD Cup 2026 system for building reliable data analytics agents with constrained tools, persistent state…
EmbeddingGemma 2 is a new 740M open-weight multimodal model that maps text, images, video, and audio into a unified vector space for privacy-first, on-device retrieval. Developers can easily integrate these capabilities cross-platform using MediaPipe Tasks or optimize fine-grained performance across CPU, GPU, and NPU accelerators with LiteRT. The model enables ultra-low-latency local solutions like search-as-you-type media retrieval, keyframe video moments finding, and zero-shot intent routing.
Google AI Edge Team, Android ML Team
11 min read
Includes Code
--
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…
Tanya Lenz
6 min read
--
ClickGap reviews merged ClickHouse changes, executes reproducers, rejects false positives, and attributes regressions to specific commits.
22 min read
Includes Code
--
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…
Michelle Horton
9 min read
Includes Code
--
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.
14 min read
Includes Code
--
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.
14 min read
Includes Code
--
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.
18 min read
Includes Code
--
How Airbnb built a Kubernetes sidecar to deliver dynamic configuration reliably at scale.
Bo Teng
11 min read
--
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.
AWSCloudflare WorkersGitGitLabHTTPSJavaScriptJSONNode.jsPythonREST APIRustSQLiteTypeScriptWebAssemblyZig
15 min read
Includes Code
--
26 min read
Includes Code
--
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
Context engineering is the biggest lever you have over AI agent quality — here's what it looks like when you invest in it over a few weeks of real work.
Daniel Botha
6 min read
Includes Code
--
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...
Nick Kuntz
9 min read
Includes Code
Has Summary
--
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.
Raymond Xu
6 min read
Includes Code
Has Summary
--
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.
Shopify Engineering
12 min read
Has Summary
--
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 ...