Re: No knowledge of the database?

From: Bruno Desthuilliers (bdesth.tagada_at_tsoin-tsoin.free.fr)
Date: 01/06/04 

Date: Tue, 06 Jan 2004 23:37:20 +0100

Alfredo Novoa wrote:
> marc.gluch@mindtap.com (Marc Gluch) wrote in message news:<3ff9ea03.64477640@netnews.comcast.net>...
>
>
>>Is your recommendation that all applications should be written in SQL
>>to the greatest extent possible, and resort to other languages only
>>when SQL is not expressive enough?
>
>
> My recomendation is that all SYSTEM developers should know what SQL
> and SQL DBMSs can do for them, what The Relational Model really is and
> what are the differences. The rest is automatic.

You should perhaps learn what 'system development' (or 'system
programming') means. It's about OS, drivers and the like...

> SQL has a very higher level than procedural languages, so if you can
> do something in SQL it will be a lot easier than to do the same in a
> procedural language like C++, C#, Java, etc.

C++ is a multiparadigm languages.
Java is an OO language.
C# is a Java clone.

What about learning the difference between 'imperative' and 'procedural'
  and stop saying nonsenses ?

Now SQL is basically a declarative language. As such, it is for sure
higher level than most imperative programming languages. But SQL is a
pretty specialized language, and not computationnaly complete. So there
are some (proprietary) extensions that allow to write... procedures. And
believe me, those procedural extensions are way lower level than most
modern programming languages.

Now one last point : most business application developpers use SQL and
SQL DBMS all day long. If SQL was enough, they would not bother writing
code in other languages.

Bruno

Relevant Pages

  • Re: SQL
    ... custom biz app setting. ... Put a program code in a relational table and write compiler in SQL ... SQL is one of an infinite possible relational languages. ... how would making each pixel an ADT or Object improve the picture ...
    (comp.object)
  • Re: To bit or not to bit...
    ... The ANSI X3J programming languages have rules for converting internal ... SQL data types to their native data types as part of the Standards. ... there is no Standard for BIT ... in higher level languages that do not support them (remember COBOL? ...
    (microsoft.public.sqlserver.programming)
  • Re: Is there a mainframe skills shortage?
    ... That's because the author of the article is comparing it to standard SQL. ... and material around Lamdas and functional programming. ... obvious which languages were the ones to learn. ... stick to writing system software and leave applications to the COBOL ...
    (comp.lang.cobol)
  • Re: SQL
    ... SQL is a specific language with certain ... relational nor query languages. ... which don't fully implement ADT. ... interfaces to such are often not as flexible as query-based interfaces. ...
    (comp.object)
  • Re: SQL
    ... SQL is more or less based on "COBOL thinking". ... If you add X with one constraint to Y with other constraint and what would ... RDBMS exist only because in 70s there were no languages capable to provide ... The biggest problem I see with it is that different app languages are ...
    (comp.object)