So I needed a quick way to convert a list of authors from “Joe A. Bloggs” into “Bloggs, Joe A.” – i.e, not separated out into firstname and lastname fields, just one field called ‘name’. I then needed another field to return a single column with the first letter of the lastname for display purposes. […]
https://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.png00Tom Kinghttps://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.pngTom King2014-04-24 11:41:402014-04-24 11:41:40My new favourite SQL function – SUBSTRING_INDEX
There comes a point in life when your current hosting environment needs to scale up, and quickly. It might just be that one of your clients gets very popular very quickly, or the gradual adding of sites and resources starts to make services fail. Thankfully there are a few tricks to make life a little […]
https://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.png00Tom Kinghttps://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.pngTom King2014-04-07 15:37:032014-04-07 15:37:03Scaling your hosting environment with free services
Just a head’s up: This recent Mura CMS issue is something which could possibly apply to a wheels app: http://www.trunkful.com/index.cfm/2014/1/29/Mura-CMS-Vulnerability I’m not referring to the file manager upload bit (although that could possibly apply), but the role escalation. That is, rewriting POST variables and resubmitting in order to gain admin privs. Ask yourself, “do I […]
https://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.png00Tom Kinghttps://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.pngTom King2014-01-30 13:12:132014-01-30 13:12:13Mura CMS vulnerability – might apply to your cfWheels app
Since Jan 2014, RSS2 and iCal have been added – these are a bit experimental – would appreciate feedback! Each user can have a unique key generated for them by an administrator (it’s not there by default); Once an API key is available for that user, and their role allows it, they should be able […]
https://www.oxalto.co.uk/wp-content/uploads/sites/20/2014/01/Untitled-2.jpg535681Tom Kinghttps://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.pngTom King2014-01-04 11:53:392014-01-04 11:53:39RSS2 & iCal for RoomBooking System
The Room Booking system is now available as v 1.01; the main addition being permissions, roles and authentication. As before, I thought it might be useful to highlight a few of the thought processes behind this update, and look at some of the problems come across when beginning to think about an application which is due […]
https://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/10/permissions.png240585Tom Kinghttps://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.pngTom King2013-10-05 11:55:242013-10-05 11:55:24Things learned from creating the RoomBooking System (part 2)
So I admit that’s a pretty quick release cycle, but hey, I was inspired (or something). There’s some massive changes, most noticeably the addition of user authentication, roles, permissions, logging & password resets. All documentation has been moved to https://github.com/neokoenig/RoomBooking/wiki, where you can find a breakdown of all the settings, permissions, roles and upgrading instructions.
https://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/09/rb101.jpg228621Tom Kinghttps://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.pngTom King2013-09-29 14:26:172013-09-29 14:26:17v1.01 RoomBooking system released
Since launching my little Room Booking system as an open source project, I thought it might be useful to highlight a few techniques used which others might find useful. Obviously, this isn’t to say that this is the ‘only way to do x’, but merely to flag some ways to approach common problems. All the […]
https://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/09/rbs__0000_Layer-10.png9361224Tom Kinghttps://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.pngTom King2013-09-26 12:05:242013-09-26 12:05:24Things learned from creating the RoomBooking System
I’m pleased to announce a new open source project for a room booking system – it’s basically a backend to the excellent fullcalendar.js jQuery plugin, using cfWheels as the back end. Features include: All (well most) configuration done via database settings Uses the DBMigrate plugin for cfWheels for easy future updates Uses the FullCalendar.js month/day/week […]
https://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/09/rbs__0009_Layer-1.png9361224Tom Kinghttps://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.pngTom King2013-09-24 20:35:442018-05-24 10:34:02New Open Source Project – Room Booking System
This is really a set of notes for me so I don’t forget all this in the future, but hopefully might help others. If you look at the Railo wiki on github about this, it gives you great instructions about 6, but I found my experience slightly different for 7. These are the steps to […]
https://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.png00Tom Kinghttps://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.pngTom King2013-06-20 17:57:162013-06-20 17:57:16Upgrading JRE for Railo on Centos
Every now and then, it’s good to have a clean out huh.. 2-3 seconds response time (!) down to 200ms. Not quite sure what happened with that old box, but hey. Fresh installs FTW.
https://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/03/response.png315624Tom Kinghttps://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.pngTom King2013-03-04 20:50:452013-03-04 20:50:45What a difference a new server can make
So two years ago I started up a linode – yep, I’m still with them for my LAMP stack stuff. I really have no complaints, whatsoever. Since being with them they’ve bumped up my storage to 48GB from 40GB (for free), I’ve had one network problem (which affected everyone in my datacentre) about 18 months […]
In response to “What does your VLE say about your institution?” on the TALL blog at Oxford University – they pose the statement: “The evolution of an institution’s VLE is the narrative of that institution’s attitude towards, and relationship with, learning technologies.” To me, VLE design usually falls into two categories: 1) an open source […]
https://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.png00Tom Kinghttps://www.oxalto.co.uk/wp-content/uploads/sites/20/2013/06/OxAltoDesign_143_59.pngTom King2013-01-29 10:11:282013-01-29 10:11:28A response to ‘What does your VLE say about your institution?’
HasManycheckbox() is obviously only one way of updating these relationships. The other main way is via cunning uses of includePartial(). Let’s return to our contact’s email addresses – remember the contact ‘hasMany’ of those. We need a way to a) list their existing email addresses, b) add new ones (preferably within the same update form […]
So far we’ve setup the database tables and the models, so now we need to start thinking about getting and updating this contacts data, including the associated nested properties. Outputting a simple add/edit form should hopefully be familiar to you by now (if not I recommend checking out the cfwheels screencasts: http://cfwheels.org/screencasts ). When updating […]
Let’s look at an example call to a contact, but without any of it’s relationships. So, the simplest possible call – find me one contact row where id = 1. Well, it’s good to see our createdAt field got autofilled, and our calculated property of fullname made it through too. deletedAt is null, which is […]
My new favourite SQL function – SUBSTRING_INDEX
/0 Comments/in mySQL /by Tom KingSo I needed a quick way to convert a list of authors from “Joe A. Bloggs” into “Bloggs, Joe A.” – i.e, not separated out into firstname and lastname fields, just one field called ‘name’. I then needed another field to return a single column with the first letter of the lastname for display purposes. […]
Scaling your hosting environment with free services
/0 Comments/in cfwheels, vps, web-development /by Tom KingThere comes a point in life when your current hosting environment needs to scale up, and quickly. It might just be that one of your clients gets very popular very quickly, or the gradual adding of sites and resources starts to make services fail. Thankfully there are a few tricks to make life a little […]
Mura CMS vulnerability – might apply to your cfWheels app
/0 Comments/in cfwheels, Coldfusion /by Tom KingJust a head’s up: This recent Mura CMS issue is something which could possibly apply to a wheels app: http://www.trunkful.com/index.cfm/2014/1/29/Mura-CMS-Vulnerability I’m not referring to the file manager upload bit (although that could possibly apply), but the role escalation. That is, rewriting POST variables and resubmitting in order to gain admin privs. Ask yourself, “do I […]
RSS2 & iCal for RoomBooking System
/0 Comments/in cfwheels /by Tom KingSince Jan 2014, RSS2 and iCal have been added – these are a bit experimental – would appreciate feedback! Each user can have a unique key generated for them by an administrator (it’s not there by default); Once an API key is available for that user, and their role allows it, they should be able […]
Things learned from creating the RoomBooking System (part 2)
/4 Comments/in cfwheels, Coldfusion, opensource /by Tom KingThe Room Booking system is now available as v 1.01; the main addition being permissions, roles and authentication. As before, I thought it might be useful to highlight a few of the thought processes behind this update, and look at some of the problems come across when beginning to think about an application which is due […]
v1.01 RoomBooking system released
/0 Comments/in cfwheels, opensource /by Tom KingSo I admit that’s a pretty quick release cycle, but hey, I was inspired (or something). There’s some massive changes, most noticeably the addition of user authentication, roles, permissions, logging & password resets. All documentation has been moved to https://github.com/neokoenig/RoomBooking/wiki, where you can find a breakdown of all the settings, permissions, roles and upgrading instructions.
Things learned from creating the RoomBooking System
/14 Comments/in Bootstrap, cfwheels, Coldfusion, Javascript, jquery /by Tom KingSince launching my little Room Booking system as an open source project, I thought it might be useful to highlight a few techniques used which others might find useful. Obviously, this isn’t to say that this is the ‘only way to do x’, but merely to flag some ways to approach common problems. All the […]
New Open Source Project – Room Booking System
/102 Comments/in Bootstrap, cfwheels, demos, jquery, opensource /by Tom KingI’m pleased to announce a new open source project for a room booking system – it’s basically a backend to the excellent fullcalendar.js jQuery plugin, using cfWheels as the back end. Features include: All (well most) configuration done via database settings Uses the DBMigrate plugin for cfWheels for easy future updates Uses the FullCalendar.js month/day/week […]
Upgrading JRE for Railo on Centos
/0 Comments/in railo /by Tom KingThis is really a set of notes for me so I don’t forget all this in the future, but hopefully might help others. If you look at the Railo wiki on github about this, it gives you great instructions about 6, but I found my experience slightly different for 7. These are the steps to […]
What a difference a new server can make
/8 Comments/in Coldfusion, vps /by Tom KingEvery now and then, it’s good to have a clean out huh.. 2-3 seconds response time (!) down to 200ms. Not quite sure what happened with that old box, but hey. Fresh installs FTW.
VPS Hosting revisited
/0 Comments/in Coldfusion, railo, vps /by Tom KingSo two years ago I started up a linode – yep, I’m still with them for my LAMP stack stuff. I really have no complaints, whatsoever. Since being with them they’ve bumped up my storage to 48GB from 40GB (for free), I’ve had one network problem (which affected everyone in my datacentre) about 18 months […]
A response to ‘What does your VLE say about your institution?’
/3 Comments/in web-development /by Tom KingIn response to “What does your VLE say about your institution?” on the TALL blog at Oxford University – they pose the statement: “The evolution of an institution’s VLE is the narrative of that institution’s attitude towards, and relationship with, learning technologies.” To me, VLE design usually falls into two categories: 1) an open source […]
cfWheels Relationships (Part 5)
/8 Comments/in cfwheels, Coldfusion /by Tom KingHasManycheckbox() is obviously only one way of updating these relationships. The other main way is via cunning uses of includePartial(). Let’s return to our contact’s email addresses – remember the contact ‘hasMany’ of those. We need a way to a) list their existing email addresses, b) add new ones (preferably within the same update form […]
cfWheels Relationships (part 4)
/0 Comments/in cfwheels, Coldfusion /by Tom KingSo far we’ve setup the database tables and the models, so now we need to start thinking about getting and updating this contacts data, including the associated nested properties. Outputting a simple add/edit form should hopefully be familiar to you by now (if not I recommend checking out the cfwheels screencasts: http://cfwheels.org/screencasts ). When updating […]
cfWheels Relationships (part 3)
/8 Comments/in cfwheels, Coldfusion /by Tom KingLet’s look at an example call to a contact, but without any of it’s relationships. So, the simplest possible call – find me one contact row where id = 1. Well, it’s good to see our createdAt field got autofilled, and our calculated property of fullname made it through too. deletedAt is null, which is […]