Qlik Deployment Frameworks – using common approaches, naming conventions and paths across developers

Any environment with more than on developer will quickly lose consistency of attributes across the environment. Agreeing standards as part of developer onboarding, and validating these before app acceptance is very important.

An example set of naming conventions is discussed below. This assumes a common directory structure similar to a Qlik Deployment Framework (QDF) model.

The QDF helps to organise application components
The QDF helps to organise application components

The example below follows a concept of one common container (for data and files which aren’t app specific), and a hierarchy of product (one or more applications developed for a specific purpose) followed by customer (a standalone version of those applications, loaded with different data).

The resulting directory structure is therefore Root > Product > Customer.

Continue reading “Qlik Deployment Frameworks – using common approaches, naming conventions and paths across developers”

3arcade PHP game script updated to version 2.1 to work with PHP 5.6

I have an installation of the 3arcade script that’s still in the wild, and decided it was time to update it to work with PHP 5.6 (at least).

These changes fix:
– a row 0 error in play.php linked to deprecated functions
– deprecation of the ereg_replace function through use of intval
– deprecation of the mysql_connect function (and future deprecation of mysql* functions) through use of PDO
– consistency of database connection and query errors with a variable in the config file

Changes live at https://github.com/withdave/3arcade

Linux Permissions with chmod on files and directories

Linux file permissions can be applied to files and directories, and using ls -l we can quickly get an overview of file properties.

-rw-r--r-- 1 root root   236 Aug  1  2017 install.log

The example shows (from left to right):
1) - Whether the file is a file or directory (- for file, l for link or d for directory, in this case it is a file therefore -)
2) rw-r--r-- Permissions (represented here as a set of three triplets, see below)
3) 1 Number of links or directories inside this directory (1 if a file)
4) root root Owners (user = root, group = root)
5) 236 File size
6) Aug 1 2017 Last modified date
7) install.log File name

Continue reading “Linux Permissions with chmod on files and directories”

Upgrading PHP to 5.6.x or later on CentOS7 via Yum and the IUS repo

CentOS7 (and some of the other RHEL flavours) currently don’t include PHP 5.6+ in the core repos, and yet the versions of PHP bundled are at EOL or close to it.

A number of guides suggest using the webstatic or remi repos – but this is not recommended as they contain packages with names that conflict with packages in core repos.

One of the better options is to use the IUS repo (Inline with Upstream Stable project), which means you can quickly and easily update.

Continue reading “Upgrading PHP to 5.6.x or later on CentOS7 via Yum and the IUS repo”

After creating a new user in MariaDB / MySQL, flush permissions and MYSQL_SECURE_INSTALLATION

After installing LAMP on new servers (similar to as described here for CentOS), I’ve recently had two errors after the creation of MySQL users.

These user accounts required additional steps after creation – flushing permissions, and re-running the MySQL secure installation.

Continue reading “After creating a new user in MariaDB / MySQL, flush permissions and MYSQL_SECURE_INSTALLATION”

SEATT updated to 1.5.0

Simple Event Attendance has been updated to 1.5.0.

Update to fulfill some of the requests posted at https://withdave.com/2017/05/seatt-feature-request-may-2017-update/, as well as some other fixes:

  • Updates to structure of comments in source files to improve readability
  • Addition of list format to make displaying multiple events easier
  • Change to remaining time display in the admin panel (from hours to a formatted time)
  • Removed use of extract function from add_shortcode (seatt-list and seatt-form) as per best practice
  • Added ability to use shortcode to control public visibility of comments
  • Updated screenshots for plugin

Plugin is live on wordpress.org.