pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPSQL CLI Drivers
10+ messages / 7 participants
[nested] [flat]
* PSQL CLI Drivers
@ 2020-11-11 14:02 Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:10 ` Re: PSQL CLI Drivers John Scalia <jayknowsunix@gmail.com>
2020-11-11 14:10 ` Re: PSQL CLI Drivers Thomas Kellerer <shammat@gmx.net>
0 siblings, 2 replies; 10+ messages in thread
From: Koteswara Rao Daliparthi @ 2020-11-11 14:02 UTC (permalink / raw)
To: pgsql-admin
Hi Guys,
Anyone know what driver does PSQL CLI use under the hood? Is it JDBC??
Thanks & Regards
Koteswara
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PSQL CLI Drivers
2020-11-11 14:02 PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
@ 2020-11-11 14:10 ` John Scalia <jayknowsunix@gmail.com>
1 sibling, 0 replies; 10+ messages in thread
From: John Scalia @ 2020-11-11 14:10 UTC (permalink / raw)
To: Koteswara Rao Daliparthi <koti813@gmail.com>; +Cc: pgsql-admin
It’s directly integrated with the libpq library.
Sent from my iPad
> On Nov 11, 2020, at 9:02 AM, Koteswara Rao Daliparthi <koti813@gmail.com> wrote:
>
> Hi Guys,
>
> Anyone know what driver does PSQL CLI use under the hood? Is it JDBC??
>
>
> Thanks & Regards
> Koteswara
>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PSQL CLI Drivers
2020-11-11 14:02 PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
@ 2020-11-11 14:10 ` Thomas Kellerer <shammat@gmx.net>
2020-11-11 14:30 ` Re: PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
1 sibling, 1 reply; 10+ messages in thread
From: Thomas Kellerer @ 2020-11-11 14:10 UTC (permalink / raw)
To: pgsql-admin
Koteswara Rao Daliparthi schrieb am 11.11.2020 um 15:02:
> Anyone know what driver does PSQL CLI use under the hood? Is it JDBC??
It uses libpq
https://www.postgresql.org/docs/current/libpq.html
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PSQL CLI Drivers
2020-11-11 14:02 PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:10 ` Re: PSQL CLI Drivers Thomas Kellerer <shammat@gmx.net>
@ 2020-11-11 14:30 ` Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:34 ` Re: PSQL CLI Drivers John Scalia <jayknowsunix@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: Koteswara Rao Daliparthi @ 2020-11-11 14:30 UTC (permalink / raw)
To: Thomas Kellerer <shammat@gmx.net>; +Cc: pgsql-admin
Thanks guys, for performance, should we choose libpq or JDBC? I know C will be faster than Java, but just wanted to confirm.
Sent from my iPhone
> On Nov 11, 2020, at 9:10 AM, Thomas Kellerer <shammat@gmx.net> wrote:
>
>
>
> Koteswara Rao Daliparthi schrieb am 11.11.2020 um 15:02:
>> Anyone know what driver does PSQL CLI use under the hood? Is it JDBC??
>
>
> It uses libpq
>
> https://www.postgresql.org/docs/current/libpq.html
>
>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PSQL CLI Drivers
2020-11-11 14:02 PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:10 ` Re: PSQL CLI Drivers Thomas Kellerer <shammat@gmx.net>
2020-11-11 14:30 ` Re: PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
@ 2020-11-11 14:34 ` John Scalia <jayknowsunix@gmail.com>
2020-11-11 19:17 ` Re: PSQL CLI Drivers Holger Jakobs <holger@jakobs.com>
0 siblings, 1 reply; 10+ messages in thread
From: John Scalia @ 2020-11-11 14:34 UTC (permalink / raw)
To: Koteswara Rao Daliparthi <koti813@gmail.com>; +Cc: Thomas Kellerer <shammat@gmx.net>; pgsql-admin
I think that would depend on both what you want to accomplish and the skill sets of your developers. C would certainly be faster, but Java capability may be acceptable to what you’re trying to do.
Sent from my iPad
> On Nov 11, 2020, at 9:31 AM, Koteswara Rao Daliparthi <koti813@gmail.com> wrote:
>
> Thanks guys, for performance, should we choose libpq or JDBC? I know C will be faster than Java, but just wanted to confirm.
>
> Sent from my iPhone
>
>> On Nov 11, 2020, at 9:10 AM, Thomas Kellerer <shammat@gmx.net> wrote:
>>
>>
>>
>> Koteswara Rao Daliparthi schrieb am 11.11.2020 um 15:02:
>>> Anyone know what driver does PSQL CLI use under the hood? Is it JDBC??
>>
>>
>> It uses libpq
>>
>> https://www.postgresql.org/docs/current/libpq.html
>>
>>
>>
>
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PSQL CLI Drivers
2020-11-11 14:02 PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:10 ` Re: PSQL CLI Drivers Thomas Kellerer <shammat@gmx.net>
2020-11-11 14:30 ` Re: PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:34 ` Re: PSQL CLI Drivers John Scalia <jayknowsunix@gmail.com>
@ 2020-11-11 19:17 ` Holger Jakobs <holger@jakobs.com>
2020-11-11 19:21 ` Re: PSQL CLI Drivers David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: Holger Jakobs @ 2020-11-11 19:17 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
You actually have hardly a choice. Depending on the programming
language, you are bound to one driver or the other.
Some features are not supported by the standard JDBC driver,
LISTEN/NOTIFY for instance.
Please exchange the "Sent from my ..." text for your mail signature. Or
do you get paid by the manufacturer?
Am 11.11.20 um 15:34 schrieb John Scalia:
> I think that would depend on both what you want to accomplish and the skill sets of your developers. C would certainly be faster, but Java capability may be acceptable to what you’re trying to do.
>
> Sent from my iPad
>
>> On Nov 11, 2020, at 9:31 AM, Koteswara Rao Daliparthi <koti813@gmail.com> wrote:
>>
>> Thanks guys, for performance, should we choose libpq or JDBC? I know C will be faster than Java, but just wanted to confirm.
>>
>> Sent from my iPhone
>>
>>> On Nov 11, 2020, at 9:10 AM, Thomas Kellerer <shammat@gmx.net> wrote:
>>>
>>>
>>>
>>> Koteswara Rao Daliparthi schrieb am 11.11.2020 um 15:02:
>>>> Anyone know what driver does PSQL CLI use under the hood? Is it JDBC??
>>>
>>> It uses libpq
>>>
>>> https://www.postgresql.org/docs/current/libpq.html
>>>
>>>
>>>
>>
>
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachments:
OpenPGP_0x8A579C93B31961BA.asc (application/pgp-keys, 16.5K) download
OpenPGP_signature (application/pgp-signature, 202B) download
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PSQL CLI Drivers
2020-11-11 14:02 PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:10 ` Re: PSQL CLI Drivers Thomas Kellerer <shammat@gmx.net>
2020-11-11 14:30 ` Re: PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:34 ` Re: PSQL CLI Drivers John Scalia <jayknowsunix@gmail.com>
2020-11-11 19:17 ` Re: PSQL CLI Drivers Holger Jakobs <holger@jakobs.com>
@ 2020-11-11 19:21 ` David G. Johnston <david.g.johnston@gmail.com>
2020-11-11 20:24 ` Re: PSQL CLI Drivers Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: David G. Johnston @ 2020-11-11 19:21 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Wed, Nov 11, 2020 at 12:17 PM Holger Jakobs <holger@jakobs.com> wrote:
> Please exchange the "Sent from my ..." text for your mail signature. Or
> do you get paid by the manufacturer?
>
Really?
More importantly,
Please don't top-posts on these lists, the convention is to inline or
bottom-post, trimming unnecessary content.
Also, reply-all is recommended.
David J.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PSQL CLI Drivers
2020-11-11 14:02 PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:10 ` Re: PSQL CLI Drivers Thomas Kellerer <shammat@gmx.net>
2020-11-11 14:30 ` Re: PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:34 ` Re: PSQL CLI Drivers John Scalia <jayknowsunix@gmail.com>
2020-11-11 19:17 ` Re: PSQL CLI Drivers Holger Jakobs <holger@jakobs.com>
2020-11-11 19:21 ` Re: PSQL CLI Drivers David G. Johnston <david.g.johnston@gmail.com>
@ 2020-11-11 20:24 ` Ron <ronljohnsonjr@gmail.com>
2020-11-11 20:49 ` Re: PSQL CLI Drivers David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 10+ messages in thread
From: Ron @ 2020-11-11 20:24 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 11/11/20 1:21 PM, David G. Johnston wrote:
> On Wed, Nov 11, 2020 at 12:17 PM Holger Jakobs <holger@jakobs.com
> <mailto:holger@jakobs.com>> wrote:
>
> Please exchange the "Sent from my ..." text for your mail signature. Or
> do you get paid by the manufacturer?
>
>
> Really?
>
> More importantly,
>
> Please don't top-posts on these lists, the convention is to inline or
> bottom-post, trimming unnecessary content.
>
> Also, reply-all is recommended.
Reply-to-list is recommended for list discussions.
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PSQL CLI Drivers
2020-11-11 14:02 PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:10 ` Re: PSQL CLI Drivers Thomas Kellerer <shammat@gmx.net>
2020-11-11 14:30 ` Re: PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:34 ` Re: PSQL CLI Drivers John Scalia <jayknowsunix@gmail.com>
2020-11-11 19:17 ` Re: PSQL CLI Drivers Holger Jakobs <holger@jakobs.com>
2020-11-11 19:21 ` Re: PSQL CLI Drivers David G. Johnston <david.g.johnston@gmail.com>
2020-11-11 20:24 ` Re: PSQL CLI Drivers Ron <ronljohnsonjr@gmail.com>
@ 2020-11-11 20:49 ` David G. Johnston <david.g.johnston@gmail.com>
2020-11-11 21:10 ` Re: PSQL CLI Drivers Stephen Frost <sfrost@snowman.net>
0 siblings, 1 reply; 10+ messages in thread
From: David G. Johnston @ 2020-11-11 20:49 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Wednesday, November 11, 2020, Ron <ronljohnsonjr@gmail.com> wrote:
> On 11/11/20 1:21 PM, David G. Johnston wrote:
>
> On Wed, Nov 11, 2020 at 12:17 PM Holger Jakobs <holger@jakobs.com> wrote:
>
>> Please exchange the "Sent from my ..." text for your mail signature. Or
>> do you get paid by the manufacturer?
>>
>
> Really?
>
> More importantly,
>
> Please don't top-posts on these lists, the convention is to inline or
> bottom-post, trimming unnecessary content.
>
> Also, reply-all is recommended.
>
>
> Reply-to-list is recommended for list discussions.
>
>
I can’t actually find a recommendation but just looking at what actually
happens here broadly, and by high-volume posters specifically, reply-all is
the norm. The point is to make sure you include the list, not exclude
individuals (or only reply to individuals).
David J.
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: PSQL CLI Drivers
2020-11-11 14:02 PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:10 ` Re: PSQL CLI Drivers Thomas Kellerer <shammat@gmx.net>
2020-11-11 14:30 ` Re: PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:34 ` Re: PSQL CLI Drivers John Scalia <jayknowsunix@gmail.com>
2020-11-11 19:17 ` Re: PSQL CLI Drivers Holger Jakobs <holger@jakobs.com>
2020-11-11 19:21 ` Re: PSQL CLI Drivers David G. Johnston <david.g.johnston@gmail.com>
2020-11-11 20:24 ` Re: PSQL CLI Drivers Ron <ronljohnsonjr@gmail.com>
2020-11-11 20:49 ` Re: PSQL CLI Drivers David G. Johnston <david.g.johnston@gmail.com>
@ 2020-11-11 21:10 ` Stephen Frost <sfrost@snowman.net>
0 siblings, 0 replies; 10+ messages in thread
From: Stephen Frost @ 2020-11-11 21:10 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Greetings,
* David G. Johnston (david.g.johnston@gmail.com) wrote:
> On Wednesday, November 11, 2020, Ron <ronljohnsonjr@gmail.com> wrote:
> > On 11/11/20 1:21 PM, David G. Johnston wrote:
> > On Wed, Nov 11, 2020 at 12:17 PM Holger Jakobs <holger@jakobs.com> wrote:
> >
> >> Please exchange the "Sent from my ..." text for your mail signature. Or
> >> do you get paid by the manufacturer?
> >
> > Really?
David's correct in his response here, though perhaps a few more words
can help clarify- there's a lot of folks who have signatures that they
use on these lists and there generally isn't any hard and fast rule
about what's acceptable or not, but a one-line comment about the email
being sent from a mobile device is entirely acceptable and does not
deserve comment or concern.
> > Also, reply-all is recommended.
> >
> > Reply-to-list is recommended for list discussions.
>
> I can’t actually find a recommendation but just looking at what actually
> happens here broadly, and by high-volume posters specifically, reply-all is
> the norm. The point is to make sure you include the list, not exclude
> individuals (or only reply to individuals).
Reply-all is the convention used on these lists. I don't think folks
get horribly bent out of shape over reply-to-list, but it can be a bit
confusing and in some cases lead to responses taking longer as some
folks prioritize things that are sent to them directly (because they've
engaged in that thread) vs. the rest of the email that hits the list.
There's certainly arguments for if that's really the 'best' approach or
not, but it's been convention here for at least the past 15 years, so I
don't expect it's likely to change anytime soon. :)
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2020-11-11 21:10 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-11-11 14:02 PSQL CLI Drivers Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:10 ` John Scalia <jayknowsunix@gmail.com>
2020-11-11 14:10 ` Thomas Kellerer <shammat@gmx.net>
2020-11-11 14:30 ` Koteswara Rao Daliparthi <koti813@gmail.com>
2020-11-11 14:34 ` John Scalia <jayknowsunix@gmail.com>
2020-11-11 19:17 ` Holger Jakobs <holger@jakobs.com>
2020-11-11 19:21 ` David G. Johnston <david.g.johnston@gmail.com>
2020-11-11 20:24 ` Ron <ronljohnsonjr@gmail.com>
2020-11-11 20:49 ` David G. Johnston <david.g.johnston@gmail.com>
2020-11-11 21:10 ` Stephen Frost <sfrost@snowman.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox