Other Web Based Writings

frustrated coder

Stock data APIs, or proof that there’s always something to improve upon


Over the last few days, I’ve been working on a little side project, mainly to get familiar with some things that you’d find on a job advertisement.  PHP frameworks, Javascript, API development, the usual types of things. One of the things that I wanted to do is to use some financial API’s to collect some basic stock data. Biographical information, a brief stock performance history, a week or two at the most. Nothing that would be either immensely detailed, nor useful for any sort of data mining purpose. Figured there had to be some free to use API’s out there that had the usual traffic restrictions, but were otherwise well documented and useable.



Raising my glass to the folks that saved technical Q&A online

Let’s take a trip down the IT memory lane. Back to around 2007, when developing applications to run on your cell phone was a brand new idea. Back then I used to do some PHP development on my own, a combination of having a lot of spare time and knowing that being a sys admin in a small town was not exactly a stable profession. And as a beginner back then, I’d run into a lot of “how the heck do I do that?” type questions. So back then, here’s a typical attempt to find the answers I seeked.

PHPUnit logo

Using Debugging and Unit Testing tools with your PHP application: Conclusion


So that’s the end of this document for how to update your system to handle the new way that we can develop applications. Hopefully you found it informative. Any changes please give me a shout at PHPUnitTutorial at creedscorner dot com.


Balsamiq mockups; The best thing for app designers since the IDE


One of the projects where I work currently has been identified as a good possibility to have a mobile application made for it, so today I decided to take it upon myself to plan out how the application would look and work.

And let me say, I’m glad that I was using Balsamiq mockups to do it with.

For those that aren’t familiar with this software, Balsamiq mockups allows you to quickly piece together a design for your application, in a manner that’s quick and easy to display to those that would be deciding its fate. Saves on waiting for weeks for designers to create super fancy mockups, or doing it by pen and paper (which never looks good, especially on a cocktail napkin…..dont’ ask). Within one day I had the entire application laid out, which consisted of roughly 15-20 screens, including notes for each one, and I must say it doesnt’ look too shabby.

For those reading in the interwebz, I’ll let you know how it goes.

Getting a lot of 0′s in front of your numbers using mysql?


This might be the reason why.

Was doing some debugging for an application that I’m working on in my spare time, using PHP and MySQL (how original). For one of the pages, the userID’s were stored in an int field with eleven spaces, more then enough for the amount of users I eve expected to stop by. However, when I went to view the data stored by my session, the userID was stored as 00000000001. What was going on?

The answer it seems, was as simple as unchecking the option for zerofill. Once removed, the numbers looked as expected. Gotta love simple solutions.

Now I could not find out why someone would want this feature enabled (maybe to make their pages less empty?), but it did at least fill my “learn something new today” quotient.

Go to Top