### How to learn IDE Shortcuts with Key Promotor X

Motivation The DRY (Don’t repeat yourself) principle does not only apply to code but to mouse clicks as well: When you are repeatedly clicking buttons you might want to figure out some keyboard shortcuts. In Jetbrains IDEs like PyCharm you can use the plugin Key Promotor X to learn these shortcuts. Installation Open the File…

### Advent of Code 2022 Day 3

Challenge – Part 1 https://adventofcode.com/2022/day/3 Problem vJrwpWtwJgWrhcsFMMfFFhFp jqHRNqRjqzjGDLGLrsFMfFZSrLrFZsSL PmmdzqPrVvPwwTWBwg wMqvLMZHhHMvwLHjbvcjnnSBnvTQFn ttgJtRGJQctTZtZT CrZsJsPPZsGzwwsLwLmpwMDw The first rucksack contains the items vJrwpWtwJgWrhcsFMMfFFhFp, which means its first compartment contains the items vJrwpWtwJgWr, while the second compartment contains the items hcsFMMfFFhFp. The only item type that appears in both compartments is lowercase p. The second rucksack’s compartments contain jqHRNqRjqzjGDLGL and…

### Advent of Code 2022 Day 2

Challenge – Part 1 https://adventofcode.com/2022/day/2 Example For example, suppose you were given the following strategy guide: A Y B X C Z This strategy guide predicts and recommends the following: In the first round, your opponent will choose Rock (A), and you should choose Paper (Y). This ends in a win for you with a…

### Advent of Code 2022 Day 1 Part 2

After solving Part 1 of Day 1 I could unlock the second challenge. It’s a slight variation of the first. Find the top three Elves carrying the most Calories. How many Calories are those Elves carrying in total? calories = “””1000 2000 3000 4000 5000 6000 7000 8000 9000 10000″”” The test data stays the…

Motivation Advent of Code is an Advent calendar of small programming puzzles for a variety of skill sets and skill levels that can be solved in any programming language you like. As I already tried some of the puzzles last year I wanted to see how far I could get this year. Registration To be…

### Ten Rules for Agile Retrospectives

Motivation Agile retrospective are a great tool to increase the effectiveness and efficiency of your team. They also may improve the overall satisfaction of your co-workers when done properly. So here are some rules Ten rules for agile retros: #10 – A Retro always takes 90 minutes #9 – Time Boxing 5 min – Set…

### How to create youtube thumbnails – pillow tutorial

Motivation Inspired by automate the boring stuff and motivated by my last automation attempts, I wanted to see if there is more stuff which can be automated. Creating YouTube thumbnails is one of the time consuming tasks I tried to simplify. Installation Pillow is a fork of PIL the Python Imaging Library. We can install…

### How to deal with date and time in SQLite

Motivation When dealing with databases you will need the ability to store certain dates and/or timestamps in your tables. Let’s find out how you can do that in an SQLite database. SQL table creation SQLite has the data type TIMESTAMP for storing date-times CREATE TABLE social_media ( social_media_id INTEGER, insertion_date TIMESTAMP, yt_subs INTEGER fb_pg INTEGER…

### How to create WordPress articles via REST API

Motivation If you had less menial manual work you could sit at the beach and relax more often 🙂 So regarding my pain points I figured out that publishing articles to my blog takes a huge amount of time too. In order to publish an article I need to: Log in into the WordPress backend…

### How to use google translate with python

Motivation Sometimes you need to translate text from one language to another. I for example often write articles in German but want to have them in English for this blog. For this use case you can use google’s translation function in the browser. But wouldn’t it be sweet to automate this task and spare some…