REGEX PostgreSQL Replace

​Working with MARC format, remove pipes and letters.Before;|aShakespeare, William,|d1564-1616.Regex;REGEXP_REPLACE(|aShakespeare, William,|d1564-1616.,'\|.',' ','g')After;Shakespeare, William, 1564-1616.
Rate this blog entry:
Continue reading
28 Hits
0 Comments

Ubuntu Remotely Connect to MySQL Database

In order to remotely access a MySQL database in Ubuntu it's necessary to edit the following file; /etc/mysql/my.cnf Find the following line; bind-address = 127.0.0.1 Comment it out, and change it to the following; #bind-address = 127.0.0.1 bind-address = 0.0.0.0 You then need to restart the MySQL service using the...
Rate this blog entry:
Continue reading
39 Hits
0 Comments

Ubuntu 14 Install and Configure SSH

Ensure the OS is up to date.Install OpenSSH server on the OS.It's also a good idea to make a copy of the default SSH configuration, so that if you ever mess up your SSH settings you can revert to the original.That's all you need in order to get SSH working. You should now be able to use a program like Putty in order to connect to the remote OS...
Rate this blog entry:
Continue reading
187 Hits
0 Comments

Chrome “disable developer mode extensions” pop up

This is how to get rid of that popup appearing every time you create your own local extension in Chrome.Create a .bat file and name it `DevWarningPatch.bat`. Save this to the desktop.Add the contents below to the bat file.Make sure to close Chrome and end all chrome.exe processes. Rightclick the batch file and run it as administrator: it will find ...
Rate this blog entry:
Continue reading
13388 Hits
0 Comments

Laravel and XAMPP

Instructions on how to get up and running with Laravel on an XAMPP environment.Assuming XAMPP has already been installed, the steps involved are;​download composer from here and install it https://getcomposer.org/download/create a folder in htdocs named 'laravel'open a command prompt and cd to this newly created directory cd c:\xampp\htdo...
Rate this blog entry:
Continue reading
1479 Hits
0 Comments

Omeka Install & Setup LAMP

Having worked with Omeka the past few days I'll explain how to set it up on a LAMP stack. Firstly, what is Omeka? Well, taken from their website;Omeka.net is web-publishing platform that allows anyone with an account to create or collaborate on a website to display collections and build digital exhibitions. No technical skills or special server req...
Rate this blog entry:
Continue reading
1276 Hits
0 Comments