Re: how good is PostgreSQL - Mailing list pgsql-general

From KuroiNeko
Subject Re: how good is PostgreSQL
Date
Msg-id 39FF33AA.nail1GB11XPNX@ed.ed
Whole thread Raw
In response to how good is PostgreSQL  ("Arnold Gamboa" <arnold@php4us.com>)
List pgsql-general
>      As programmers, we naturally want to throw things into databases for
> three reasons. First, it's easy to get  data in. Second, it's easy to get
> relevant data  out. And third,  it's "cool". We  don't want to  work with
> flat files, now do we? ; )

 Kiddin', eh? :)  Actually, the third reason seems to  dominate the younger
developers' minds. People often tend to  keep everything in poor DBMS until
it begins  to kick back.  And this has impact  on the customers.  Does your
system use a database?  No, why should it? You mean  you'll keep our dearly
beloved banner  ads as flat files?  Yes, this is where  they belong. Sorry,
we'll seek for someone more advanced. Good luck.
 Of course, hardware  vendors jump up of  joy :) Maybe I don't  get it, but
IMHO there's no reason  to put into DB something that  can't be indexed and
used in where clause.

> It would *not* allow the
> database to  do joins, it  would grab entire tables,  then try to  do the
> joins
> itself, in Perl.

 Umh.... Yeah....  Well.... To  keep compatibility  with other  Open Source
Databases and ESR/RMS, you know :)

>    (Incidentally,  we've toyed  around with  developping a  query-caching
> system that would sit betwen PostgreSQL and our DB libraries.

 Sounds  amazing, but  requires some  research, I  guess. However,  in many
cases one  would be  more than  happy with  cahced connections.  Of course,
cahced query results  can be naturally added to that,  but just connections
are OK to start with. Security....


--

 contaminated fish and microchips
  huge supertankers on Arabian trips
 oily propaganda from the leaders' lips
  all about the future
 there's people over here, people over there
  everybody's looking for a little more air
 crossing all the borders just to take their share
  planning for the future

 Rainbow, Difficult to Cure

pgsql-general by date:

Previous
From: "Kevin O'Gorman"
Date:
Subject: Re: how good is PostgreSQL
Next
From: Andrew Sullivan
Date:
Subject: Easy way to find out allowed data?