A bunch of blog posts of technologies I find interesting and (non-client) projects we are working on.
As a freelance .NET developer, I often need to host personal or client preview projects without paying enterprise-level cloud costs. Not all cloud providers support .NET or setup to host a cheap front-end, so I decided to set up my own VPS Linux host environment.
Amsterdam is a city that has existed for over 750 years. Throughout its history, people have made a significant number of paintings, photos and sketches. Many of them have been digitized and stored in the Beeldbank Amsterdam.
Previously, we set up a local Postgres development environment with Docker. We also set up a couple of client tools to connect to it and we also ran some SQL to make sure everything was set up correctly.
Importing large datasets into a PostgreSQL database is a common task for developers and data engineers. In this two-part post, we’ll walk through one of the many approaches to import data into PostgreSQL. We’ll be using a local setup using Docker and client tools and import one of the IMDB Non-Commercial data downloads.
Since the day I got a Macbook about 10 years ago, I tried to use Xcode a couple of times. For some reason, the IDE gives me a lot of headaches. Perhaps it’s the keybindings I would have to get used to, the Home button not going to the start of the line, the weird tabs at the left for navigation, use the mouse for everything or just the whole package.
My experience with Python is quite limited - about 100 years ago I used quite a lot of Python to build software in an integration department. After setting up the environment for Python3, my Mac should be able to run a Python script. A lot of people who want to pick up Python are writing a script to rip a webpage, so that’s exactly what I am doing here.