Hi all!
I'm needing to write a new Camel Component for accessing a database.
I've looked at the various database related components and see that
there is no consistent pattern among these. I was wondering if there
were recommendations as to what works best.
So my component would need to be much like a standard SQL database (e.g.
the SQL or JDBC components), but needs to go beyond plain SQL. But in
effect all operations are insert, update, delete and query operations,
really just like SQL, but just not being executed as SQL.
Logically query operations would map to a from: endpoint and insert,
update and delete to a to: endpoint. But its clear that from: endpoints
can't really carry a payload that would be the query (or its params), so
it looks like its best to handle query using a to: endpoint as well. Or
maybe to support both where simple fixed queries can be part of the
from: url parameters?
It looks to me like the MongoDB is the most sophisticated component,
allowing the "action" to be defined in the URL params, and gives a lot
of flexibility. But is the best approach?
All thoughts and experiences welcome.
Tim
