rclone Systemd startup mount script

rclone Rclone is a command line utility used for reading and writing to almost any type of cloud or remote storage. From Google Drive to Ceph, rclone supports almost any cloud-based remote storage platform you can think of. You can perform upload, download or synchronisation operations between local storage and remote cloud storage, or between remote storage

gitignore file for Go Projects

This is a gitignore file for a Go project to ensure temporary files and build files are not added to git repository commits. [crayon-5bbdc2270ee85958079321/]

List of Bank Holidays For England in SQL Format

First off, create a table to store the bank holiday values. You may need to adjust this slightly depending on your SQL server technology being used (this was tested on MySQL Server).  [crayon-5bb4e0b3b1755979540269/] Insert the bank holiday values below. This table is currently for 2012 up to 2019 for England and Wales.  [crayon-5bb4e0b3b175d512369946/] For a

MySQL/ MariaDB Error Code: 1329. No data – zero rows fetched, selected, or processed

The above error can occur when calling a cursor results in no rows, or no more rows if called in a loop. Whilst the error message is descriptive about what has happened physically, you may wish to catch the error so that you can do something else, or simply replace the generic database error with

How to exit from a MySQL/ MariaDB Stored Procedure/ Function Prematurely

MySQL and MariaDB enable you to define your own error conditions and to report back to the SQL client both a return code and an error message. As soon as you raise the condition then MySQL/ MariaDB will halt any further execution of the code and report the error back to the client. This can

CockroachDB systemd script

This is a simple systemd script for CockroachDB. It works for single node installations or multiple nodes, however you’ll need to manually join each node to the cluster before using the systemd script. Create the systemd file and add the following content: [crayon-5bb2054895a8d904003843/] [crayon-5bb2054895a94089396086/] If your host belongs to a cluster create a hosts file

gitignore file for Eclipse Projects

This is an example of a .gitignore file for an Eclipse project to ensure temporary files, build files and project settings are not added to repository commits. [crayon-5bae3d499e098261603457/]

How to change the listening port for PostgreSQL Database

The default TCP port for PostgreSQL is usually 5432, however this can easily be changed in the postgresql.conf configuration file, which is the main configuration file for the database server. In addition to a TCP listening port, PostgreSQL will also a local socket if the server is running in a Linux/ Unix environment. A local socket is

gitignore file for Nodejs Projects

An example gitignore file for Nodejs projects to ensure that local environment variables, build related output and modules are not committed to the git repository. [crayon-5bad139c32c17821581453/]

gitignore file for Netbeans Projects

A gitignore file for most Netbeans projects to keep the build and local configuration files out of your git repository. [crayon-5bad139c338b6810432445/]