Coding

SQL injection has been a method of attacking databases through multiple tiers of application infrastructure for many years, MacVittie (2008). SQL or Sequential Query Language is a database language used to interact with large quantities of data, typically stored in tables inside a Relational Database Management System (DBMS). Each command using the SQL language typically generates a result set of data. An example of this follows: select * from accounts The (*) is effectively used to return (all) columns of data in the ‘accounts’ table. A similar, and more dangerous statement could be issued using the drop command: ...

The Internet has brought us a wealth of conveniences and everyday tools that we could not live without and more importantly a dependency that we cannot break. In the workplace the Internet has become a part of our day to day lives. We rely on instant communication with our co-workers, friends and colleagues as well as access to a multitude of information at our fingertips. Children from younger ages are becoming more involved with computers and technology in a trend will continue as the Internet of Things evolves around us in every day appliances. Unfortunately, with all these convenience come challenges and risks that we need to deal with. ...

Software Setup For this class you will require three main applications, a text editor, an SSH client and an FTP client. A text editor will be used to write your HTML documents. SSH (Secure SHell) is a text based application which will enable you to setup your Nova web server account, which we will be using to host your web pages online. Finally an FTP (File Transfer Protocol) client will be needed to actually copy over or upload your files to Nova from your PC or Mac. I am recommending your install Atom for text editing, FileZilla for FTP, and PuTTY SSH client for Windows users. ...

Nova is a Unix based web server which is used through various computer studies courses at UMUC. If you are taking one of my web design classes or are enrolled in another UMUC class that uses Nova, the information provided here should be helpful. Nova is the server you will be using to setup your web directories for publishing content online. In order to set up a Nova account you will need you MyUMUC login and password. Once created you will be assigned a unique Nova login account. ...

All files and directories created in a Unix environment such as Nova are assigned permissions based on the level of access available to different user groups. In order to understand permissions better, we will discuss users, groups and ownership. Users Unix is a multi-user operating system. It serves many users who have ownership or certain privileges of resources on the system. You have recently set up a Nova account at UMUC and therefore have become one of its users. ...

Drupal can be installed on any number of environments, but since it was developed primarily to run on an Apache server with PHP and MySQL database, it makes sense to mimic this environment as much as possible in a development sandbox. There are LAMP applications for both Windows (WAMP / XAMP) and Mac OS (MAMP) which can serve as a Linux replacement, however recent innovations with Virtual Machines and Vagrant means that we can re-create a more native environment for development quickly and easily. Below I will describe how you can setup Drupal using some of these tools in less than 10 minutes. The Vagrant setup used here is Scotch Box. The objective is to setup a Drupal development environment with full LAMP stack capabilities including command line access and Drush integration using the native Linux file system for speed and compatibility. ...

Lately I’ve been carrying out some work involving the Freedom of Information Act (FOIA). There is tons of information about FOIA on the web including on the official foia.gov website, however I decided to summarize the main points of this law in an easy to read / digestible format. This article is broken down into three main parts, a brief intro, the main areas covered in the law, and concludes with the exemptions. ...

I recently migrated this site to Media Temple’s managed Wordpress hosting plan. For a number of years I had been running a dedicated server through CoreNetworks, which I have been extremely happy with. More recently however I have come to realize I no longer have the need for dedicated server and began researching cheaper managed hosting alternatives, which brought me to Media Temple. Over the years I have heard a lot of good things about this company so when I found out about their WordPress plans, I decided to make the plunge and migrate carnaghan.com to its new home. So far my experiences have been relatively positive. ...

For a while now I have been using WAMP as my daily driver for Drupal development on my Windows 8 machine. For anyone who is a Drupal developer and uses WAMP (or a variation LAMP stack on Windows) has probably felt the pain it brings in terms of sluggishness, incompatibility with native Linux applications (Drush anyone?), and a headache administer PHP modules. I won’t even get into the problems I’ve had in the past getting cURL to work properly in Windows. I decided it was finally time for me to explore Vagrant as I had heard a lot about it but had never taken the time to do any amount of research. ...

I am often interested in hearing about how people within the software development community keep up with the latest changes in tools, technologies and programming languages. It seems that every few months there is a new framework or better way of doing something in an entirely new tool-set or language. For me personally, I don’t have much time during the day to spend reading the latest industry blogs and online development new outlets, so to help supplement this I routinely listen to a number of podcasts on my commute to and from the office. ...