Code Elegance

SQL the new Assembly

April 18th, 2007 by Emanuele DelBono

Is SQL the new assembly language?

Think about it.

The language that we are using for writing application is an hi-level language. Take C#. It runs in a managed environment, it abstract a lot of things, we don’t have to worry about low level interaction between OS and out app, the Garbage Collector keep memory clean.

Then when you pass to SQL to extract data from database you loose all this abstraction and you need to know every little issues (every byte!) to build a well designed database and to write a good query.

We (developer) need a new level of abstraction for the database interactions and I think that an ORM is a sort of that abstraction. But why the DBAs hate so much the ORM?

Posted in Emanuele DelBono | 2 comments

2 Comments so far

  1. Plastic/Blog » Stored Procedure or not? April 7th, 2008 20:28

    [...] I talk some months ago about T-SQL like an assembly language for database, you can read it here. [...]

  2. Bassel January 27th, 2009 04:18

    Well, it looks to me a good idea however it is not a new idea and it has been discussed beofre. But so far nobody has managed to make it a reality as far as I know?

Leave a reply

Spam Protection by WP-SpamFree