Blog

Creating an API for SSeS

Over the past few weeks I have been creating an Application Programming Interface (API) for the Student Success eSolution (SSeS). Why does the SSeS need an API? Well, because numerous School Boards are achieving much success from the system and want to integrate directly to it. For some background, an API is a set of [...]

Tags: , , ,

Java: Writing data to a tab delimited file

I have included a simple Java function to print data to a tab delimited file with the extension csv for the convenience of opening the file with Microsoft Excel. I found this very helpful in my last project and hope it will help someone else .

Tags:

Filed under:Web Development

ExtJS: Dynamically Creating Grid Panel

I have found that ExtJS is very useful in many of my web application projects, so I thought about posting some samples relating to overcoming specific obstacles that I have successfully overcome. The first problem I encountered pertained to the rigidity of declaring a GridPanel’s column model. For this instance I needed the column model [...]

Tags: ,

Filed under:Web Development

How To: Use MySQL Events

MySQL has a relatively new feature very similar to a crontab job (Unix/Linux) or task scheduler (Windows) for scheduling and executing tasks. Ever since the release of MySQL version 5.1.6 MySQL “Events” or “temporal triggers” have been included. So what are they? Well  you can now say: "I want the MySQL server to execute this [...]

Tags: ,

Filed under:Web Development

How To: Use MySQL triggers to log table changes

So you are looking for a simple way to log a history of changes to a table. There is a common practice for that, and it involves creating a logging function in your source code (maybe php) that will require you to connect to the database, and then write the values into the log table. [...]

Tags: ,

Filed under:Web Development

Follow us on