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.
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.
I'm For Hire
When your agency is overrun with work and you need someone to complete that backlog of projects, I'm available as a front-end web developer and designer, an extra pair of hands.
Get in touch.
Inventory Database for SO Fine Art Editions
In 2013 I built an inventory database for So Fine Arts. in Dublin.
The Requirements
- 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.
Layout for consignment docket and managemant of consinments to the gallery.
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.
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.
WordPress Database Integrations
The WordPress REST API provides many ways to access the data held in the database and many plugin authors provide their solutions also
For less complex data collection, ODBC drivers can be configured in FileMaker Pro to access data stored in the WordPress tables by custom post type fields. Queries can be run in MySQLWorkbench to return the data in a presentable format as intermediary views. These views are saved to the database so that FileMaker can use them.
Data Buzz Integrations
Data Buzz produces a solution for FileMaker Pro to access orders placed online through WooCommerce installed on a WordPress site.
