Tue 02 April 2024
Back when I was in university, I had a teacher in database systems who also did
contract work as a database administrator. He told me that 90% of his work was
to just add and reorganize indexes to speed up queries. That was almost 10 years
ago, and I'm now …
Read more...
Sun 24 March 2024
One thing that didn't carry over from my i3 setup when moving over to
Sway (i.e. Wayland) was the touchpad
configuration. Input devices was a display server concern under X.Org, so the
window manager had nothing to do with it. Notably, now click-on-tap is not
working for me …
Read more...
Mon 11 March 2024
Thu 29 February 2024
I've been using some variation of Vim for going on a decade now, yet I've never
bothered with an efficient way of commenting out code. It just isn't something
that I do very often. But I saw a colleague comment out and uncomment lines of
code like a breeze in …
Read more...
Sat 24 February 2024
I've been using psql
for many years to interface with PostgreSQL databases.
It's simple, pretty much always available as it's usually bundled with
PostgreSQL and just does what it's supposed to. It does, however, have some
pretty dangerous defaults. Not only are writes allowed, but it also
automatically commits any …
Read more...