Jul 19

Compiling and installing MariaDB on Raspberry PI

For reports on my timeseries data I really needed Windowing functions like LAG(), LEAD(), ROW_NUMBER() etc. The speed and flexibility you gain using Windowing functions is incredible compared to imitating LAG() using “self-join” tricks. But these function are supported as of MySQL 8 and as of MariaDB 10.2.

For numerous of reasons I prefer to use MariaDB which is compatible drop-in replacement for MySQL.

Unfortunately there are no ready to install packages for ARM so you need to compile and install newer versions by hand.

I’ve came across many articles regarding compilation of MariaDB but these did not match my installation and were missing some important steps. So decided to share my solutions.

So let’s start!

Continue reading

Dec 30

Running Linux on Windows 10

INTRODUCTION

Often developers and related OPs need to test stuff on Linux (web, cli, .NET Core etc.). The typical approach was to spin up a Virtual machine (VM), install and configure a Linux distro and play with it.

Main Cons include: you need a hyper-visor software, enough RAM, fast hard drive, to fight with basic operations like cope-paste text and files between machines etc.

Well, good news! As of the Anniversary Update Windows 10 supports the so called “Windows Subsystem for Linux” (WSL). It allows you to run natively* most of the non GUI Linux stuff**on Windows without the overhead of a virtual machine.

Continue reading

Aug 18

PowerShell вече е с отворен код и работи под Линукс!

Добри новини за любителите на PowerShell! Вече можем да използваме любимия shell под Linux и Mac 🙂

PowerShell is open sourced and is available on Linux

Не пропускайте и видеото с Бащата на PowerShell – Jeffrey Snover

Ето и кадри от събитието 🙂

Great day!