Tools

Git is a powerful tool for version control and managing changes in code. One of my main issue on using it on real projects, are config files. I couldn’t just add them to the .gitinore-file, because I needed them to be there, but I didn’t want them to accidentally be included in any commits and screw up the working copies. While looking for a fix to this issue, I stumbled upon an option to tell git to ignore changes on specific files: git update index --skip-worktree <file1> <file2>. ...

I’ve been moving this site to hugo quite a while ago, but only recently stumbled across the idea to create a workflow on GitHub Actions to build a hugo site straight after each push. Contrary to many other articles however, I didn’t have the option to publish the page to GitHub Pages or similar, simply because the project still is under heavy construction. So, I had the following requirements: Start workflow after each push, but also enable manual triggering for testing purposes Build the site, considering it requires additional dependencies due to relying on Googles Docsy-Theme Bonus: Use a tool to verify the integrity of all the internal links and images to verify correct paths Let’s keep it simple: I started with a regular setup of the repo on an up-to-date Ubuntu container: ...

Sometimes it can be helpful to test your apps not only on a local machine, but also using other devices within or outside, your network. In my current example, I use an ASP.NET Core web application that contains an API that I can in turn access via an Android app. I debug the Android app on a physical device that is on the same network as the ASP.NET Core application. ...

If you are reading this, chances are you already use a password manager. I have been doing that for several years now. But I have to admit that my password manager has only run on my phone so far and I have always transferred passwords that I use on my PC by hand. Probably out of sheer laziness. Today, I use this blog post to finally synchronise my password database between any number of devices - and to show you how to do it. The whole thing not only makes dealing with passwords more convenient, but naturally also reduces the inhibition threshold to actually use the applications. This in turn improves the overall security of your accounts. ...

Today I would like to briefly introduce you to a Web application, which I have been stumpled across. I’ve tried several tools for db modeling, some more and some less appealing. Well, the tool doesn’t offer explicit ER modeling, but a SQL-like structure and allows you to import and export directly to SQL and other formats. You can find the app I’m talking about on dbdiagram.io. The website offers a simple graphical interface, which includes a code editor and a graphical representation of the table structure. You can edit your table structure directly in the code editor. You can then create relations between the tables using the drag-and-drop function. These are represented in the editor by the schema ref “table_a”. “column_a” > “table_b”. “column_b”. Cardinalities are represented by > (n:1) , < (1:n) and - (1:1). ...