---
title: "Lobsters 社区成功迁移至 SQLite：单服务器架构的胜利"
source: "Simon Willison 博客（Atom）"
source_tier: "t2"
url: "https://simonwillison.net/2026/Jul/14/lobsters-sqlite/#atom-everything"
permalink: "https://feed.astralor.com/items/itm_f35c19cbe321ea48ad514fe3"
published: "2026-07-14T19:44:11.000Z"
score: 80
channel: "tech"
tags: ["Lobsters","MariaDB","Rails","SQLite","单服务器架构","数据库迁移"]
---

# Lobsters 社区成功迁移至 SQLite：单服务器架构的胜利

## AI 点评

> 这个迁移案例特别值得关注，因为它挑战了‘小站点必须上分布式数据库’的惯性思维。Lobsters 用实践证明，在 2026 年，一台服务器加 SQLite 就能承载一个活跃社区。对正在为技术栈过度复杂而苦恼的创业团队来说，这是一个降本增效的绝佳参照。

## 速览

技术社区站点 Lobsters 完成了从 MariaDB 到 SQLite 的数据库迁移，耗时约8年规划与实施。迁移后，CPU 和内存使用率下降，响应速度提升，VPS 成本减半。该 Rails 应用现运行于单台 VPS，主数据库文件仅 3.8GB。迁移 PR 涉及 30 次提交、188 个文件，新增 735 行、删除 593 行代码。这一案例展示了 2026 年 SQLite 在单服务器场景下的出色表现。

## 关键点

- Lobsters 从 MariaDB 迁移至 SQLite，历时多年规划，近期完成并稳定运行。
- 迁移后 CPU、内存使用率下降，站点响应更快，VPS 成本降低一半。
- Rails 应用现部署在单台 VPS 上，主数据库文件约 3.8GB。
- 迁移 PR 共 30 次提交、188 个文件，净减代码量，体现精简架构思路。

## 全文

lobste.rs is now running on SQLite Community site Lobsters has been planning a migration away from MariaDB since August 2018 - originally targeting PostgreSQL, but last year they decided to investigate SQLite instead. This weekend they completed the migration, and now consider it stable enough that it looks like this is the permanent architecture for the site going forward: SQLite seems to have passed with flying colors: cpu usage is down, memory usage is down, site seems to be snappier at least for me, 1/2 the vps cost once mariadb vps is taken down The Lobsters Rails application now runs on a single VPS, with a primary content SQLite database file that's around 3.8GB. There are plenty more details in both the linked thread and this SQLite migration PR by Thomas Dziedzic, which added 735 lines and removed 593 lines across 30 commits and 188 files. That PR built on top of previous PRs #1705, #1871, and #1924. This is a really useful case study, and a great reminder that you can get a whole lot done with a single server and SQLite in 2026. Tags: migrations, ops, rails, sqlite, lobsters

---

引用前请核对原文;本文由星际流动整理:https://feed.astralor.com/items/itm_f35c19cbe321ea48ad514fe3