TimescaleDB SQL in Grafana

Grafana supports SQL through MySQL/MariaDB, PostgreSQL & SQL Server. Additionally Grafana supports the PostgreSQL extension TimescaleDB, this database is the best fit of all the SQL databases for Grafana since it is built specifically for large-scale time-series datasets. ...

January 15, 2020 · 1 min · Joe Heaton

SFTP instead of SCP

SCP suffered from weak input validation for decades until CVE-2019-6111 , the maintainers recommended using SFTP until patched versions can be deployed. I, like many others, were reminded SFTP existed! ...

April 23, 2019 · 1 min · Joe Heaton

Git feature branch & merge

Start with your master branch git checkout master git fetch origin If your local master has been modified, you can reset its state. git reset --hard origin/master Checkout a new feature branch. git checkout -b my-feature Make changes in this branch, committing as usual. git add file.txt git commit -m "add my file.txt" You can push your branch to allow others and yourself to evaluate and commit further to it....

April 9, 2019 · 1 min · Joe Heaton

tmux

I find myself working on the move a lot more recently and I often have to deal with poor terminal emulators, iffy connectivity and sometimes I need resume my work on another machine entirely. As such I am trying out tmux as a way of persisting my working environment between sessions, supporting multiple tabs for when my emulator lacks it (Looking at you PuTTY, Git Bash) and lastly allowing me to resume my work on another desktop. ...

April 3, 2019 · 2 min · Joe Heaton

Log monitoring with Elasticsearch - Basic overview

Log monitoring implies using technology to avoid reading every single log message, with the benefit of catching more interesting events than if you were to read every single line! ...

October 8, 2018 · 5 min · Joe Heaton

My terminal login message

Following on from bashrc , here is a snapshot and explaination of my .motd ...

July 27, 2018 · 5 min · Joe Heaton

My bash profile

Here’s a snapshot of my .bashrc, I put this together to normalise my environment; which is particularly useful when working across CentOS/RHEL 6/7, SLES11/12 & Debian/Ubuntu. I’ll overexplain some lines and underexplain others, depending on how interesting they are. ...

July 25, 2018 · 9 min · Joe Heaton

Enjoying GNOME3

Nearly every mildly experienced GNU-like OS user has had to content with the problem of which graphical environment to install, why?, because it’s how we use OS these days, with point and click. People are often perplexed by the choice even existing as the dominent OS of the day hardly allow you to modify your environment at all let-alone replace it all together with another groups systems.

August 4, 2013 · 9 min · Joe Heaton

Free Software Conundrums

Clients Pidgin or XChat (IRC) These days the users of XChat seem to be migrating to a maintained fork and perhaps MSWindows-centric project named HexChat, a project spawned after development on XChat slowed to a single developer and affectively ended in 2010. Either of these clients is better than the proprietary mIRC client which is free as in free beer and may be refered to as ‘Freeware’ by some, a term which should be no means be mistaken as standing for Freedom for the user....

June 29, 2013 · 3 min · Joe Heaton

Firefox-based browser add-on suggestions

HTTPS Everywhere [GPLv3+] Enforces the use of secure connections where known to be possible through the use of an updated white-list, this means where a website has the ability to deliver it’s bits to you over HTTPS(Secure HTTP) the add-on will tell it to. Browsing over a secure connection is intended to prevent third-parties, parties other than you and the server itself, from being capable of peaking into the connection and spying or tampering with the data....

June 1, 2013 · 2 min · Joe Heaton