Iain's IT Solutions Ltd.

Iain's IT Solutions Ltd Mobile Nav Menu

Freelance Software
Developer

Specialist in developing back office and process management systems

Tea cup

Latest News

February
2017

Did some testing of Google Cloud Platform - Cloud Spanner.  I was able to create and host a MySQL database on their server.  Perhaps on my next web database project I'll host the database with them.


January
2017

Did some testing of HTML5 Local Storage.  It persists nicely if you close the tab, the browser and restart the PC.  It's cleared if you clear browser history and cookies.  Could be useful for a new project where storing data while offline is required - without the need for PDAs or a mobile app.

Connecting a C#/Visual Studio/Windows Forms application to a local MySQL database.

Set up a VPS using Webmin, added a domain and after a lot trial and error, got it working.  Also set up SFTP to upload files to the new domain.  Until now, I've only used cPanel.  This seems to be the level above - good learning experience.

Adding throttling to a PHP email sending mechanism.  Emails are sent from a private members website to all signed up members.  Due to sending frequency limits imposed by the web host, we couldn't send to all members in one go, so a cron was used to send emails to subsets of members at timed intervals.

Redesign/rebrand of my online invoicing system icq32.co.uk.  Responsive/mobile friendly layout with a nice slide-down menu when viewed on a mobile.


November
2016

Upgrading my website content management system - making it responsive/mobile friendly


October
2016

Working on an Excel application with lots of quite complicated VBA coding. It's using Excel as a database, which has its advantages and disadvantages...


September
2016

Moving a number of websites from one hosting company to another.  Along with the site files, databases and content, locally hosted emails were also moved.

Adding a range of new features to a web-based back office invoicing system.


August
2016

Working on a web-based multiple choice quiz.  Mainly written in JavaScript.  Stats gathered on time taken for each question and users can give feedback on why they got answers right or wrong.

Added a feedback feature to my online invoicing system icq32.co.uk. From any page on the site, users can click a button, type in problems or indeed compliments about that page and send it to me.

It should help promote continuous improvement of the system through user feedback. 

Went live with a clean, simple responsive website furwood.co.uk


July
2016

Building a data backing up tool to back up a large number of large documents on a website.  The process brings together PHP, Cron jobs and a C# desktop application.


June
2016

Learning about systems and processes needed by companies attaining ISO accreditation. 

Working on a range of updates to a php, Web based, mobile friendly CRM system.

Working on creating png images dynamically with php.  What's interesting is that the src of an img tag can be a php file.

Working on a range of updates to an online invoicing and process management system for a builders company.  The system has helped them achieve ISO 9001 accreditation.


News Archive
Web Desktop Other
HTML C# RegEx
CSS VB.Net SWIFT
PHP SQL Server Web Apps
MySQL VBA Desktop Apps
JavaScript Excel Databases
JQuery Access
ASP Word