Обсуждение: pspg - psql pager

Hi
 

I finished new pager, that can be interesting for postgresql expert users.
 

It demonstrate some possibilities of TUI and I hope it shows some possible directions of future possibilities of psql.
 

It is available as rpm from our repository or you can get source code from github

https://github.com/okbob/pspg
 

I invite any discussion about this project.
 

Pavel
 

p.s. I hope so this pager is useful - I know some users who use it few months intensively. But the source code has proof concept quality. It should be cleaned next year.

On Wed, Nov 15, 2017 at 4:45 AM, Andreas Joseph Krogh
<andreas@visena.com> wrote:
> På onsdag 15. november 2017 kl. 10:41:45, skrev Pavel Stehule
> <pavel.stehule@gmail.com>:
>
> Hi
>
> I finished new pager, that can be interesting for postgresql expert users.
> Thanks for making this, "-X --no-mouse" made my day.

This was my first bugfix/suggestion :-D.

I use psql all day, every day.   PSPG IS AWESOME, IF YOU USE PSQL GET
IT AND DON'T LOOK BACK.   There are no major issues with it; it's
wonderful.  I do not advise a global definition of PAGER...it will
break other utilities (like man).  I find the best way to invoke the
functionality is via bash:

alias psql='PAGER="/home/mmoncure/pspg -s0 -X --no-mouse" psql'

Thank you Pavel.

merlin

2017-11-15 Merlin Moncure <mmoncure@gmail.com>:

> I use psql all day, every day.   PSPG IS AWESOME, IF YOU USE PSQL GET
> IT AND DON'T LOOK BACK.
[..]
> Thank you Pavel.

+1!

I especially love it for the improved handling of wide tables (which
are really annoying with “less”). Also --no-mouse is mandatory for me
because I want to be able to copy/paste pieces of text using my
terminal’s mouse handling.

I didn’t find a way yet to get it as a Debian package, but for now I
just compile it manually.

Thanks a lot,

Nicolas

--
Nēdırlands: https://baviaan.be/N%C4%93d%C4%B1rlands/

On 2017-11-15 10:41, Pavel Stehule wrote:
> Hi
>
> I finished new pager, that can be interesting for postgresql expert users.
>
> It demonstrate some possibilities of TUI and I hope it shows some possible
> directions of future possibilities of psql.
>
> It is available as rpm from our repository or you can get source code from
> github
>
> https://github.com/okbob/pspg
>
> I invite any discussion about this project.
>
> Pavel
>
> p.s. I hope so this pager is useful - I know some users who use it few
> months intensively. But the source code has proof concept quality. It
> should be cleaned next year.

I likes it. I likes it a lot.

And, you’ve got a PR on GitHub from me.

It’s available on Gentoo now!

commit 76fcf5d6c72c89e33c14549ab01dc96ec3ca8a1b
Author: Aaron W. Swenson <titanofold@gentoo.org>
Date:   Thu Nov 16 10:32:04 2017 -0500
   dev-db/pspg: Initial commit
   Introducing a new and better pager to be used with PostgreSQL’s psql.
   Package-Manager: Portage-2.3.13, Repoman-2.3.3


This was probably the fastest and easiest project I’ve made an ebuild for.

On Thu, Nov 16, 2017 at 11:04 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> 2017-11-16 16:40 GMT+01:00 Aaron W. Swenson <titanofold@gentoo.org>:
>> I likes it. I likes it a lot.
>>
>> And, you’ve got a PR on GitHub from me.
>>
>> It’s available on Gentoo now!

This would be great package for inclusion in pgdg packaging as well.
Dependencies are minor and compile risk is low.

merlin

Il 15/11/17 10:41, Pavel Stehule ha scritto:
> Hi
>
> I finished new pager, that can be interesting for postgresql expert users.
>

It is now on apt.postgresql.org

  http://postgr.es/m/E1eFc37-0007rV-8g@atalia.postgresql.org

And will be in Debian Unstable soon as it is in the NEW queue for manual
review from Debian's FTP Master.

   https://ftp-master.debian.org/new/pspg_0.5-1.html

Regards,
Marco

--
Marco Nenciarini - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
marco.nenciarini@2ndQuadrant.it | www.2ndQuadrant.it

Il 15/11/17 10:41, Pavel Stehule ha scritto:
> Hi
>
> I finished new pager, that can be interesting for postgresql expert users.
>

It is now on apt.postgresql.org

  http://postgr.es/m/E1eFc37-0007rV-8g@atalia.postgresql.org

And will be in Debian Unstable soon as it is in the NEW queue for manual
review from Debian's FTP Master.

   https://ftp-master.debian.org/new/pspg_0.5-1.html

Regards,
Marco

Hi,

[Removed my email address in the OP, which I am not using since 2010 ;) ]

On Thu, 2017-11-16 at 17:13 -0600, Merlin Moncure wrote:
> This would be great package for inclusion in pgdg packaging as well.

I released this package on Sep 15th, but just noticed the latest version. Pavel
usually creates tickets to ping me, so we are usually up-to-date. The updated
packages will appear in the repos around 30 mins later.

Regards,
--
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR