Skip to content
PostgreSQL Slonik logo

Export a PostgreSQL query to a CSV

G24th November 2017 

CNo comments

Export the contents of a database table to a CSV file using the psql PostgreSQL utility in PuTTY.

Read the full story

Transferring packages between different versions of R

G31st July 2017 

CNo comments

Use a couple of small scripts to easily “transfer” installed packages between different installations or versions of R.

Read the full story

An ImageJ batch processing macro that works

G15th March 2017 

CNo comments

A helpful generic ImageJ macro script that can be used to loop through files of type in a selected directory and then do something to them.

Read the full story

UNC path from local path in PowerShell

G23rd February 2017 

CNo comments

Use this simple PowerShell code to convert a local path into an UNC path.

Read the full story

Access Virtual Application files via the Q-drive

G22nd February 2017 

CNo comments

A simple technique to obtain access to the virtual environment (Q-drive) of an application in Microsoft Windows.

Read the full story

Update R from within the console

G14th February 2017 

CNo comments

A useful protocol for updating the R statistical package from within the R console window.

Read the full story

HTTPS for Free

G29th January 2017 

CNo comments

For those wishing to serve their website securely over HTTPS (Hypertext Transfer Protocol Secure) via SSL/TLS, there is now a free option for obtaining the necessary certificates.

Read the full story

Download all PDFs from a web page via PowerShell

G6th December 2016 

CNo comments

Use PowerShell to download every PDF from a web page and save them to a nominated folder.

Read the full story

Unzip .tar.gz files in Windows

G24th November 2016 

CNo comments

Use this one-liner in the command prompt to extract the contents of .tar.gz files on Microsoft Windows machines.

Read the full story

Enabling SSL and HTTPS on a WordPress site

G13th November 2016 

CNo comments

Step-by-step instructions for enabling your WordPress blog or website to be served over HTTPS using SSL or TLS.

Read the full story