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…

Interview with Christoph Menzel

Today we did an interview with Christoph Menzel Head of Mobile & Web Development at inovex. Hi Christoph! Thanks for taking the time. Can you tell us about yourself? How did you become a software engineer? That is a very good question 🙂 I started as an apprentice IT specialist for system integration. So I…

How to use Automator on macOS

Motivation Inspired by the session at BarCamp Regensburg I started to think about pain points in my workflow. I figured out that the conversion of my photos was too cumbersome. Before When writing articles I download the images from my phone via AirDrop to my Mac. Apple stores images in the HEIC format on my…

How to use defaultdict

Motivation When learning a specific language it is essential that you also learn the built-in functionality which gives you leverage. In Python there are often so called pythonic ways to solve problems like lambdas, filter function or enumerate. Tools that save you time when addressing real world problems. Use case Sometimes you want to do…

How to find the mouse pointer on macOS

Motivation Many software developers use a multi monitor setup with two or three screens at 24 inches or more. Some folks like videoeditors even use giant curved screens with more than 34 inches. Thus it sometimes can become painful to find your mouse pointer on such big screen estate. But macOS got you covered. Settings…