Skip to content
I recently had to write a lot of SQL code and thought it would be very neat to have some vim shortcuts to execute the current line or the current command. I want to share this with everyone as the second command needed some try-and-error on my part.
Adding the following to ~/.vimrc
map <F2> :.w !psql<CR> map <F3> :.,/;/w !psql<CR> map <F4> :w !psql<CR> will enable you to execute the current line in psql with F2.
Introduction I am a HUGE fan of matrix. It allows me to organize my chats in a sensible way, it works with multiple identities and completly anonymous if I want it to. Spaces made Matrix my favourite messenger by far. Yet, there is one feature I have been missing: Disappearing messages!
Regarding the security and usability, only Signal is comparable to matrix. But: Signal offers the possibilty to define disappearing messages for groups and direct messages ranging from 30 seconds to 4 weeks.
Integration Following the quickstart documentation I tried to add cactus comments to this blog. I currently rely on infrastructure by cactus.chat as I do not host a private synapse server.
I currently implemented this as a shortcode with hard-coded site title and a variable room name.
Quickstart with HUGO Register your site There is a registration system, that ensures that you are moderater in your comment section(s). I order to register your site you have to send a message to @cactusbot:cactus.
I recently installed an Owncast server and wanted to share my experience. Here it is:
What is owncast? Owncast is a streaming server that you can selfhost, a Twicht in a box as the developers call it. You host owncast on your server (a small VM with good downlink is enough) and can stream your own own content like you would do on Twicht, YouTube etc…
It has a chat, a admin panel for customization and thats it!
I had some IoT devices that I wanted to integrate in my monitoring. For this I set up a MQTT broker as the MQTT protocol is a simple solution to send data from IoT devices to a server. This tutorial is focusing on setting up the server, but I also introduce a Python based MQTT client to test our installation.
On your server, first install mosquitto, our MQTT server/broker.
sudo apt-get install mosquitto Allow standard mqtt port in firewall (if you have ufw installed)