SQL + NoSQL Without Compromise: The Best of Both Worlds

[Paul Simon]

I built an open-source document database that actually lets you:
✅ Store raw JSON - No schema headaches, no migrations
✅ Query with real SQL (JOINs, WHERE, GROUP BY - the works)
✅ Scale predictably - YottaDB's globals handle heavy loads gracefully

Why this works when others struggle:
✔ No indexing gymnastics - Queries stay fast without constant tuning
✔ Runs anywhere - Cloud, laptop, or even a Raspberry Pi
✔ Open core - No vendor lock-in, no surprise licensing

The tradeoffs.
• You'll need basic Linux skills to set it up
• Complex analytical queries can be optimized/simplified using SQL functions
• Documentation is solid but not hand-holding

Perfect when you need:

Rapid prototyping without schema constraints

SQL access for reporting/analytics (with function-based optimizations where needed)

A lightweight alternative to bloated database servers

See for yourself: https://github.com/psimon2/doc-mdb

Need help implementing this?
I offer consulting through Lifetime Software Solutions - from setup assistance to writing optimized SQL functions for your specific use case.

Built with YottaDB's rock-solid engine and their new Octo SQL layer.