News for hackers. Stuff that matters.
Re:Usql – Universal command-line interface for SQL databases by flas9sd on Thursday June 14, 2018 @10:52AM (#17312155)
I'm really waiting for "Todo -> General -> 13. proper PAGER support". Because the sqlite3 cli never had support if I remember correctly, so piping to less was always neccessary. A pager is key to getting comfortable on the cli imho.
Re:Usql – Universal command-line interface for SQL databases by vram22 on Thursday June 14, 2018 @01:39PM (#17313564)
Yes, that's a good feature to have. IIRC, IPython does not have it either, so, for example, if you do a dir(object_name) for some object, like a module, class, function, etc., if it has too many attributes, they scroll off the screen, more so since IPython prints the attributes one per line. The CPython shell is better for this, since it prints multiple attributes per line. For IPython, I have to do this:

    for at in dir(object_name):
        print at,
and that will still scroll off if it is too long (although in that case it would scroll off in Python too). So a built-in pager would be useful for many such apps, since it will allow you to stay in the app; if you pipe the app's output to less, you cannot interact with the app via the keyboard, until you quit the less invocation.
Re:Usql – Universal command-line interface for SQL databases by orf on Thursday June 14, 2018 @08:50PM (#17316649)
%page dir(object), %pinfo or %help object are your friends.
Re:Usql – Universal command-line interface for SQL databases by vram22 on Friday June 15, 2018 @06:37AM (#17318754)
Great, will check those out, thanks.