ads' corner

PGSQL Phriday #0014 - PostgreSQL Events

Pavlo Golub is hosting this month’s PGSQL Phriday. The topic is “PostgreSQL Events”.

New Blog

New blog. Or, more exactly, new blog software.

I moved this blog from Serendipity to Hugo.

Enable Deep Sleep mode on Tuxedo Computers Pulse 15 Gen2

A while ago we bought new Pulse 15 laptops from Tuxedo Computers.

Installed Ubuntu on them, and for a while the sleep mode was nagging me, it does not really work. Today I found time to investigate this issue.

Obsidian: Paste URL into selection

I have a few community plugins enabled in my Obsidian. One of them is “Paste URL into selection” - and it fits very well into the Markdown workflow. Also what you might know from other tools like Slack.

Show me recent notes in my Obsidian Work Vault

In the previous Obsidian blog posting about managing tasks I showed a note which lists all open tasks in my Work vault. This gives me quick access to all open tasks.

In the same way I use another note quite often which shows me recently added and changed files in my Work vault.

Show me all open Work tasks in Obsidian

My Obsidian vault is “all-in-one”, personally I don’t like switching between multiple vaults for work and private stuff, and I organize it in a way to keep things separated in one vault. Multiple templates I’m using automatically generate Tasks in my vault, therefore I need a convenient way to see open work tasks. This blog posting describes the approach I’m using.

Daily Notes in Obsidian

Obsidian is a note-taking software and knowledge base software, where the notes/files are written in Markdown. For quite a while I’m using it in my daily work.

One of the cool features it has is named “Daily Notes”. As the name implies, there is a new note generated for every day. For me, this is used for writing down notes which do not deserve their own note. But also this is rather heavily used to share all kind of content from my mobile devides into the daily note in the first place. Content doesn’t have to stay there, in fact most of it is either handled one way or another, or is moved to a different place. But it is a very nice collection point in the first place.

KeepingYouAwake on Mac OS X

On my Mac, one of the annoying “features” is when the Mac screensaver comes on, the device eventually goes to sleep, and it disconnects the network. Which in turn timeouts services like Slack or Google, because these services keep a network connection open at all times. When waking up the device, I often have to login again into all the services, even though the device is just sitting in my working room on the desk all day and night. Very annoying.

I suppose it’s one of these things where Apple thinks they know better how users want their device to behave.

Extract better GPS coordinates from images using exiftool

Sometimes I have to extract Exif information from images, mostly the GPS coordinates. The coordinates coming raw from the images are not very helpful. Let’s look at a picture I took today:

Watch for changed files in SyncThing

For syncing files between my devices I’m using SyncThing. This tool is reliable, available on Linux, Android, Mac and iOS.¬†And it encrypts the communication.

But sometimes I want to know when files in certain directories have changed - as example in my Obsidian vault. This allows me to post-process the files.