GripNewsAug 22, 2025
🌘 我的開發團隊每月僅花費 41.73 美元
➤ AI 驅動的軟體開發新經濟學：成本效益與協作洞察
✤ https://philipotoole.com/my-development-team-costs-41-73-a-month/
作者分享了他如何運用 AI 工具 Copilot 顯著降低開發成本，並深入探討了 AI 在軟體開發中的潛力與限制。Copilot 已成為他最大的非人類貢獻者，極大地提升了開發效率。然而，他也指出 AI 缺乏長期學習和情境記憶，這與人類開發者之間的關係有顯著差異。最終，他認為 AI 工具的低成本將徹底改變軟體經濟學。
+ 這篇文章提出了許多引人深思的觀點！AI 確實正在重塑開發模式，我很好奇這種轉變對整個產業的長期影響。
+ 非常實際的分享！$41.73 的月費真是驚人。作者對於 Copilot 的描述非常到位，既肯定了它的能力，也指出了其侷限性，這種平衡的觀點很有價值。
#AI #開源 #程式設計 #rqlite
My development team costs $41.73 a month – Vallified

Two years ago, I appeared on Contributor, a podcast hosted by Eric Anderson of Scale Venture Partners. I was there to talk about rqlite, the open-source database I maintain. Our conversation ended with this thought from me: I think the economics of software are about to change enormously with what we're seeing from LLMs. I…

GripNewsAug 6, 2025
🌘 一致性優於可用性：rqlite 如何處理 CAP 定理
➤ rqlite 的 CAP 定理實踐與讀取一致性彈性
✤ https://philipotoole.com/consistency-over-availability-how-rqlite-handles-the-cap-theorem/
本文深入探討 rqlite 如何運用 Raft 共識協定，在分散式環境中權衡 CAP 定理的「一致性」（Consistency）與「可用性」（Availability）。rqlite 採取 CP（一致性與分區容錯）模型，確保網路分區發生時，資料的完整性不受損，即便部分節點無法存取。此外，文章也詳細闡述了 rqlite 提供的多種讀取一致性層級，包括弱一致性、線性一致性和強一致性，讓開發者能根據應用程式的需求，在效能與資料正確性之間取得最佳平衡。
+ 終於釐清了 rqlite 在 CAP 定理中的定位，Raft 的應用讓它的 CP 模型非常吸引人。
+ 讀取一致性層級的說明很實用，特別是線性一致性，提供了效能和正確性的良好折衷。
#資料庫 #分散式系統 #Raft #rqlite
Consistency Over Availability: How rqlite handles the CAP Theorem – Vallified

rqlite is a lightweight, user-friendly, open-source, distributed relational database. It’s written in Go and uses SQLite as its storage engine. When it comes to distributed systems the CAP theorem is an essential concept. It states that it's impossible for a distributed database to simultaneously provide Consistency, Availability, and Partition tolerance. The challenge is in the face of a network partition,…

gemma lynnJul 3, 2025
damn #rqlite goes kinda hard huh
GripNewsAug 6, 2024
🌗 建置 rqlite 9.0：將磁碟使用量減半
➤ 透過參考性快照，rqlite 9.0 版本將帶來重大改進
✤ https://www.philipotoole.com/building-rqlite-9-0-cutting-disk-usage-by-half/
rqlite 是一個輕量級、開源的分散式關聯式資料庫，使用 Go 語言編寫，並以 SQLite 為其儲存引擎。9.0 版本的開發已經展開，主要目標是將磁碟使用量減少約 50%。透過高層次的設計改造來針對 rqlite 中造成磁碟消耗的主要原因，達成此目標。
+ "這項技術革新將使 rqlite 更具效率，並提供更好的使用體驗。"
+ "期待 rqlite 9.0 版本帶來的改變，特別是在磁碟使用和節點重新啟動方面的
#資料庫 #程式設計 #rqlite #SQLite
Building rqlite 9.0: Cutting Disk Usage by Half | Vallified

Kushal Das   🇸🇪Dec 18, 2023
Anyone here using https://github.com/rqlite/rqlite #rqlite #sql #database?
GitHub - rqlite/rqlite: The lightweight, fault-tolerant database built on SQLite. Designed to keep your data highly available with minimal effort.

The lightweight, fault-tolerant database built on SQLite. Designed to keep your data highly available with minimal effort. - rqlite/rqlite

GitHub
Data FeedMar 10, 2023

And another fantastic post from Philip O'Toole now looking at the history of #rqlite development and design choices.

https://www.philipotoole.com/9-years-of-open-source-database-development-the-design-docs/

9 years of open-source database development | Vallified

Show threadMarkus 🤓✨Feb 16, 2023
@polarcoder Nice article, but it's aged a bit. #LiteFS and #rqlite are doing some really interesting things with distributed SQLite. I wrote up an article about LiteFS (using Go, but usable in all languages) if you're curious. 😊 https://www.golang.dk/articles/distributed-sqlite-with-litefs
Distributed SQLite with LiteFS

Using distributed SQLite and Go in the cloud with LiteFS.

Show threadFErkiJan 6, 2023

@serge The Litestream website has a nice overview of similar alternatives: https://litestream.io/alternatives/

Quite nice selection for various priorities and trade-offs.

TL;DR:
- #Litestream is primarily for disaster recovery
- #LiteFS is a distributed file system from the same authors for "high availability and low global latency"
- #rqlite (and #dqlite) "trades higher durability for lower write throughput"

Alternatives - Litestream

Litestream replicates SQLite databases in real-time to S3.

Robert von Burg  Nov 15, 2022
Ooh, #rqlite looks like an interesting #PostgreSQL alternative for #Strolch. I'll need to write new DAOs, and then test to see how it works out... Got this from https://www.philipotoole.com/replicated-postgres-to-rqlite/
Replacing Postgres with rqlite - Vallified

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Recently I helped Replicated replace their use of PostgreSQL with rqlite. This brought much easier operation and high-availability to their Application Manager. To quote from  their blog post: “Because the database is now highly available, the application … Continue reading Replacing Postgres with rqlite →

Vallified
Ferdinando SimonettiNov 13, 2022
Replacing #Postgres with #rqlite - Vallified https://www.philipotoole.com/replicated-postgres-to-rqlite/ #Kubernetes easier setup
Replacing Postgres with rqlite - Vallified

rqlite is a lightweight, open-source, distributed relational database written in Go, which uses SQLite as its storage engine. Recently I helped Replicated replace their use of PostgreSQL with rqlite. This brought much easier operation and high-availability to their Application Manager. To quote from  their blog post: “Because the database is now highly available, the application … Continue reading Replacing Postgres with rqlite →

Vallified