Posted in 2024
Public PostgreSQL?
- 2024-04-23
I want a tool that can easily ingest arbitrary data that I can use for personal data science.
At first I was thinking of running Postgres publicly - of course with TLS enabled and strict access control.
Caddy Compression and Caching
- 2024-04-21
This blog is built with Sphinx and served by Caddy.
Unfortunately https://pagespeed.web.dev/ says that https://blag.felixhummel.de/ is slow on mobile. Let’s do something about that.
TIL: Pycharm: Remember Database Query Results
- 2024-04-19
As the docs state:
By default, PyCharm updates the same tab with results each time you run a new query after the previous one. You can change this behavior and create a tab each time you run a new query.
TIL: KeepassXC never ask
- 2024-04-19
The KeepassXC-Browser extension asks if a domain is allowed to access credentials. I want to skip this dialog, as I always save passwords with a concrete domain. Here’s how (via):
Tools > Settings > Browser Integration > Advanced tab
KeepassXC Keeshare
- 2024-04-18
https://keepassxc.org/docs/KeePassXC_UserGuide#_database_sharing_with_keeshare
Suppose you have a database called meins and want to synchronize the gaming database.
LVM Snapshot Create / Merge / Rollback
- 2024-04-01
Example use-case: Snapshot Gitlab VM disk before running an upgrade.
Check volume groups and logical volumes:
Git Sign Commits With SSH
- 2024-03-30
https://docs.gitlab.com/ee/user/project/repository/signed_commits/ssh.html
First, make sure that your pubkey is present in Gitlab.
TIL: inxi system information
- 2024-02-22
I was looking through the packages supplied by the Tuxedo apt repo:
That’s when I came across inxi.
TIL: Gitlab CI: The needs Keyword
- 2024-02-07
Gitlab CI has the needs keyword since 2021. It allows building stageless pipelines, but has many uses.
Sometimes we run different test suites in parallel (e.g. unit-tests and integration tests), but want aggregated coverage results. This results in a pipeline like this:
TIL: Pycharm Open All Modified Files
- 2024-01-26
Pycharm can open all modified files in new tabs.
Open the “Commit” tool window (Alt+0) and hit F4 on “Changes”:
TIL: Dockerfile Heredocs
- 2024-01-24
I did not even know that Docker has support for heredocs until today.
Then I read the official blog post from 2021. In my defense: Using this depends on buildkit, which only became default in Docker Engine v23 released in 2023.