Adapter interchangeability about model HOT 5 CLOSED

I agree that the adapters should be interchangeable, could you write up some example queries that currently don't work?

from model.

@viking I don't agree for a simple reason: an adapter should expose query DSL that's pertinent to the database that it targets.

My initial idea of Lotus::Model, was to ship it without adapters and have separated gem for each of them: eg lotus-model-sql. But for the sake of convenience I decided to bundle it in the main library, alongside with the memory adapter.

This last guy supposed to mimic an in-memory key-value store. But because of the (partial) interchangeability, I decided to add a (partial) SQL query interface. It offers a decent and agnostic starting point for your application, without worrying too much about persistence.

My opinion is that if you find yourself to think about joins you already made your persistence decision: SQL instead of NoSQL or BigTable. At that point, it doesn't make sense to stay on the memory adapter, but have a concrete database.

Lotus offers a good level of abstraction, that allows you to test your objects in isolation. If you're worried about CI build times, you should be able to hit the database only when needed.

As final point, interchangeability means that all the adapters should expose an universal, omni-comprehensive query language across (No)SQL databases. Shall a Redis adapter be able to do map-reduce?

from model.

I agree that it's impractical to have perfect interchangeability. However, I think some small changes could be made to provide better minimal interchangeability. Fixing the where method for the memory adapter to use all? instead of any?, for example.

I hadn't gotten to joins in my development before I realized that I had to stop using the memory adapter.

Perhaps there could be a very small set of methods that are expected to behave the same way across all adapters.

from model.

@viking 👍 for those small fixes. would you like to care? Thanks!

from model.

I'll work on it.

from model.