Mitar's Point

Somewhere and everywhere between (computer)
science, technology, nature and (open) society.

Contact

Posts tagged "orm"

Database-abstraction APIs should not exist

Database-abstraction APIs where you write a query using the host programming language should not exist. Or more precisely, should not have to exist. For example, in Django you can query the database using the following Python code:

Entry.objects.filter(is_draft=True)

Which Django translates (roughly) into the following SQL:

SELECT *
  FROM blog_entry
  WHERE is_draft = true;

But why we cannot write SQL query directly as an SQL query, while retaining all other features Django offers through its database-abstraction API (database agnostic code, inputs to queries and outputs from queries being Python objects, etc.)? I claim there is no reason anymore for that.

Keep reading

Text
Subscribe
All content is available under Creative Commons Attribution-ShareAlike license unless specified otherwise. Attribute by linking. The views and opinions are not necessary of my current or past affiliations, nor are they necessary mine. Not everything I write or share I agree with, e.g., it can be hypothetical, to provoke debate, troll, play devil's advocate, entertain half-baked ideas, explore new lines of thought or perspectives. Not everything I expressed in the past I agree with today. Linking is not endorsement. All feedback is welcome. He/him.