An introduction and a plea ... - Mailing list pgsql-hackers

From Emmanuel Charpentier
Subject An introduction and a plea ...
Date
Msg-id 20000206.17574200@localhost.localdomain
Whole thread Raw
List pgsql-hackers
Dear pgsql-hackers list,

First a few words of introduction : I'm 43 and, while I have been 
introduced to computing for a long time (my first exposure was a small 
Fortran exercise I wrote in '74 (!) for a timesharing system on an 
hardcopy terminal ...), my coding abilities are somewhat rusty. I am 
mainly a user by now, no longer a coder, and my interests in computers 
is now in making my life simpler (I'm a biostatistician, among other 
things).I probably won't be contributing any code to PostgreSQL. Some 
bug reports, maybe ...

However, I've lurked on some of the PostgreSQL lists for 2 to 3 months 
(through the Web interface), and I feel that I might offer some 
advice, based on my past experience of seeing a lot of projects 
growing (or dying, due to feeping creaturism(TM) ...).

So I will shamelessly pull my first plea, related to the proposed 
change to the default behaviour of PostgreSQL in querying classes with 
subclasses.

I *strongly* suggest not to change anything in the default behaviour, 
which is what is expected from an SQL-compliant system, even if the 
database in question uses inheritance internally.

The reason for that plea is that a modification would crash any 
program not explicitly written for inheritance features : such 
features might be used by, say, the administrator and coere 
programmers of a database, who are not necessarily publish this 
internal use of inheritance to end-users. Furthermore, such a change 
would forbid evolution of a database from a pure-relational to an 
object-orien,ted one : the two representations would be incompatible.

It should also pointed out that most interface programs (such as ODBC 
or JDBC drivers) are not and will not in a foreseeable future be 
designed for use of these features. Modifying the default behaviour 
would break them.

Apart from that, I am, after 17 years of exposure to the concepts of 
object-oriented programming, still to be convinced of the value of 
this paradigm. This is *not* to suggest that these developments should 
be left over ! However, I *feel* that the real issues behind this 
concept are not yet fully understood, and that some deep theoretical 
work remains to be done (in logic, for example : while the 
well-understood relational theory directly relates to set theory, I 
think that a mathematically correct objects-and-types theory shoud 
emanate from category theory but remains to be created ...).

Your thoughs ?
                    Emmanuel Charpentier






pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] TODO item
Next
From: Roland Roberts
Date:
Subject: Re: [HACKERS] psql -e and -n flags