Limitations & Scale Considerations

Understanding AxioDB's design scope

AxioDB is designed for embedded applications with 10K-500K documents. For different requirements, consider these alternatives.

Scale & Performance Boundaries

  • Dataset Size: Optimized for 10K-500K documents. For 10M+ documents, use PostgreSQL, MongoDB, or SQLite which are designed for massive scale.
  • Concurrency: Single-instance architecture. For multi-user web applications with hundreds of concurrent connections, use traditional client-server databases.
  • Relational Data: Document-based NoSQL architecture. No JOIN operations. For complex relational data with foreign keys and constraints, use SQL databases.
  • Distributed Systems: Single-node only. No replication, no sharding, no clustering. For distributed systems, use MongoDB or CouchDB.
  • Transactions: No ACID transactions across multiple collections. For transaction requirements, use PostgreSQL or MongoDB with transactions enabled.

When to Use AxioDB: Desktop apps, CLI tools, embedded systems, prototyping, and local-first applications with moderate data needs. Think SQLite-scale with MongoDB-style queries and built-in caching.