Yeah, blatant Futurama reference.
So I have decided overall that this is my personal blog. I am going to have to keep some blogs for work and side project, but this one is all me.
Moving on, I was enlisted by my buddy to help them convert from Access to MySql on their enterprise database. Now, don't get me wrong I loved Access, back in the day. Before MySql was around. Because that was the Poor man's database, now it is just the ignorant man's database.
MySql is fscking easy. I mean if you consider yourself a linux user you can probably install MySql. If your a windows users, it is so, so much easier. I honestly had the database engine installed in about 10 minuts.
Now there is a trick to converting between Access and MySql. However, a good chunk of the work can be done using their Migration tool. But as I have found out it doesn't flawlessly convert. Things like default values and autoincrement fields get lost in the shuffle. So if your converting, you will need to go through the access database and make a list, check it twice and make sure that the conversion is not naughty, but nice.
I am not going to place any blame on the coder who was enlisted to modify the code from Access to MySql, cuz well he isn't the guy that wrote it originally. The original coder, i mean honestly, I never met the man, but from what I have seen as the results and from hearsay he is a fscking moron.
But Asp.Net just sucks. I don't like it. Yes, Yes it is better than the old ASP VbScript. Which I was fairly familiar with.
I AM A LAMP SNOB!
I don't necessarily say "Fsck you Micro$oft" but I definitely can be considered that as of late. I dig LAMP (Linux Apache MySql PHP). I think the bang for your buck is with Linux.
I mean sure there is more TCO (total cost of ownership) in regards to your staff having ot be more skillful with computers, but isn't that a good thing? I mean to have a staff that is more competent vs one thta just gets by with simple point and click?
I mean i started out as the latter and worked my way up into the ranks of someone who can install windows or linux. I also learned to install and admin apache and mysql.
This endevour was my first attempt at a windows based MySql install. Like I said it was really, really easy. The tweaking of the conversion from Access to MySql is something I should have paid more attention to.
Anyway, I know there are a lot of big sites that run ASP.Net but overall I have not been impressed with it as a techology. Windows based platforms seem to need more horsepower than a LAMP based platform. And there seem to be a lot more creative (and cheaper) methods for building redundant clusters.
So the cheap bastard in me loves LAMP because there is no lincensing costs. The even cheaper bastard in me loves the fact that you can use a P3-600 with 1 GB of ram and have a half decent web server.