Apache AsterixDB vs JayDB

Apache AsterixDB is a free, open source, self-managed Big Data Management System for ingesting, storing, indexing, querying and analyzing data. Its Asterix Data Model extends JSON with object-database concepts, while SQL++ and AQL provide declarative queries for semistructured information. Partitioned LSM-based storage supports B+ tree, R-tree and inverted keyword secondary indexes. External datasets can be queried without loading everything into AsterixDB, using adapters for HDFS and local filesystems. Continuous feeds can ingest sources such as Twitter, RSS and sockets. The HTTP query API accepts SQL++ and can return immediate, deferred or asynchronous results. Installation options include NCService, Ansible and Amazon Web Services. The Hyracks parallel runtime has been scale-tested on up to 1000+ cores and 500+ disks. Documentation describes basic transactional concurrency and recovery, and identifies web data warehousing and social data analysis as suitable uses.

JayDB is a JSON document database with per-user sign-in, aimed at static apps that need user, session, or tenant data without an app-owned backend. Documents are JSON at slash-separated paths, and the first write creates the namespace. Its REST data plane supports GET, PUT, DELETE, and prefix listing. Browser apps can authenticate through OIDC with Authorization Code and PKCE without embedding a client secret. Listed identity providers include Google, GitHub, Microsoft, generic OIDC, and custom OAuth2. The official SDK supports authentication, token refresh, typed document access, and compare-and-swap operations. ETag-based compare-and-swap may reject a write with HTTP 412 if the document changed since it was read. JayDB is available as managed cloud software or as a self-hosted Go engine under the MIT license, using S3-compatible storage or local disk. The free plan is free and includes 1 GB stored, 100,000 reads per month, and 10,000 writes per month; usage hard-stops at those allowances. Metered rates are $0.05 per GB-month of storage, $0.20 per million reads, and $0.50 per million writes.