@Braiam The adminstration? You mean the government?

That Youtube link I posted is really kind of amazing. I recommend watching it.

@Braiam All sorts of bad happening here. I hope you're doing better over there. Stay safe.

Does anyone know how to scroll with the sqlite3 command line client? That's a nice feature which is available in psqsl, for example.

This was asked on SO in 2012.

Litecli (Python) looks good.

@FaheemMitha I can scroll perfectly well in it. Both with my mouse wheel and with alt+pageUp/down. I think it's a question of your terminal, not the sqlite3 command.

I use terminator.

terminator-gtk3.readthedocs.io/en/latest

@Kusalananda you just blew my mind.

I had no idea perl did that!

What does Perl not do? :-P

True. But wow:

$ perl -e 'print "a" x 1_0_7_6' | wc -c
1076

That just seems weird :)

It's a nifty thing to know about if you need to write big constants.

Indeed. And is it specific to _ or can I use other delimiters?

I think it needs to be an underscore.

perldoc.perl.org/5.32.0/perldata.html#Scalar-value-constructors

@terdon I can use the mouse wheel, but it's not optimal. Alt-PgUp/Down.just produces random characters on the command line.

@FaheemMitha what about Shift+PgUp/PgDn?

@StephenKitt Hmm, that does work, but it doesn't get all the way to the top. I think that's just Konsole's native terminal scrolling.

I.e. one can use it to scroll up anything.

@FaheemMitha yes, which was also terdon’s point

@StephenKitt Right. I want scrolling inside the program.

psql has it. And litecli has it too.

or perhaps I misunderstood terdon’s comment and his scrolling is handled by sqlite3

@StephenKitt I think he's using terminal scrolling. Which is better than nothing, if nothing else is available, but it's not optimal.

@StephenKitt no, I have infinite scrollback in the terminal.

@FaheemMitha Why? It makes no difference who handles it, if you can scroll, you can scroll

It has the advantage of working with anything (which doesn’t take over the display), and supporting features such as searches...

@terdon Ah. I definitely don't have infinite scrollback available. Whether Konsole supports it, I don't know.

@terdon Maybe it doesn't make a difference if there is infinite scrolling. I don't know.

I never liked konsole, not even when I was using KDE. It, like all of KDE, seemed needlessly heavy and resource hungry.

@terdon What do you use?

@terdon No, I mean generally.

You said you don't like KDE. I guess the DM, or whatever the correct terminology is?

Oh, I've been using Cinnamon since gnome went to gnome3

@terdon That's a GNOME 3 fork?

But lighter than KDE?

Gnome2 fork, I think. Or gnome3 fork but made to look like gnome2

@FaheemMitha I believe there may well be neutron stars lighter than KDE.

Although, to be fair, I haven't used KDE in the past 10 years or more.

@terdon I've used KDE since 1999, since it was KDE 1, I think. I'm used to it.

Oh, I see Stephen responded above. I didn't register it.

Yes, I guess searching is an advantage.

I don't know if terminal scrolling supports searching. I've never tried.

I wonder what advantage a library like docs.python.org/3/library/sqlite3.html has over just calling sqlite3 on the command line using subprocess..

@FaheemMitha you can use Python data structures with the library, and you don’t need to write your own parser

@StephenKitt I suppose that could be an advantage in some situations. Or one could even use something like SQLAlchemy. Which has an ORM.

@FaheemMitha What is psqsl? Is it an alias of psql?

@FaheemMitha stephen kitt is correct. If you use process communication directly, you will have to parse the result which is a pure string. I have never done that and not sure how to get a pure string as a result

SQLAlchemy provides OO interface, and is implemented based on sqlite3,

There is a kind of logic called "relational logic". I am wondering if that is the foundation of relational database

See intrologic.stanford.edu/public/textbook.php

I haven't read much yet. I was wondering if relational algebra is based on relational calculus which then based on relational logic

@Tim Typo, sorry. That should have been psql. The PostgreSQL command line client.

@StephenKitt Kiss my daughter, sniff a flower, get in awe when listening to Carl Orff's Carmina Burana. A pretty long list of things, Stephen.

@terdon python does that too as of 3.6 or 3.7

@AndrasDeak Bah, of course. Python is always trying to copy perl and be a proper language! :P

each day we stray further away from the light python.org/dev/peps/pep-0622

So...you're probably right :P

When I die I want my body to be donated to science

But more specifically a scientist dedicated to bringing dead people back to life

@AndrasDeak What light is that?

Is there statistics and trend of which languages are influencing Python the most?

I am surprised to hear Perl

statistics of all the peps?

@FaheemMitha the concept of the language that reads almost like English to solve common problems, I guess

@AndrasDeak People who think of Python as "executable pseudocode" should look at its C API. It's a carefully crafted illusion.

@FaheemMitha that's not a contradiction. The developers of CPython work hard so that users can use python.

someone will have to turn elegant/concise code into something the machine understands, the question is whether you have to do that work yourself

@AndrasDeak I didn't say it was a contradiction. I said it was an illusion.

The trouble with reality is that eventually it bites.

Just to be clear, I don't dislike Python. It's been my main language for many years.

The bottom line is that trying to ignore what is going on underneath is full of trade-offs.

Which is why some people prefer languages like C. Not that I do.

@AndrasDeak Anyway, I hope you are doing ok. Hungary, right? I hope this time I got it right.

Maybe one day I'll get to go outside without wearing a mask. Looking forward to it.

@FaheemMitha what does python being "a carefully crafted illusion" mean?

@FaheemMitha you are wrong again ... :)

@Tim It looks all nice and shiny on the surface. But under the hood there be dragons.

@Tim Bummer.

is dragon good?

@Tim It depends. Dragons can make life interesting. But they might also decide to eat you.

Breaking news: Kamala is Biden's VP

unexciting

@Tim Half Indian on her mother's side. Not that it matters.

@Tim ?

Congratulations to Indians

Could be a lot worse. Take a look at the biographies and views of Republican senators sometime. E.g. the current Secretary of State.

@Tim Why?

She is a proud daughter of India.

I assume he is trying for the progressive and minority vote, but I'm not really following the election.

@Tim She is?

Kamala is not progressive

Her records are not

I miss bernie

@Tim Progressive is relative. I didn't say she was. I said he was trying to get the progressive vote. Did you have something specific in mind? I'm not familiar with her record.

Let her tell you: twitter.com/krystalball/status/1293281978398121984

@Tim Were you referring to youtube.com/… ?

@Tim I was looking at the Wikipedia page, which is clearly misleading.

I just did a search in Counterpunch, which is usually reliable about such things.

E.g. counterpunch.org/2019/09/06/…

I suppose it was unlikely Obama's VP was going to appoint anyone but an "establishment" person.

To be fair, her records as a senator are more progressive than hers as a state AG.

Oh dear. She's a member of the Council on Foreign Relations.

That's not good.

@Tim She sounds like a terrible AG.

CFR is one of those scary free enterprise operations.

Biden's VP selection had been an unnecessary suspense.

@Tim Was it suspenseful?

@FaheemMitha not sure I agree with that. If the point of the language is to be high-level for the user of the language there's nothing illusionary about it. I mean it's as much an illusion as anything else you do with your computer. It's abstractions all the way down.

@FaheemMitha yeah, you got it right, don't believe Tim

everything's fine (which is to say we're at baseline levels of insanity), thanks for asking