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.
