SQLite alternatives

2 tools to consider instead of SQLite, shown against it.

SQLite chDB Apache Arrow
Vendor SQLite (public domain) chDB (open-source project) Apache Software Foundation
Pricing model Open source + paid options Open source + paid options Open source + paid options
Free tier Yes Yes Yes
Deployment Self-hosted Self-hosted Self-hosted
Open source Yes (Public Domain) Yes (Apache-2.0) Yes (Apache-2.0)
Best for Developers embedding a zero-administration transactional database directly inside an application or device. Python users wanting ClickHouse-grade analytical SQL locally without standing up a ClickHouse cluster. Engineers building or connecting data tools that need to exchange large datasets without serialization overhead.
Pricing

Free for any use under a public-domain release; optional paid support and warranty-of-title licenses are available separately.

Pricing has not been verified yet — see the vendor's site.

Free, open-source library with no hosted product or pricing page.

Pricing has not been verified yet — see the vendor's site.

Free, open-source specification and libraries with no vendor or pricing page.

Pricing has not been verified yet — see the vendor's site.

Features
  • Serverless, in-process SQL engine with no configuration
  • Entire database stored in a single cross-platform file
  • ACID-compliant transactions
  • Row-oriented storage tuned for transactional workloads
  • Bindings and drivers for virtually every programming language
  • Zero-administration deployment inside applications
  • In-process ClickHouse SQL engine, no server required
  • Vectorized, columnar query execution
  • Reads/writes Parquet, CSV, JSON, Arrow, ORC and more
  • Pandas-compatible query API
  • Python DB-API 2.0 support
  • Runs in-browser via WebAssembly
  • Standard columnar in-memory data format across languages
  • Zero-copy data sharing between compatible tools
  • Libraries for C++, Python, Java, Rust, Go and more
  • Arrow Flight for high-performance network data transport
  • Arrow Flight SQL for querying databases over Arrow
  • Compute kernels for common analytical operations

In the index now