pspg VS textual

pspg is a pager intended to be used with SQL command line clients. It was originally created for Postgres (hence the name), but also works with MySQL and others

https://github.com/okbob/pspg

> I am regularly surprised how bad the tooling is for SQL/databases.

This. I'd really like to have a working SQL pretty printer/formatter. Psql is great, but lacks autocompletion in several places.

That said, a big shoutout to pspg (https://github.com/okbob/pspg) - an excellent pager for psql (also for general csvs).

Possibly the best pager for tabular data out there is https://github.com/okbob/pspg ; it accepts generic inputs so results can be piped via shell command.

I am trying to use: https://github.com/okbob/pspg

The Textual project has a lot of screenshots in its documentation. These screenshots are built with the docs, so they are always up to date.

https://textual.textualize.io/

Textual[0] does this for CLI apps. That’s not for full GUI apps, but it’s very DOM-like, uses CSS selectors, etc. and a cool option when it meets your needs.

[0] https://github.com/Textualize/textual

For future projects that need a TUI beyond normal printing to a terminal, I'd recommend taking a look at Textual.

https://jupyterbook.org/en/stable/content/code-outputs.html#...

`less -R` is not the default.

FWIW, textual (and urwid) does ANSII escape codes well: https://github.com/Textualize/textual

  touch file$'\n'name

After installing logmerger, you can run a self-contained demo by running logmerger --demo, to view two log files before and after they are merged, and to play with the user-interface features provided by textual.

I think it just survived naturally, filling in the cracks left by Java / C++.

And not the era of Textual (https://textual.textualize.io/) is here, python may get the spotlight even more.