Hi there 👋

In the past couple of weeks I’ve started to work with Microsoft SQL Server. I have a pretty good founation of SQL from high school, but I’ve only used PostgreSQL so far in my carreer. I collect the snippets I found to be the most useful ones that helped me getting started. ...

I have access to a Google Calendar, that contains the absence of all my colleagues as full day events. I work with a mostly remote team, and sometimes it’s useful to know when will my teammates leave for vacation, even if they don’t tell me many days in advance. I wrote a simple script, to look through the events every monday and filter the ones I’m interested in, then send me an email report. ...

In the past few days I’ve been working with a code where I needed to see whether the service successfully sends mails through SMTP. I did not want to use or set up an actual mail server locally. As is turns out Python has a oneliner to solve this situation. ...

Recently I tried Github actions to deploy some of my static sites, and I’ve been quite happy with its capabilities. Let me share my configs for different kinds of setups. ...

I started to run on a weekly basis in last August, I’m fascinated with the data I can collect from each run. I’ve been using Strava ever since. While I was preparing for my previous post about plotly-dash, I decided to dust off my knowledge by creating a simple app to visualize my heartrate data in different activities. ...

Last year I was working on some dash-plotly applications/dashboards. It was confusing at first, I learned a lot during that time, I’d like to share my gathered experience. The docs already contain useful information, I do not wish to repeat them. There are many example pages in github, my goal is to collect my most visited pages here, so it’ll be easier to start out with development. ...

My first memory with vim is in early 2010s, I was just learning git, and I messed up my repo badly, a colleague came to help, he told me seemingly random sequence of characters to type, and suddenly everything went back to normal. Git’s default editor was vim and I think we did an interactive rebase. We might have just fixed it in an other way, but still it felt powerful. Later on I saw vim books at the operators' desks, and I got really curious of what it is and how can it help my daily work. ...

A few years ago I switched between a few machines on a daily basis, and tweaked my environments constantly. It was a tedious task to update each of them one by one, every time I changed configs or aliases in any of them. I figured this has got to be easier somehow, and found the hidden world of dotfiles. ...

A few weeks ago I came across a post about recommended static site generators. I decided to reevaluate my previous choice for a blog engine. I’ve used Jekyll and Gatsby.js before, now I wanted something new. ...

In the past few days I’ve been working in manual mode on multiple linux boxes simultaneously. I have to follow logs, modify configurations and kill/start applications all at once. I got confused pretty fast of what server am I connected to in a certain console pane, and where are my operations. On top of that my ISP had a huge traffic hit these days, and my VPN connection dropped constantly. I dusted off my knowledge about some tools that boosted my productivity. ...

I usually work with *nix systems, and I process text all the time. This consists of CLI tool output, config file modifications and log files scanning. These utilities make it easy to search and manipulate plaintext data. I think they’re an essential part of any developer’s toolbox. ...

I’m currently following the trends with my dev setup. I use dark theme in almost all of my tools. That make my Mission Control a monochrome mess. Most of my tools have theming options, so a few months ago I decided to light things up. ...

Have you ever typed ctrl-c instead of ctrl-v and had to recopy again? Have you ever needed to copy and paste multiple entries at once from a page causing you to switch back and forth? Have you ever needed to copy the output of a program running in the terminal? I did, and got fed up with them almost 5 years ago, I’ll show you how you can eliminate these problems. ...

From time to time I come across a rant on Twitter, that regular expressions are confusing and hard in general. I think if you know the basic building blocks of it, you’ll see how useful they are, and you can unleash its power in your daily coding life. ...

I work with some projects that can be only used with specific versions of node/python and it’s not feasible to simply dockerize them. Every time I switch between these projects I’d need to reinstall different versions of node/python. That would be plain silly… BUT there’s a better way. ...

After experiencing the awesomeness of External Calls in Snowflake I decided to look into the possibilities of running external snippets from Postgres. ...

A few months ago at work, I wrote a simple node.js snippet to calculate route distances in Mapbox. Now I’m proud, that it’s used to demonstrate how to use Mapbox calculations from Snowflake. ...

Ever since I wrote about VSCode Reveal, I wanted to have a command-line interface to generate the same output. I loved that well-configured behavior and did not want to start from scratch. Finally, I had the time to do it. ...

Sometimes I work on similar projects that need so little customization I feel like I can just copy and paste it, and tweak some variables, then create a new repo for it, and start to generate the content. Here is where project templates come into play. ...

It’s the time of the year when many people start to countdown with their advent calendars. For coders, there is a special kind of calendar that keeps us busy and help us prepare for the celebration. ...