Re: [Q] optmizing postgres for 'single client' / many small queries - Mailing list pgsql-general

From David Fetter
Subject Re: [Q] optmizing postgres for 'single client' / many small queries
Date
Msg-id 20090902233528.GL8410@fetter.org
Whole thread Raw
In response to Re: [Q] optmizing postgres for 'single client' / many small queries  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [Q] optmizing postgres for 'single client' / many small queries
List pgsql-general
On Wed, Sep 02, 2009 at 02:45:39PM -0400, Tom Lane wrote:
> "V S P" <toreason@fastmail.fm> writes:
> > Well, actually somebody has written a C++ ORM
> > [ that is causing all your problems and you say you can't discard ]
>
> Just out of curiosity, does anyone know of any ORM anywhere that
> doesn't suck?  They seem to be uniformly awful, at least in terms of
> their interfaces to SQL databases.  If there were some we could
> recommend, maybe people would be less stuck with these bogus legacy
> architectures.

Hibernate has the very nice feature of being able to get out of your
way.  Properly used, it can keep completely out of the business of
making (wrong) guesses based on DDL, which is what ORMs often do.
DBIx::Class <http://search.cpan.org/dist/DBIx-Class/> has gone a long
way in the right direction.

Ones which (attempt to) dictate decisions about DDL are just off the
map. :P

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-general by date:

Previous
From: Karina Guardado
Date:
Subject: problems with function pg_catalog.btrim(date)
Next
From: shane_china
Date:
Subject: Re: install postgis in linux server without desktop