Thread: pspg pager is finished
Hi
I finished work on 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
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!
so 20. 3. 2021 v 4:45 odesílatel Julien Rouhaud <rjuju123@gmail.com> 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
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
so 20. 3. 2021 v 7:51 odesílatel Vik Fearing <vik@postgresfriends.org> 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
On Fri, Mar 19, 2021 at 20:35 Pavel Stehule <pavel.stehule@gmail.com> wrote:
Thank you, Pavel. I use it always when possible, and highly recommend it to others.
Nik
so 20. 3. 2021 v 17:01 odesílatel Nikolay Samokhvalov <samokhvalov@gmail.com> napsal:
On Fri, Mar 19, 2021 at 20:35 Pavel Stehule <pavel.stehule@gmail.com> wrote:Thank you, Pavel. I use it always when possible, and highly recommend it to others.Nik
Thank you
Pavel
On Sat, Mar 20, 2021 at 9:05 AM Pavel Stehule <pavel.stehule@gmail.com> wrote:
HiI finished work on 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.RegardsPavel 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.
On Sat, Mar 20, 2021 at 4:35 PM Pavel Stehule <pavel.stehule@gmail.com> 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 :-)
ne 21. 3. 2021 v 0:48 odesílatel Thomas Munro <thomas.munro@gmail.com> napsal:
On Sat, Mar 20, 2021 at 4:35 PM Pavel Stehule <pavel.stehule@gmail.com> 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 :-)
:-)