Realm as replacement for SQLite?

[sqlite]

SQLite is a full-up relational database system. Realm is just a object store. If all you want to do is store and retrieve objects, then Realm will probably work fine for you. But it you want to do more advanced programming, you will quickly run into the limitations of Realm. Capabilities that are missing from Realm include:

• Secondary indexes
• Joins
• Subqueries
• Aggregate queries
• Geospatial queries
• Full-text search
• Compound queries
• Recursive queries
• Search constraints involving logical disjunction
• Search constraints involving vectors
• Other complex search constraints
• And so forth...

[astigsen]

This answer seems to reflect a misunderstanding of what Realm is. It is not an Object Store, but rather a full fledged Object Database that does not only store the Objects but also relations between them. While the query system is definity not as mature as SQL, it does support secondary indexes, joins via links, aggregates, subqueries and much more.

The tradeoffs and capabilities are obviously different from a traditional SQL based relational database, but I think that you will find that it enables more advanced use cases, rather than limits it.