Re: PostgreSQL vs MySQL banter.

Bravo

Good points.

Most *nix systems are finaly working toward POSIX compliance.

Most SQL systems are working toward SQL92 {I think} compliance.

On the other hand just because you are compliant does not mean that your
code is portable. I don't want this point to turn into a thread, it just
isn't important enough.

There are even RDBMS systems that don't use SQL and that does not make
them bad, it just makes them different.

I used to write my databases in C using an algorythm I developed myself
that is simmilar to but before btree existed. My engine kept indexes in
a pointer of pointers type format in memory, that was quick and didn't
require a lot of memory. Those databases ran on an IBM PC-XT with 512 kB
ram and a 10 MB HD and easily handled 64K interlinked records with an
average of 8 probes per query. Oh and by the way that was on dos 3.2{if
my memory serves me correctly} with Borland Turbo C, but I forget wich
memory model I used {It has been 6 years since I did any non *nix
programming}.

Guy Fraser

Otto Hirr wrote:
>
> > ...
> > ... mysql v postgres
> > ...
>
> In a book on marketing warfare (maybe the one
> by Ries & Trout) there was a question about who
> was the competitor:
>
> You own a hotel on a small desert island
...snip...
> who is the real, significant competitor.
>
> It reminds me about unix. Let see, is it
> Sun or HP that has the better unix.
...snip...
> unix v MS Windows...
> What would have happened if the unix vendors
> laid down their NIH and joined each other?
>
> So who is the real, important competitor?
> Is it so much important to "compete"
> between mysql and postgres, or is it more
> important to compete with the proprietary
> databases. They all must laugh themselves
> silly at times.
>
> But I tell you that there would be a WHOLE
> lot more concern if the HUGE amount of brains
> and talent on both these projects all laid
> down their editors, compilers, os's, and their
> deeply entrenched NIH attitude and join
> forces with each other. What would that be
> like? Is it possible? So you feel like
> competing, then compete against your own
> self to ask what you could learn from each
> other, then change direction and compete
> against your COMMON competitor - the
> proprietary databases.
>
> Just some rambling thoughts - and certainly
> not to try and tit-for-tat war.
>
> Regards,
>
> .. Otto
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
There is a fine line between genius and lunacy, fear not, walk the
line with pride. Not all things will end up as you wanted, but you
will certainly discover things the meek and timid will miss out on.