Friday, August 4, 2017

PostgreSQL pager pspg is ready to work

I spent lot of time on work on pspg. These points are done:
  • support for expanded mode
  • fixed resizing
  • two new styles
  • start is significantly faster
  • lot of display errors was fixed
 This code should be compiled from source code. If you want to test it - you need develop packages of ncursesw. If you don't need wide char support, you can compile pspg against ncurses library (in this case a Makefile should be modified).

Usage:
\setenv PAGER 'pspg -s 2'
\pset pager always
select * from pg_stat_activity;

4 Comments:

At August 5, 2017 at 2:45 PM , Blogger John Frazer said...

Great work, keep it up!

 
At August 10, 2017 at 3:20 PM , Blogger Lacanoid One said...

Wondeful!

I wonder if psql + some external programs could be used to neatly implements some forms/crud/ui, sort of like old dBaseIII worked.

 
At August 10, 2017 at 7:34 PM , Blogger Pavel Stěhule said...

@Lacanoid One: theoretically it is possible - probably you can write bigger application with combination psql + pdmenu + pspg + dialog + bash.

 
At August 10, 2017 at 7:38 PM , Blogger Pavel Stěhule said...

@Lacanoid One - I though about cutting TUI from midnight commander - there is menu system, menu builder and some form of nice form support. I am sure so some TUI application builder + psql + plpgsql can be useful in these days still.

 

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home