Databases

Extracting data from the backend database that stores all the content of your site is a very powerful feature to exploit. You can run calculations on this data and push it back to the front end of your site for visitors to see.

SQL Workbench
php coding

FileMaker Pro

I work with FileMaker Pro, the desktop and mobile solution for quickly creating and deploying database Apps. These can be configured to access data from your WordPress website. 

 
Filemaker pro contacts DB

Inventory Database for SO Fine Art Editions

In 2013 I built an inventory database for So Fine Arts. in Dublin.

The Requirements

Here goes your text … Select any part of your text to access the formatting toolbar.

  • Record all consignments of work from artists (sale or return) with the appropriate documentation for this, printed or emailed to the artist
  • Record sales of work and issue either a sales receipt or an invoice.
  • Facilitate the payment for work purchased in instalments.
  • Calculate the VAT charged on the sales of work
  • Generate payments to artists for work sold reflecting the VAT and galley commission deducted. Documentation for this, printed or emailed.
  • Include non deductibles in payments to artists such as framing costs and bronze casting fees, not subject to gallery commission.
  • Record the return of unsold work to artists. Documentation for this, printed or emailed.
  • Generate sales reports and calculate VAT to be paid to Revenue.
  • Generate Credit Notes and log amounts in a Credit Control account for each customer where credit applies.
  • Generate return items where work is returned. Re-stocked works of art reflected in the stock table.
  • Issue gift vouchers and register them as sales.
Main Menu & Client/Artist Contact List.
Main Menu & Client/Artist Contact List.
Main Menu & Client/Artist Contact List.
Layout for consignment docket and managemant of consinments to the gallery.
Main Menu & Client/Artist Contact List.
Sales receipt and records of customer’s sales.

Web App Using PHP/HTML/CSS/JS With mySQL Database

As part of the Higher Diploma in computer science that I completed in 2014 at Carlow Institute of Technology I built an inventory system that was stored in a mySQL database, served through PHP server scripts to, presentation on screen with a web browser. This app required that users, logging in with secure passwords, would be locked out after three failed attempts.

Backend PHP and JavaScript files.
Backend PHP and JavaScript files.
I used a minimum wire-frame design for the web interface.
I used a minimum wire-frame design for the web interface.
Additionally a FileMaker Pro file was created and configured with an ODBC driver. This permitted a desktop user to connect to mySQL on a remote server, an alternative way to access the inventory database.
Additionally a FileMaker Pro file was created and configured with an ODBC driver. This permitted a desktop user to connect to mySQL on a remote server, an alternative way to access the inventory database.
DevelopmentWeb DesignCMS & Layout