Getting Started With Windows Subsystem for Linux

Steven NgDaily Debug BlogLeave a Comment

The Problem My Windows text editor was choking while prettifying a complicated XML file, and I wanted to be able to use XMLint without having to set up a Linux VM. One of the cooler features of Windows 10 is the Windows Subsystem for Linux, or WSL for short. WSL basically lets you have a full, real Linux installation running … Read More

Use a Time Series to Quickly Generate A Date Dimension in Postgresql

Steven NgDaily Debug BlogLeave a Comment

generate_series A neat feature in Postgresql is the generate_series function. generate_series is classified as a “Set Returning Function”, which in plain English means that it returns a bunch of rows. How it works is very similar to a for..next loop. You basically set up a start and stop point, and optionally add a step interval. The syntax for generate_series is … Read More

Quick Hit: PostgreSQL performance on Raspberry Pi

Steven NgDaily Debug BlogLeave a Comment

I’m sure they’re answering a question that almost nobody is asking, but Rustproof Labs did some benchmarks of Postgresql running on Raspberry Pi. I don’t think I’d recommend that anyone run a relational database on a Pi, especially using SD as storage. But having said that, a lot of businesses with modest reporting needs could actually use a Pi as … Read More