Re: pspg pager is finished

[Pavel Stehule]

ne 21. 3. 2021 v 0:48 odesílatel Thomas Munro 
napsal:

> On Sat, Mar 20, 2021 at 4:35 PM Pavel Stehule 
> wrote:
> > I finished work on pspg.
>
> tmunro@x1:~/projects/postgresql$ pspg --stream --graph
> pspg: unrecognized option '--graph'
> Try pspg --help
>
> Hmm, seems to be not finished :-)
>

:-)

Re: pspg pager is finished

[Thomas Munro]

On Sat, Mar 20, 2021 at 4:35 PM Pavel Stehule  wrote:
> I finished work on pspg.

tmunro@x1:~/projects/postgresql$ pspg --stream --graph
pspg: unrecognized option '--graph'
Try pspg --help

Hmm, seems to be not finished :-)

Re: pspg pager is finished

[dinesh kumar]

On Sat, Mar 20, 2021 at 9:05 AM Pavel Stehule 
wrote:

> Hi
>
> I finished work on pspg.
>
> https://github.com/okbob/pspg
>
> Now it has special features like rows or block selection by mouse, and
> export related data to file or to clipboard in csv or tsv or insert
> formats. Some basic features like sorting data per selected columns are
> possible too.
>
> I hope this tool will serve well, and so work with Postgres (or other
> supported databases) in the terminal will be more comfortable and more
> efficient.
>
> Regards
>
> Pavel Stehule
>

It's awesome Pavel,

Building UI at console level is a serious stuff, and I love it.
Thank you so much for all your efforts.

-- 

Regards,
Dinesh
manojadinesh.blogspot.com

Re: pspg pager is finished

[Pavel Stehule]

so 20. 3. 2021 v 17:01 odesílatel Nikolay Samokhvalov 
napsal:

> On Fri, Mar 19, 2021 at 20:35 Pavel Stehule 
> wrote:
>
>> Hi
>>
>> I finished work on pspg.
>>
>> https://github.com/okbob/pspg
>>
>
> Thank you, Pavel. I use it always when possible, and highly recommend it
> to others.
>
>> 
>>
> Nik
>

Thank you

Pavel

Re: pspg pager is finished

[Nikolay Samokhvalov]

On Fri, Mar 19, 2021 at 20:35 Pavel Stehule  wrote:

> Hi
>
> I finished work on pspg.
>
> https://github.com/okbob/pspg
>

Thank you, Pavel. I use it always when possible, and highly recommend it to
others.

> 
>
Nik

Re: pspg pager is finished

[Pavel Stehule]

so 20. 3. 2021 v 7:51 odesílatel Vik Fearing 
napsal:

> On 3/20/21 4:34 AM, Pavel Stehule wrote:
> > Hi
> >
> > I finished work on pspg.
> >
> > https://github.com/okbob/pspg
> >
> > Now it has special features like rows or block selection by mouse, and
> > export related data to file or to clipboard in csv or tsv or insert
> > formats. Some basic features like sorting data per selected columns are
> > possible too.
> >
> > I hope this tool will serve well, and so work with Postgres (or other
> > supported databases) in the terminal will be more comfortable and more
> > efficient.
>
> If this means active development on it is finished, I would like to see
> this integrated into the tree, perhaps even directly into psql itself
> (unless the user chooses a different pager).  It is that useful.
>

yes, - almost all my ideas are implemented - and I have no plans to write
pspg as a light spreadsheet. It is just a pager.

Unfortunately, the source code of pspg has not required postgres quality. I
wrote it mostly alone without reviews and without initial experience with
this kind of application. Some implemented interactive features are very
complex (for terminal applications), and not too simply understandable. The
code is not too bad, if I compare it with source code of "more" or "less",
but again, there was not any check of other eyes. There are not any regress
tests, so I don't think so integration too core can be a good idea. Review
of about 35000 lines can be terrible work, but this project needs it  to
move forward . On second hand, it uses a lot of Postgres C patterns. And
any new development can be more concentrated on quality and less to
research.

Although pspg has not Postgres quality, it is a good tool that is used by a
lot of people. Can be nice to be propagated inside Postgres documentation,
or some Postgres demos.

pspg is now in my private repository (and although it uses BSD licence), I
will be proud if it can be moved to some community repository, and if the
community takes more control and all rights to this project.

Now, I would work more on other projects than pspg - and then pspg will be
in maintenance mode. I'll fix all reported errors.


> Thank you, Pavel, for this work.
>

Thank you :)

Pavel

-- 
> Vik Fearing
>

Re: pspg pager is finished

[Vik Fearing]

On 3/20/21 4:34 AM, Pavel Stehule wrote:
> Hi
> 
> I finished work on pspg.
> 
> https://github.com/okbob/pspg
> 
> Now it has special features like rows or block selection by mouse, and
> export related data to file or to clipboard in csv or tsv or insert
> formats. Some basic features like sorting data per selected columns are
> possible too.
> 
> I hope this tool will serve well, and so work with Postgres (or other
> supported databases) in the terminal will be more comfortable and more
> efficient.

If this means active development on it is finished, I would like to see
this integrated into the tree, perhaps even directly into psql itself
(unless the user chooses a different pager).  It is that useful.

Thank you, Pavel, for this work.
-- 
Vik Fearing

Re: pspg pager is finished

[Pavel Stehule]

so 20. 3. 2021 v 4:45 odesílatel Julien Rouhaud  napsal:

> On Sat, Mar 20, 2021 at 04:34:30AM +0100, Pavel Stehule wrote:
> > Hi
> >
> > I finished work on pspg.
> >
> > https://github.com/okbob/pspg
> >
> > Now it has special features like rows or block selection by mouse, and
> > export related data to file or to clipboard in csv or tsv or insert
> > formats. Some basic features like sorting data per selected columns are
> > possible too.
> >
> > I hope this tool will serve well, and so work with Postgres (or other
> > supported databases) in the terminal will be more comfortable and more
> > efficient.
>
> Thanks a lot for that tool Pavel.  It has been my favorite psql pager for
> years!
>

Thank you

Pavel

Re: pspg pager is finished

[Julien Rouhaud]

On Sat, Mar 20, 2021 at 04:34:30AM +0100, Pavel Stehule wrote:
> Hi
> 
> I finished work on pspg.
> 
> https://github.com/okbob/pspg
> 
> Now it has special features like rows or block selection by mouse, and
> export related data to file or to clipboard in csv or tsv or insert
> formats. Some basic features like sorting data per selected columns are
> possible too.
> 
> I hope this tool will serve well, and so work with Postgres (or other
> supported databases) in the terminal will be more comfortable and more
> efficient.

Thanks a lot for that tool Pavel.  It has been my favorite psql pager for
years!

pspg pager is finished

[Pavel Stehule]

Hi

I finished work on pspg.

https://github.com/okbob/pspg

Now it has special features like rows or block selection by mouse, and
export related data to file or to clipboard in csv or tsv or insert
formats. Some basic features like sorting data per selected columns are
possible too.

I hope this tool will serve well, and so work with Postgres (or other
supported databases) in the terminal will be more comfortable and more
efficient.

Regards

Pavel Stehule