# SQLite SQLite is a C-language library that implements a self-contained SQL database engine. This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## A Daily Digest of What Actually Got Merged, Built from MQTT and a Local LLM DevFeed: [A Daily Digest of What Actually Got Merged, Built from MQTT and a Local LLM]() Original publisher: [Read original article]() Author: Philipp Lehmann (philipp.lehmann@gruppe.ai) Published: 2026-09-14T07:00:00Z Content type: article Language: en Sources: [Philipp Lehmann]() Topics: [pull-requests](), [MQTT](), [Large Language Model](), [SQLite]() Tags: [architecture](), [ci-cd](), [llm](), [local-llm](), [mqtt](), [observability](), [pull-requests](), [python](), [sqlite]() ### AI overview This article describes a daily digest that uses MQTT merge events, a SQLite subscriber, and a locally run LLM to summarize merged pull requests by repository without sending diffs to a cloud API. ### Source excerpt paho-mqtt subscriber to SQLite plus a local LLM: a daily digest that summarises merged pull requests per repository from diff stats, no cloud API. ## How to build a member portal with login and a dashboard in Webflow Cloud DevFeed: [How to build a member portal with login and a dashboard in Webflow Cloud]() Original publisher: [Read original article]() Author: Ismail Ajagbe Published: 2026-09-12T00:00:00Z Content type: tutorial Language: en Sources: [Webflow Blog]() Topics: [dashboards](), [Authentication](), [Database](), [SQLite](), [Nextra](), [Node.js](), [App]() Tags: [auth](), [authentication](), [cloud](), [data](), [database](), [guide](), [guides](), [how-to](), [next-js](), [node-js](), [platform](), [sqlite](), [webflow]() ### AI overview This tutorial explains how to build a Webflow Cloud member portal with login, a SQLite-backed data model, session-scoped queries, a member dashboard, and profile editing. It emphasizes deriving the member ID from the session rather than from the request so users can access only their own data. ### Source excerpt Learn how to build a member portal on Webflow Cloud where every query is scoped to the signed-in member. ## How to build a service marketplace with provider profiles in Webflow Cloud DevFeed: [How to build a service marketplace with provider profiles in Webflow Cloud]() Original publisher: [Read original article]() Author: Ismail Ajagbe Published: 2026-09-12T00:00:00Z Content type: tutorial Language: en Sources: [Webflow Blog]() Topics: [data-architecture](), [Database](), [SQLite](), [Next.js](), [Node.js](), [Authentication](), [Content Management System]() Tags: [data-modeling](), [database](), [guide](), [guides](), [how-to](), [next-js](), [node-js](), [sqlite](), [webflow]() ### AI overview A guide to building the discovery side of a service marketplace on Webflow Cloud. It explains why provider profiles should be modeled as database rows rather than CMS content when they require owner editing, flexible filtering, and approval before publication. ### Source excerpt Learn how to build the discovery half of a service marketplace on Webflow Cloud. ## github-to-sqlite 2.9.1 DevFeed: [github-to-sqlite 2.9.1]() Original publisher: [Read original article]() Author: Simon Willison Published: 2026-09-11T00:28:39Z Content type: release Language: en Sources: [Simon Willison's Weblog]() Topics: [GitHub](), [SQLite]() Tags: [compatibility](), [github](), [github-194](), [release](), [sqlite](), [sqlite-486]() ### AI overview github-to-sqlite 2.9.1 fixes compatibility with sqlite-utils 4.x. ### Source excerpt Release: github-to-sqlite 2.9.1 Fix for compatibility with sqlite-utils 4.x. #85 Tags: github, sqlite ## How to build a multi-vendor marketplace in Webflow Cloud with Stripe Connect DevFeed: [How to build a multi-vendor marketplace in Webflow Cloud with Stripe Connect]() Original publisher: [Read original article]() Author: Ismail Ajagbe Published: 2026-09-04T00:00:00Z Content type: tutorial Language: en Sources: [Webflow Blog]() Topics: [stripe](), [Workers](), [Next.js](), [SQLite](), [Node.js](), [Auth0]() Tags: [cloudflare-workers](), [code](), [database](), [guides](), [next-js](), [node-js](), [server](), [sqlite](), [stripe]() ### AI overview A practical guide to building a multi-vendor marketplace in Webflow Cloud with Next.js, Stripe Connect, Cloudflare Workers, and SQLite. It covers vendor onboarding, product and order data, split payments, and signed webhooks for confirming sales. ### Source excerpt Learn how to build a multi-vendor marketplace in Webflow Cloud, onboard vendors with Stripe Connect, and split each payment with a destination charge. ## SQLite Encryption in Production: Key Management, Migration, and Real-World Use Cases DevFeed: [SQLite Encryption in Production: Key Management, Migration, and Real-World Use Cases]() Original publisher: [Read original article]() Author: Jeff Olson Published: 2026-09-03T00:00:00Z Content type: tutorial Language: en Sources: [Turso Blog]() Topics: [SQLite](), [Encryption](), [migration](), [Cryptography](), [Turso]() Tags: [compliance](), [database](), [encryption](), [how-to](), [management](), [migration](), [production](), [security](), [sqlite](), [turso]() ### AI overview A practical guide to operating encrypted SQLite databases securely in production. It covers secure key generation and storage, Turso key encoding differences, migration and rotation constraints, and compliance considerations. ### Source excerpt Where to store keys, how to rotate them, how to migrate from SQLCipher or unencrypted SQLite, and what SOC2, HIPAA, and PCI-DSS auditors actually want to see. ## Encrypting SQLite Databases with Turso: Local, Cloud, and BYOK DevFeed: [Encrypting SQLite Databases with Turso: Local, Cloud, and BYOK]() Original publisher: [Read original article]() Author: Jeff Olson Published: 2026-09-02T00:00:00Z Content type: tutorial Language: en Sources: [Turso Blog]() Topics: [Turso](), [Encryption](), [SQLite](), [Cryptography](), [Databases]() Tags: [benchmark](), [cloud](), [code](), [database](), [encryption](), [local](), [open-source](), [rust](), [security](), [sqlite](), [turso]() ### AI overview A tutorial on Turso's native SQLite encryption and cloud BYOK model, covering key handling, architecture, code, and benchmarks. ### Source excerpt How Turso's two encryption models work in practice: native encryption in the Rust engine and BYOK on Turso Cloud, with working code and real benchmark numbers. ## SQLite Doesn't Come With Encryption. Here's What Developers Actually Use. DevFeed: [SQLite Doesn't Come With Encryption. Here's What Developers Actually Use.]() Original publisher: [Read original article]() Author: Jeff Olson Published: 2026-09-01T00:00:00Z Content type: article Language: en Sources: [Turso Blog]() Topics: [Encryption](), [SQLite](), [Cryptography](), [Operating system]() Tags: [database](), [developers](), [encryption](), [extension](), [os](), [security](), [sqlite](), [turso]() ### AI overview An overview of SQLite encryption options, page-level AEAD encryption, and the impact of SQLite removing the undocumented SQLITE_HAS_CODEC hook in version 3.32.0. ### Source excerpt A map of the SQLite encryption landscape: SQLCipher, SEE, SQLite3MultipleCiphers, and modern alternatives, plus how page-level AEAD encryption actually works. ## 【kube-apiserver】选型收束与开放问题：排除树、Kine 与 events 分集群 DevFeed: [【kube-apiserver】选型收束与开放问题：排除树、Kine 与 events 分集群]() Original publisher: [Read original article]() Author: Liao Tonglang Published: 2026-08-28T00:00:00Z Content type: tutorial Language: zh Sources: [土法炼钢 - 系统与基础设施]() Topics: [Kubernetes](), [Caching](), [etcd](), [SQL](), [MySQL](), [PostgreSQL](), [SQLite](), [Raft]() Tags: [apiserver](), [churn](), [distributed](), [errcompacted](), [etcd](), [events](), [exclusion-tree](), [kine](), [kubernetes](), [mysql](), [open-questions](), [postgresql](), [quota](), [raft](), [selection](), [sql](), [sqlite](), [storage](), [ttl](), [v1-30-3](), [watch-cache]() ### AI overview This concluding article presents a mechanism-based decision tree for diagnosing Kubernetes control-plane issues across kube-apiserver and etcd layers. It explains Kine's differing Watch semantics when using SQLite, PostgreSQL, or MySQL backends, discusses routing Kubernetes Events to a separate etcd cluster, and identifies open questions around watch-cache SLOs, compaction, linear reads, and Lease fencing. ### Source excerpt 用机制排除树收束何时查 apiserver 轴、何时穿透 etcd 轴、何时两轴联查；回收 etcd/13 写下的 apiserver 停损线；Kine SQL backend 的 Watch 语义差与 Jepsen 覆盖空白；events --etcd-servers-overrides 分集群运维；列出 watch cache SLO 联合模型、线性读期望与 Lease+fencing 全链路三个开放问题；以 ADR 语言关闭系列边界。 ## Node.js 26.8.0 (Current) DevFeed: [Node.js 26.8.0 (Current)]() Original publisher: [Read original article]() Published: 2026-08-26T14:29:48Z Content type: release Language: en Sources: [Node.js Blog]() Topics: [Node.js](), [JavaScript](), [Benchmark](), [Open Source](), [SQLite](), [cross-platform](), [Syntax Highlighting]() Tags: [benchmark](), [cross-platform](), [javascript](), [node-js](), [open-source](), [performance](), [sqlite](), [tools]() ### AI overview Node.js 26.8.0 is a current release with semver-minor updates to benchmarking, cryptography, diagnostics, networking, performance hooks, the REPL, SQLite, MIME type parsing, and zlib. It also includes documentation, build, and test-related changes. ### Source excerpt Node.js® is a free, open-source, cross-platform JavaScript runtime environment that lets developers create servers, web apps, command line tools and scripts. ## Watch Apps: One Codebase, Two Real Applications DevFeed: [Watch Apps: One Codebase, Two Real Applications]() Original publisher: [Read original article]() Author: Shai Almog Published: 2026-08-22T00:00:00Z Content type: tutorial Language: en Sources: [CodeName One]() Topics: [SwiftUI](), [Android](), [media3](), [SQLite](), [API]() Tags: [android](), [api](), [apk](), [apple](), [apple-watch](), [asynchronous](), [files](), [release](), [sqlite](), [state](), [swiftui](), [watchos]() ### AI overview Codename One can build Apple Watch companion applications and Wear OS applications from a shared watch entry point. The article explains separate application runtimes and storage, platform-specific rendering, and asynchronous communication for live messages, replicated state, and file transfers. ### Source excerpt Codename One now builds Apple Watch companions and standalone Wear OS products from one watch entry point, with a portable asynchronous API for messages, state, and files. ## Banner or no banner, that's the question DevFeed: [Banner or no banner, that's the question]() Original publisher: [Read original article]() Author: Claudio Baccigalupo Published: 2026-08-21T00:00:00Z Content type: article Language: en Sources: [Ruby on Rails: Compress the complexity of modern web apps]() Topics: [Rails](), [SQLite](), [debugging]() Tags: [data](), [debugging](), [migration](), [news](), [sqlite]() ### AI overview This week's Rails changes add console banner control, HTTP QUERY support, scoped Active Record updates, improved MIME handling, broader Ractor safety, batched schema reads including SQLite support, and several cleanup, deprecation, debugging, and test behavior updates. ### Source excerpt Hi, it's Claudio Baccigalupo. Let's explore this week's changes in the Rails codebase. ## SQLite Across Every Port: One Contract, One Encrypted File Format DevFeed: [SQLite Across Every Port: One Contract, One Encrypted File Format]() Original publisher: [Read original article]() Author: Shai Almog Published: 2026-08-21T00:00:00Z Content type: article Language: en Sources: [CodeName One]() Topics: [SQLite](), [Encryption](), [Android](), [iOS](), [JavaScript](), [Linux](), [simulator](), [Windows](), [tvOS](), [watchOS]() Tags: [android](), [encryption](), [ios](), [javascript](), [linux](), [simulator](), [sqlite](), [watchos](), [windows]() ### AI overview Codename One describes a unified, tested SQLite contract across its supported ports, replacing platform-dependent implementations. The update also supports encrypted database files that can move between ports and open in standard SQLCipher 4 clients, using passphrase, managed-key, or raw-key encryption. ### Source excerpt Codename One now runs the same tested SQLite contract across Android, iOS, JavaScript, Windows, Linux, watchOS, tvOS, and the simulator, with passphrase, managed-key, and raw-key encryption. ## Multi-tenancy at Scale: How to Give Every User Their Own Database DevFeed: [Multi-tenancy at Scale: How to Give Every User Their Own Database]() Original publisher: [Read original article]() Author: Jeff Olson Published: 2026-08-17T00:00:00Z Content type: article Language: en Sources: [Turso Blog]() Topics: [Multi-tenancy](), [Databases](), [SQLite](), [Turso](), [MySQL](), [PostgreSQL]() Tags: [database](), [multi-tenancy](), [mysql](), [platform-api](), [postgresql](), [saas](), [scale](), [software-architecture](), [sqlite](), [turso]() ### AI overview This article argues that database-per-tenant architecture becomes practical at scale when each tenant database is a SQLite file rather than a continuously running PostgreSQL or MySQL server process. It contrasts the cost, connection-pooling, and backup challenges of server-based databases with SQLite's low-cost, file-based model, using Turso as the relevant platform context. ### Source excerpt The warnings against giving every tenant their own database assume a database is a server process. When a database is a file, the tradeoffs look completely different. ## How we tracked down a 16-year-old SQLite bug DevFeed: [How we tracked down a 16-year-old SQLite bug]() Original publisher: [Read original article]() Author: Alex Chan Published: 2026-08-12T14:00:00Z Content type: article Language: en Sources: [Blog on Tailscale]() Topics: [SQLite](), [bug](), [Databases](), [incident](), [Go Language](), [Amazon S3](), [data]() Tags: [blog](), [bug](), [data](), [database](), [databases](), [go](), [incident](), [s3](), [sqlite]() ### AI overview Tailscale describes how repeated outages led its engineers to track down and fix a long-standing SQLite corruption bug. The article covers the control plane's sharded, single-writer SQLite architecture, database backups uploaded to Amazon S3, and the forensic investigation into recurring corruption. ### Source excerpt SQLite corruption? Sorted. ## Migrating from PostgreSQL/MySQL to SQLite: When and How to Make the Switch DevFeed: [Migrating from PostgreSQL/MySQL to SQLite: When and How to Make the Switch]() Original publisher: [Read original article]() Author: Jeff Olson Published: 2026-08-12T00:00:00Z Content type: tutorial Language: en Sources: [Turso Blog]() Topics: [SQLite](), [migration](), [PostgreSQL](), [MySQL](), [Turso](), [Databases](), [Protocol (disambiguation)](), [Cloud]() Tags: [cloud](), [database-migration](), [guide](), [http](), [migration](), [mysql](), [performance](), [postgresql](), [replication](), [sqlite](), [sync](), [turso]() ### AI overview A practical guide to deciding whether SQLite is suitable for production and migrating from PostgreSQL or MySQL. It discusses performance improvements, operational trade-offs, and Turso's cloud and local synchronization options. ### Source excerpt When SQLite makes sense, how to migrate from PostgreSQL or MySQL, and what trade-offs you're actually making. ## How to build an employee self-service portal in Webflow Cloud with Auth0, D1, and the CMS Data API DevFeed: [How to build an employee self-service portal in Webflow Cloud with Auth0, D1, and the CMS Data API]() Original publisher: [Read original article]() Author: Ismail Ajagbe Published: 2026-08-08T00:00:00Z Content type: tutorial Language: en Sources: [Webflow Blog]() Topics: [webflow](), [Auth0](), [Authentication](), [Cloudflare](), [Content Management System](), [Drizzle](), [Next.js](), [SQLite](), [web applications](), [API](), [hosting](), [JSON Web Tokens]() Tags: [authentication](), [cloudflare](), [code](), [drizzle](), [guides](), [hosting](), [how-to](), [next-js](), [rest](), [sqlite](), [webflow]() ### AI overview A guide to building an employee self-service portal in Webflow Cloud with Next.js, Auth0 authentication, Cloudflare D1 backed by Drizzle ORM, SQLite, and Webflow CMS announcements. ### Source excerpt Learn how to build an employee self-service portal in Webflow Cloud with Next.js, Auth0, SQLite, and Webflow CMSs. ## New release of LLM adds support for reasoning traces, OpenAI Responses, server-side tools, and smarter logging DevFeed: [New release of LLM adds support for reasoning traces, OpenAI Responses, server-side tools, and smarter logging]() Original publisher: [Read original article]() Author: Simon Willison Published: 2026-08-04T23:58:24Z Content type: release Language: en Sources: [Simon Willison]() Topics: [Tool](), [Command-line interface](), [API](), [Large Language Model](), [SQLite](), [Logging](), [OpenAI](), [Claude](), [Model Context Protocol](), [gemma4]() Tags: [ai](), [ai-2-235](), [anthropic](), [anthropic-336](), [cli](), [gemma](), [generative-ai](), [generative-ai-1-981](), [llm](), [llm-631](), [llm-reasoning](), [llm-reasoning-103](), [llm-tool-use](), [llm-tool-use-75](), [llms](), [llms-1-947](), [logging](), [mcp](), [model-context-protocol](), [model-context-protocol-35](), [openai](), [openai-463](), [projects](), [projects-553](), [release](), [releases](), [releases-31](), [responses](), [server](), [sqlite]() ### AI overview LLM 0.32 adds visible reasoning traces, server-side provider tools, redesigned content-addressable SQLite logs, support for the GPT-5.6 model family, and features enabled by the OpenAI Responses API. The release also updates the llm-anthropic plugin and adds Python API changes. ### Source excerpt I released LLM 0.32 this morning, the most significant new version of LLM since the initial launch of the project. The new version includes support for visible reasoning traces, server-side provider tools, redesigned content-addressable SQLite logs, new models, and new features enabled by the OpenAI Responses API. I also released a new version of the llm-anthropic plugin with substantial updates of its own. Headline features for LLM CLI users Running LLM against reasoning models now displays their reasoning traces to standard error, so you can see what they are "thinking" without that information being included in the standard output that you might pipe to another tool. Add -R/--hide-reasoning to turn this off. LLM includes support out-of-the-box for the GPT-5.6 model family, and the new default model used with llm "prompt" is now the inexpensive but capable GPT-5.6 Luna. LLM calls can now use server-side tools from various providers. OpenAI provide a code execution environment as a server-side tool; LLM can now run prompts that benefit from that like so: llm --tool CodeInterpreter 'Show current python and SQLite versions' OpenAI also gets a WebSearch tool. The llm-anthropic plugin adds WebSearch, WebFetch, CodeExecution, and AnthropicMCP, which looks like this: llm -m claude-sonnet-5 -T 'AnthropicMCP("https://datasette.simonwillison.net/-/mcp")' \ 'how many rows in the blog_blogmark table?' That causes Anthropic to execute MCP calls against my new datasette-mcp plugin as part of a single request/response interaction with their API. The new llm openai endpoint command provides a tool for executing prompts against any OpenAI compatible endpoint as a one-liner. These aren't logged, which makes this a handy tool for running one-off prompts against anything that speaks the lingua franca of the LLM API world. Here's how I use that to run prompts against Gemma 4 12B running in my localhost LM Studio API, via uvx (no LLM installation required) and mixing in the llm-tools-q ## SQLite Concurrent Writes Are Here: Early Preview on Turso Cloud DevFeed: [SQLite Concurrent Writes Are Here: Early Preview on Turso Cloud]() Original publisher: [Read original article]() Author: Glauber Costa Published: 2026-08-03T00:00:00Z Content type: release Language: en Sources: [Turso Blog]() Topics: [Turso](), [Concurrency](), [SQLite](), [Databases](), [Cloud](), [Rust]() Tags: [cloud](), [concurrency](), [database](), [databases](), [performance](), [rust](), [sqlite](), [transactions](), [turso]() ### AI overview Turso announces an early preview of concurrent writes on Turso Cloud. The feature allows multiple transactions to write in parallel, detects conflicts at commit time at row granularity, and uses an MVCC engine to create new row versions instead of relying on a single write lock. ### Source excerpt Concurrent Writes on the Turso Cloud: SQLite without its limits ## Building Local-First Apps: The Complete Guide to Offline-First Database Sync DevFeed: [Building Local-First Apps: The Complete Guide to Offline-First Database Sync]() Original publisher: [Read original article]() Author: Jeff Olson Published: 2026-07-27T00:00:00Z Content type: tutorial Language: en Sources: [Turso Blog]() Topics: [Local-First](), [Turso](), [SQLite](), [Databases](), [Back end]() Tags: [architecture](), [auth](), [backend](), [database](), [databases](), [guide](), [local-first](), [offline](), [sqlite](), [storage](), [sync](), [turso]() ### AI overview A complete guide to building local-first, offline-first applications. It explains the local-first model, where data lives on the device and the cloud provides backup, synchronization, and coordination, then introduces Turso Sync and SQLite-based approaches. The article also covers architecture patterns and practical challenges including conflict resolution, authentication, storage management, and partial synchronization. ### Source excerpt What local-first means, how Turso Sync works, three architecture patterns, and how to handle the hard parts: conflicts, auth, storage, and partial sync. ## How to build a personality assessment tool in Webflow Cloud with server-side scoring DevFeed: [How to build a personality assessment tool in Webflow Cloud with server-side scoring]() Original publisher: [Read original article]() Author: Ismail Ajagbe Published: 2026-07-25T00:00:00Z Content type: tutorial Language: en Sources: [Webflow Blog]() Topics: [webflow](), [Next.js](), [Workers](), [Back end](), [SQLite](), [Front end](), [Language models]() Tags: [ai](), [api-keys](), [backend](), [browser](), [cloudflare](), [database](), [framework](), [guides](), [how-to](), [javascript](), [next-js](), [sqlite](), [tool](), [webflow](), [workers]() ### AI overview A practical guide to building a Big Five personality assessment in Webflow Cloud, using server-side scoring with a Next.js app running as a Cloudflare Worker. It covers SQLite and Key Value storage, API-key configuration, and optional AI-generated result narratives. ### Source excerpt Learn how to build a Big Five personality assessment in Webflow Cloud, with server-side scoring, D1 and KV storage, and an optional AI results narrative. ## How to build an invoice generator app in Webflow Cloud with Next.js and SQLite DevFeed: [How to build an invoice generator app in Webflow Cloud with Next.js and SQLite]() Original publisher: [Read original article]() Author: Ismail Ajagbe Published: 2026-07-25T00:00:00Z Content type: tutorial Language: en Sources: [Webflow Blog]() Topics: [webflow](), [Next.js](), [SQLite](), [CRUD](), [Workers](), [JavaScript](), [Node.js](), [npm](), [GitHub]() Tags: [app](), [cloud](), [code](), [data](), [github](), [guides](), [how-to](), [infrastructure](), [javascript](), [next-js](), [node](), [node-js](), [sqlite](), [webflow](), [workers]() ### AI overview A tutorial for building an invoice generator in Webflow Cloud with Next.js and SQLite. It covers storing invoice records, creating and listing them through route handlers, generating downloadable PDFs at the edge with a pure-JavaScript library, building the form, and deploying the app. ### Source excerpt Learn how to build an invoice generator app in Webflow Cloud with a Next.js project, a SQLite database, and edge-compatible PDF generation using pdf-lib. ## Durable Objects are Made for Agents DevFeed: [Durable Objects are Made for Agents]() Original publisher: [Read original article]() Author: Calvin French-Owen Published: 2026-07-22T12:00:00Z Content type: opinion Language: en Sources: [Calvin French-Owen]() Topics: [Cloudflare](), [Serverless](), [SQLite](), [V8](), [event driven](), [WebSocket](), [wasm]() Tags: [cloudflare](), [event-driven](), [serverless](), [sqlite](), [v8](), [websockets]() ### AI overview An opinionated technical article explains why Cloudflare Durable Objects can be a strong primitive for building agents and other stateful products. It describes their serverless V8 execution model, per-object SQLite storage, ID-based request routing, event-driven structure, and potential shortcomings. ### Source excerpt I've spent the last few months building almost exclusively on Cloudflare Durable Objects. They're a near-perfect primitive for building agents--here's where they shine, and where they fall short. ## Learning a few things about running SQLite DevFeed: [Learning a few things about running SQLite]() Original publisher: [Read original article]() Author: Julia Evans Published: 2026-07-17T00:00:00Z Content type: article Language: en Sources: [Julia Evans]() Topics: [SQLite](), [Django](), [Object-relational mapping](), [Query (disambiguation)](), [Statistics]() Tags: [blog](), [django](), [orm](), [search](), [sqlite](), [statistics]() ### AI overview A personal account of operating SQLite in production for a small Django website. The article describes how running ANALYZE dramatically improved an SQLite FTS5 query and discusses the difficulty of cleaning up large numbers of rows without blocking other database writers. ### Source excerpt Hello! I've been working on a Django site recently, and I decided to use SQLite as the database. When I was getting started with using SQLite as database for a website I read a bunch of blog posts about how it is totally fine to use SQLite in production for a small site and I think it is totally fine, but what I did not fully appreciate is that SQLite is still a database, databases are complicated, and I do not know a lot about operating databases. So here are a couple of small things I've been learning about running SQLite. This is the 4th website I've used SQLite for, and I think this one is harder because with the power of the Django ORM I've been making the database do more work than I was previously without Django. I started by turning on WAL mode like all the blog posts said to do and hoping for the best. ANALYZE is apparently important Today I was running a query (using SQLite's FTS5 for full-text search) on a table with 4000 rows and it took 5 seconds. That seemed wrong to me: computers are fast! It turned out that what I needed to do was to run ANALYZE! Immediately the problem query went from taking 5 seconds to like 0.05 seconds (or some other number small enough that I didn't care to investigate further). I still don't know exactly what went wrong in the query plan, but my best guess is that it was some sort of accidentally quadratic thing. ANALYZE generates "statistics" (I guess about the number of rows in each table? and presumably other things?) so that the query planner can make better choices. Maybe one day I'll learn to read a query plan. cleaning up the database is tricky Occasionally I've run into situations where I accidentally put a bunch of rows in my database that I don't want to be there (for example completed tasks from django-tasks-db), and I want to clean them up. What's happened to me a few times in this case is: I run some kind of command to clean up the rows The command takes more than 5 seconds, since there are a lot of rows (though I [Next page]()