Thursday, September 11, 2008

Meta post: Querying languages versus APIs

This is a meta post about the differences between having a querying language and an API for accessing a database. I want to analyze the pros and cons of both approaches. I believe there are benefits of both models, and that they both have weaknesses.
These are my initial ideas on what to discuss in the post:
  • An API provides a type safe way of operating with the data model.
  • An API cannot expose query injection weaknesses.
  • Queries to in a query languages are handled completely internally in the engine, and can therefore be optimized more easily.
Please comment with references on querying languages and your opinion on the pros and cons of the two approaches.

No comments: