Displaying the most recent of 8 posts written by

Scott Gottreu

Sorting & Filtering Tables

So a large portion of the code I write is to output data in table format.  When you have hundreds of rows, it becomes hard to decipher all the data. Plus, the end users are use to Excel, which allows them to sort and filter their data. I originally tried to implement sorting on the [...]

The Lengths I Go to Organize My Books

A few years ago I installed OpenBiblio on one of my websites to keep tab of all my books. I wrote a Perl script that uses a book’s ISBN number to retrieve the bibliographic information from Amazon and then enter the book into my library.  I can now search all my books  as well my [...]

Linux from Scratch

I was given the task a few weeks ago of finding point of sale software for our clinic. I started by looking at all the open source options. Two likely candidates were PHP Point of Sale and Lemon POS. Since this point of sale would be put on either a stand-alone system or be placed [...]

Spring Cleaning & Going Dark

I’m not really sure why it happened but beginning around the 1st of March I just went dark on the internet. I would occasionally check in on Facebook but I stopped blogging, tweeting and all that other outward focused internet type stuff. One, I didn’t think I had that much to say and two, I [...]

jqPlot – Clickable Bar Graphs

I’ve been creating several charts using jqPlot and several of them have been bar graphs. One issue I ran into early on was how to I determine which bar someone clicked on without actually clicking on the data point at the top of the bar. Updated – Clicking on the image will take you a [...]

Visualizing Data – jqPlot & gRaphaël

My supervisor mentioned to me about a month ago that the doctors want a dashboard on our website to track various data points. How many patients were seen in a week. How many patients did each doctor see. What were type of visit were the patients coming in for. The wish list could go on… [...]

Updating Stored Hierarchical Data in a Database

I am currently developing an inventory system for my company.  I wanted to create a category listing but I have always struggled with creating hierarchy and storing it in a database.  I created a CMS package at my last place of employment. I remember spending a great deal of time working out how to create [...]

Another Programmer’s Blog

I’ve been blogging off and on for the last 5 years. I’ve written about technology and programming as well as my personal life and my faith. I’ve often refrained from geeking out too much on my blog because I didn’t want to go over people’s heads and most of my readers are not coders. However, [...]