I am using PostgreSQL from a Kotlin (JVM) application with the pgJDBC driver. According to the documentation, you can get results from a query based on a cursor to avoid loading the whole result set into the application’s memory at once by calling the setFetchSize() method with a positive value on the Statement before issuing the query. I had a non-trivial query which generated a lot of rows (several thousands), and I only needed the first hundred or so.

You can do quite a lot with Docker, but sometimes you want greater capabilities or increased security, then a proper virtual machine with KVM is a good alternative. An example is when you want to run Docker containers in the VM, it’s not easy to nest Docker without forgoing all security. Just like Alpine Linux is suitable as a base for Docker images, it is also a good option as a guest in a virtual machine.

As I have explained earlier, I am using Leafpad instead of gedit in my Ubuntu system. However, recent versions of Ubuntu does not have Leafpad available through APT any longer, you have to install it with Snap instead. This is quite annoying, since the Snap packaging of Leafpad is too restrictive, it cannot access hidden files in your home directory, nor anything in ~/bin/. This is not good, since I often want to use Leafpad to edit such files.