Re: Why is MySQL more chosen over PostgreSQL?

On 3 Aug 2002, Hannu Krosing wrote:

> On Sat, 2002-08-03 at 16:32, Curt Sampson wrote:
> > On 2 Aug 2002, Hannu Krosing wrote:
> >
> > Perhaps this is the problem. I disagree that it's  a "higher" level.
>
> I don't mean "morally higher" ;)
> Just more concise and easier to grasp, same as VIEW vs. TABLE + ON xxx
> DO INSTEAD rules.

That's because we don't do a good job of implementing updatable views.
Views ought to be as fully updatable as possible given the definition,
without having to define rules for doing this. Simple views such as

    CREATE TABLE tab1 (
	id	int,
	foo	text
	)
    CREATE TABLE tab2 (
	id	int,
	bar	text
	)
    CREATE VIEW something AS
	SELECT tab1.id, tab1.foo, tab2.bar
	FROM tab1, tab2
	WHERE tab1.id = tab2.id

ought to be completely updatable without any special rules.

For further info see the detailed discussion of this in Date's
database textbook.

> That is the same way that C is "higher" than ASM and ASM is higher than
> writing code directly using hex editor.

No, this is the same way that Smalltalk is "higher" than Lisp.
(I.e., it isn't.)

cjs
-- 
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC