Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-14 Thread Karsten Hilbert
On Sun, Aug 14, 2016 at 04:02:19PM +0200, Chris Travers wrote: > One example is of such a service locator is > http://search.cpan.org/dist/PGObject-Simple/lib/PGObject/Simple.pm > > It runs as a library which helps the program decide how to do the call. > Currently it looks in the system catalog

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-14 Thread Chris Travers
On Sun, Aug 14, 2016 at 3:42 PM, Karsten Hilbert wrote: > Hello Chris, > > I am getting closer but ... > > > > > Sure. What I prefer to do is to allow for a (cacheable) lookup on > the > > > > basis of some criteria, either: > > > > 1. Function name or > > > > 2. Function name and first argume

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-14 Thread Karsten Hilbert
Hello Chris, I am getting closer but ... > > > Sure. What I prefer to do is to allow for a (cacheable) lookup on the > > > basis of some criteria, either: > > > 1. Function name or > > > 2. Function name and first argument type > > > > > > This assumes that whichever discovery criteria you are

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-14 Thread Chris Travers
On Sun, Aug 14, 2016 at 12:35 PM, Karsten Hilbert wrote: > On Fri, Aug 12, 2016 at 01:32:33PM +0200, Chris Travers wrote: > > >>> My preference is stored procedures plus service locators > >> > >> Would you care to elaborate a little on the latter (service locators) ? > >> > > > > Sure. What I p

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-14 Thread Karsten Hilbert
On Fri, Aug 12, 2016 at 01:32:33PM +0200, Chris Travers wrote: >>> My preference is stored procedures plus service locators >> >> Would you care to elaborate a little on the latter (service locators) ? >> > > Sure. What I prefer to do is to allow for a (cacheable) lookup on the > basis of some c

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-12 Thread Chris Travers
On Fri, Aug 12, 2016 at 11:32 AM, Karsten Hilbert wrote: > På fredag 12. august 2016 kl. 10:33:19, skrev Chris Travers < > chris.trav...@gmail.com[chris.trav...@gmail.com]>: > > > My preference is stored procedures plus service locators > > I know your work on the former with respect to the finan

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-12 Thread Chris Travers
On Fri, Aug 12, 2016 at 11:24 AM, Daevor The Devoted wrote: > > > On Fri, Aug 12, 2016 at 10:58 AM, Andreas Joseph Krogh > wrote: > > Could you elaborate on this method? Or direct me to docs describing it in > more detail? I'm quite interested in this approach, but would like to see > what amoun

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-12 Thread Karsten Hilbert
På fredag 12. august 2016 kl. 10:33:19, skrev Chris Travers :   > My preference is stored procedures plus service locators I know your work on the former with respect to the financial app you are working on. Would you care to elaborate a little on the latter (service locators) ? Thanks, Karsten

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-12 Thread Andreas Joseph Krogh
På fredag 12. august 2016 kl. 11:24:16, skrev Daevor The Devoted < doll...@gmail.com >:   [snip] If you don't like your domain-model to be very close to your physical DB-model, there's nothing preventing you from having a persistence-model, using the ORM, and map that to

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-12 Thread Daevor The Devoted
On Fri, Aug 12, 2016 at 10:58 AM, Andreas Joseph Krogh wrote: > På fredag 12. august 2016 kl. 10:33:19, skrev Chris Travers < > chris.trav...@gmail.com>: > > > > On Fri, Aug 12, 2016 at 9:59 AM, Andreas Joseph Krogh > wrote: >> >> På fredag 12. august 2016 kl. 05:27:42, skrev Chris Travers < >>

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-12 Thread Andreas Joseph Krogh
På fredag 12. august 2016 kl. 11:07:08, skrev Chris Travers < chris.trav...@gmail.com >: [snip] My preference is stored procedures plus service locators, to be honest.  It enables a degree of loose coupling and even dynamic discovery that ORMs are generally not wel

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-12 Thread Chris Travers
On Fri, Aug 12, 2016 at 10:58 AM, Andreas Joseph Krogh wrote: > På fredag 12. august 2016 kl. 10:33:19, skrev Chris Travers < > chris.trav...@gmail.com>: > > > > >> >> Of course you *can* use them well. I remember talking about this with >> one author or a major ORM and he said that on thing he

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-12 Thread Andreas Joseph Krogh
På fredag 12. august 2016 kl. 10:33:19, skrev Chris Travers < chris.trav...@gmail.com >:     On Fri, Aug 12, 2016 at 9:59 AM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På fredag 12. august 2016 kl. 05:27:42, skrev Chris Travers mailto:chris.trav...@gma

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-12 Thread Chris Travers
On Fri, Aug 12, 2016 at 9:59 AM, Andreas Joseph Krogh wrote: > På fredag 12. august 2016 kl. 05:27:42, skrev Chris Travers < > chris.trav...@gmail.com>: > > > > On Thu, Aug 11, 2016 at 10:20 PM, Andreas Joseph Krogh > wrote: >> >> På torsdag 11. august 2016 kl. 19:13:08, skrev support-tiger < >>

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-12 Thread Andreas Joseph Krogh
På fredag 12. august 2016 kl. 05:27:42, skrev Chris Travers < chris.trav...@gmail.com >:     On Thu, Aug 11, 2016 at 10:20 PM, Andreas Joseph Krogh mailto:andr...@visena.com>> wrote: På torsdag 11. august 2016 kl. 19:13:08, skrev support-tiger mailto:supp...@tigerna

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-11 Thread Chris Travers
On Thu, Aug 11, 2016 at 10:20 PM, Andreas Joseph Krogh wrote: > På torsdag 11. august 2016 kl. 19:13:08, skrev support-tiger < > supp...@tigernassau.com>: > > I cannot not comment on this. Saying that ORM seems dumb, and working with > PG using ORM does not fly, is a very good recipe for not bein

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-11 Thread Melvin Davidson
On Thu, Aug 11, 2016 at 4:20 PM, Andreas Joseph Krogh wrote: > På torsdag 11. august 2016 kl. 19:13:08, skrev support-tiger < > supp...@tigernassau.com>: > > A database is only as good as the ability to use it. Using ORM's with > Postgres seems dumb, like having a Ferrari but only allowed to dri

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-11 Thread Andreas Joseph Krogh
På torsdag 11. august 2016 kl. 19:13:08, skrev support-tiger < supp...@tigernassau.com >: A database is only as good as the ability to use it.  Using ORM's with Postgres seems dumb, like having a Ferrari but only allowed to drive 25 kmh. Really, for getting data in

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-11 Thread Alvaro Herrera
support-tiger wrote: > It would be great if the Ruby and Node drivers can be brought under the > Postgres team umbrella and make them as reliable and clearly documented as > the Python or jdbc drivers. Sadly, the PostgreSQL development group does not have the manpower to maintain or document clie

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-11 Thread Joshua D. Drake
On 08/11/2016 10:43 AM, David G. Johnston wrote: On Thu, Aug 11, 2016 at 1:13 PM, support-tiger mailto:supp...@tigernassau.com>>wrote: It would be great if the Ruby and Node drivers can be brought under the Postgres team umbrella and make them as reliable and clearly documented as th

Re: [GENERAL] Postgres Pain Points 2 ruby / node language drivers

2016-08-11 Thread David G. Johnston
On Thu, Aug 11, 2016 at 1:13 PM, support-tiger wrote: > It would be great if the Ruby and Node drivers can be brought under the > Postgres team umbrella and make them as reliable and clearly documented as > the Python or jdbc drivers. What makes you say that the Python are JDBC drivers are "und