Self-Hosted LibSQL (sqld) vs Managed Turso Cloud: Row-Read & Write Break-Even
SQLiteEdge FinOps model (public pricing retrieved 2026-11-12): evaluating when managed Turso fits vs when unindexed scans justify self-hosted sqld on local NVMe.
SQLiteEdge Architecture & Tariff Verdict: Self-Hosted LibSQL sqld vs Managed Turso Row-Read Billing
Managed Turso tiers work well for lightweight edge apps staying inside included row-read quotas. However, in our SQLiteEdge row-volume equations, analytics dashboards or background sync loops scanning tens of billions of rows per cycle quickly cross metered thresholds, whereas self-hosting open-source `sqld` on Vultr High Frequency NVMe ($24–$48/mo public rate 2026-11-12) removes per-row metering.
SQLiteEdge pricing note: public rates retrieved 2026-11-12 from official vendor pricing pages; promotional and renewal prices may change at checkout.
SQLiteEdge Public Specification & Cost Matrix (CMP-03)
| LibSQL Sizing Criterion | Self-Hosted sqld (Vultr HF / UltaHost) | Managed Turso Cloud Tiers |
|---|---|---|
| Client SDK Compatibility | 100% @libsql/client, Drizzle & Prisma | 100% @libsql/client, Drizzle & Prisma |
| Billion Row-Read Metering | Unmetered Local NVMe Reads ($0/B) | Included Quota -> Metered Overage |
| Million Row-Write Metering | Unmetered Local WAL Commits ($0/M) | Included Quota -> Metered Overage |
| Missing-Index Table Scan Impact | Temporary CPU Spike Only | Consumes Billions of Billed Row Reads |
| 60 GB Dataset + Vector Columns | Fits in 256GB–400GB Local NVMe | Per-GB Storage Add-On Rates |
| Public Monthly Rate (2026-11-12) | $48.00/mo HF NVMe + $6/mo S3 DR | $195.00 – $380.00+/mo at High Scan Vol |
SQLiteEdge Engineering Decision Criteria for Self-Hosted LibSQL sqld vs Managed Turso Row-Read Billing
- A single unindexed query across a 500,000-row table triggered 10,000 times scans 5 billion rows—a direct billing multiplier modeled by SQLiteEdge.
- Running open-source sqld on Vultr High Frequency NVMe or UltaHost Dedicated NVMe VDS keeps monthly compute flat regardless of row scan counts.
- Point sqld bottomless replication at a $6/mo InterServer S3/MinIO endpoint for continuous off-site WAL archival.
SQLiteEdge Matched Infrastructure Routes for CMP-03
-
Vultr 3.5GHz+ High Frequency Local NVMe ComputeReview Vultr Specs (CMP-03) via SQLiteEdge →
3.7GHz+ Single-Core IPC + Direct PCIe NVMe • ~0.045ms fsync for Peak SQLite Single-Writer TPS (https://www.vultr.com/pricing/) -
UltaHost Dedicated-Core RAID-10 NVMe VDS (Unmetered)Review UltaHost Option (CMP-03) via SQLiteEdge →
Dedicated CPU Cores (Zero Noisy-Neighbor Steal) + Unmetered LiteFS / sqld Replica Sync Bandwidth (https://ultahost.com/vds-hosting)