Posts Tagged ‘php’

Using XML for Glue: LAMP + IIS&MSSLQ= Data That Just Works.

Sunday, May 3rd, 2009

I’ve ran into an interesting problem lately, I’ve been enjoying building more and more applications on a LAMP platform in PHP, vs C#.net on IIS. My roots are really in PHP anyway, but school taught nothing but C#.. Quandry!  Since we don’t have time to argue this out in a blog post, I’ll just leave it here: I’m leaving C# on the desktop and utilizing PHP for it’s fast deployment ease of troubleshooting and flexible coding. During my move to more PHP applications I’ve an into an issue recently where an entire web project I’m trying to integrate with was written in asp.net using MSSQL. I just need to run a few stored proc’s for some data out of the MSSQL db, but unlike my IIS server or old, the Media Temple grid doesn’t have any MSSQL support in it’s versions of PHP. So, where does a guy go from there? To the universal language of data: XML.

It was so satisfying to remember that I could whip up an ASP page that asks for hugely long security keys to verify the host asking for data and then upon successful reading of keys hands the PHP script back all the data it needs, in an easy to spit-out much enjoyed XML document.

This brings me to a neat point here: if you’re writing a huge database driven web application and you’re likely to expand it’s functionality or allow others to design functionality based on your data… USE XML for getting data to process and vice versa when it’s done processing. This will leave your co-horts happily programming in the language of their choice, a nice place to be!

Mantis is my friend (and not on FB!) plus me breaking and using jQuery

Tuesday, February 3rd, 2009

Thank heavens for bug trackers. It’s like having an annoying secretary reminding you all the time of the shit you promised to do but haven’t done yet. If I could just get my clients to enter bugs directly it’d be like bliss on wheels. Scary is the realization that my first inclination is “wonder if I can hack this around a bit to be more a general issue/helpdesk tracker…”. More importantly, is there a good helpdesk/ticket tracker out there? (opensource and free is obviously preferred) Mantis is so easy to set up and use (I’ve had it before but it didn’t get used and was killed off in a server move). The secret is to have enough work to require it (I can finally say we have that more than covered) and to USE it for EVERYTHING. yes, it feels like you’re wasting time putting in all those bugs, but it keeps great records of what you’re doing and lets be honest, even the best of us can forget the smallest things. Anyone out there have suggestions for the best way to get clients to sign up and use it now?

This next part might come as a shock to those that know my programming methodology: I’m using jQuery. I’m not a flashmaker yet, (thank the lord) but it was time to step up and make SiC Media’s stuff a little prettier and whole lot more functional. So, in comes jQuery and AJAX. Besides, how else do you do this:

You’ll notice bit by bit each site we do will have more and more of these fun dynamic elements. Look at us, all web 2.0.
*goes to barf*

This is software, script kiddie.

Tuesday, January 27th, 2009

Normally I do websites that are fairly visually pleasing, and have a little bit of decent programming to them. A well placed e-mail form, a bit of AJAX.. nothing too spectacular. I’ve written a few C# windows mode programs that were all, well, functional. Repair a database by doing this, set an AD attribute to this if another attribute is this… etc. Generally speaking, the design is good, and the programming as good as it needs to be, all culminating in a little CMS I’m still doing that helps a group of people with very little time take over their website, and runs off one codebase for my sanity. The latest project for me is a bit different. It’s a property listing site, with all the cool bells and whistles: list your properties, search them, swap them, pay for it too (hopefully).

Everyone says programmers have youthful optimism- I like to say I have pessimistic optimism. This time however, I got ahead of myself. I bid the project too low, decided immediately I’d write it from scratch, and then got behind and have thus far refused to push back the roll-out date. Any one of the little pieces are swallowable: upload and resize photos, no problem, add a listing, no problem, register for a membership, etc etc. Then you start to see the intermixing: allow editing of the property, but only select things, and only if the person owns the property and their account is active. Then, make it reusable, make it safe, and sanitary to use: make it secure! They all compound into a code mess.

To make matters worse I started without utilizing a SVN/Versions system. This late in the game, it’s impossible to add it. The bug-tracker will get put into use after the first rollout is done now, and I expect it to be full. I’ve been recently re-reading “Dreaming in Code” and feel a bit like the Chandler developers. It’s time to put something out: it doesn’t matter how bad it is, I need a place to start improving from. It’s only been ~1.5 months, and I feel like I’ve been tossed under the bus. It doesn’t help that tonight I’m writing this at 1:00 AM because I’ve been up puking pizza hut for the last 2 hours. My throat is sore and swollen, and I have a runny nose. It’s either the worst incarnation of a cold I’ve ever had or the flu. Either way: it’s killing my timeline. Normally a sick day or two happens, in a release timeline involving daily goals and weekly releases, it’s a big problem.

This all brings me to the title: this is really the first piece of full fledged software I’ve written. I didn’t dub it as such starting, but it is. I’ve got roughly 2000 lines of PHP and HTML and CSS that need to be hewn into something pretty in the next few weeks. I need to setup a bug tracker for the inevitable post-release bugs. What gets released right away? What features come after the first release? Internet companies of the past suggest now is the time to be setting up a $$FREE$$ ‘beta’ version of the site to find the last of the bugs and push it into a stable release with all the bells and whistles. Unfortunately the owner of the site doesn’t have that in mind, financially. Now that I realize where this project has taken me, and what this means for me and the company, I want to make good, nay, I want to make it excellent. I want to be able to put this out there saying “look, 2 months, and a usable piece of software…”: it needs to be a building block for making SiC fund me (and others) more completely. I always think with just a bit more time the company will really start to take off, problem is to get a bit more time out of my schedule requires making it pay for a bit of the time.

Cats Alergic to Cat Litter?

Sunday, January 4th, 2009

I got back from the grocery store with cat litter for Luci only to witness one of the funniest things in history. I tried new litter, for “small spaces” that has a better odor blocking ability (Luci’s #2’s occasionally rival mine in smell factor) and upon dumping it in Luci went strait for it. That’s normal behavior if you don’t have a cat: clean the box and the first thing they’ll do is use it. This time though she jumped in and started sneezing! Turns out the ’scent blocking’ bits were really just smelly bits. I was nearly dying laughing. Luckily the smell wore off and Luci’s back to normal.

Today is a blitz of cleaning and working as I need to get the propswap beta site moved to the new server and some progress done on it. In the middle I’m doing laundry and cleaning the house up after 2 weeks of non stop going and no cleaning. The prop swap should get a full sign up system by the end of today and the ability to add properties to an account. Tomorrow I hope to have the basic searches done as well as the mortgage calculator. Also hoping to get to watch the Vikings loose with Dan-o Later!!

The Dawning of a new Blog

Saturday, January 3rd, 2009

Welcome to the new ChrisUthe.com. In the past this page has been primarily used to house my Resume, which can still be found here. Due to the frustration of running multiple sites for multiple purposes (loudmouthme.com && ourthinktank.org both blogs, gallery installs etc) I’ve decided to focus it all down to one site, this one. LoudmouthMe.com and Ourthinktank.org will both land you here. For now none of the content will come over, but that might happen later. For those that visit here, new content! Photos, lots of them- and personal updates! Thrown in posts about PHP C# and other geeky things. It’s a mish-mash of all the things that happen in my life, a true blog about what I do and who I am. Welcome!