You are designing the RDMS access for your current project and deciding which approach is best: an ORM-centric implementation or a direct SQL-based implementation. Which two statements are guaranteed to be true in all cases when comparing the two approaches?

Questions & AnswersCategory: PythonYou are designing the RDMS access for your current project and deciding which approach is best: an ORM-centric implementation or a direct SQL-based implementation. Which two statements are guaranteed to be true in all cases when comparing the two approaches?
Geek Boy Staff asked 3 years ago

You are designing the RDMS access for your current project and deciding which approach is best: an ORM-centric implementation or a direct SQL-based implementation. Which two statements are guaranteed to be true in all cases when comparing the two approaches?
a. ORM is a better choice than database connector, because it combines ease of development, database.
b. Database connector, is a better choice than ORM, because it combines direct access to the database, a minimal programming model, the best performance and scalability, and ease of development.
c. Any decision must consider and address the issues of performance, scalability, ease of development, and ACID semantics, weighted according to the specific application being designed.
d. ORM implementations that do NOT subscribe to an open, standardized API are more difficult to maintain in the long term.

1 Answers
Geek Boy Staff answered 3 years ago

a. ORM is a better choice than database connector, because it combines ease of development, database.
c. Any decision must consider and address the issues of performance, scalability, ease of development, and ACID semantics, weighted according to the specific application being designed.