1337 MySQL skillz
Today I installed Ubuntu for somebody I sort of know. He lives next door to Owen.
It was fun. I installed a lot of nice extra packages for him. Like Firefox 1.0.
The first time I install Linux on a machine that isn't my own and I even get paid for it! Crazy!
After my short stay on his computer, it was very nice to get back to astro, my beloved PC. That makes me think. Maybe I should make a vanity page for my computers. Yes. I'll do that. There'll be pictures too. A full biography of each machine. Then I'll have a place to show off about my latest cool computer (not that I'll be getting one any time soon).
That's the first time I've looked at porn... using TDFSB. It's a cool little application.
Tonight I have been playing with MySQL. I made a cool thing with MySQL and PHP. It's available: here.
Pretty simple, yes. But it's my first experience with BLOBs. I was impressed that it was so easy to make the PHP output a BLOB which was an image.
For those of you without the time to read the source and test it, the PHP script connects to the machine table (on `tadams2` in this case) and lists my machines. It inclues an image for each one and some text. The image cannot be put inline. The image source is the script itself. The script then looks in the database for machine_image or machine_small_image depending and throws it up with a special header ("Content-type: image/jpeg"). It's a nice example of an all-in-one script with a nice bit of recursiveness.
Speaking of recursiveness, there was a recursive algorithm I implemented in my magix script the other day. It's very nearly ready. I just need to be able to add actual files (rather than crap to be stuck into a template) for CSS and images. Then it will be operational. There will be no pretty UI (yet). I can just use phpMyAdmin or MySQL CC to edit the data.
Until I write a pretty UI, the trainee gallery curator will just have to learn some 1337 MySQL skillz.
The script technically almost works. But if it's to become a general tool, I'll have to do some serious tidying. A pretty PHP-based web UI would be nice too.
It was fun. I installed a lot of nice extra packages for him. Like Firefox 1.0.
The first time I install Linux on a machine that isn't my own and I even get paid for it! Crazy!
After my short stay on his computer, it was very nice to get back to astro, my beloved PC. That makes me think. Maybe I should make a vanity page for my computers. Yes. I'll do that. There'll be pictures too. A full biography of each machine. Then I'll have a place to show off about my latest cool computer (not that I'll be getting one any time soon).
That's the first time I've looked at porn... using TDFSB. It's a cool little application.
Tonight I have been playing with MySQL. I made a cool thing with MySQL and PHP. It's available: here.
Pretty simple, yes. But it's my first experience with BLOBs. I was impressed that it was so easy to make the PHP output a BLOB which was an image.
For those of you without the time to read the source and test it, the PHP script connects to the machine table (on `tadams2` in this case) and lists my machines. It inclues an image for each one and some text. The image cannot be put inline. The image source is the script itself. The script then looks in the database for machine_image or machine_small_image depending and throws it up with a special header ("Content-type: image/jpeg"). It's a nice example of an all-in-one script with a nice bit of recursiveness.
Speaking of recursiveness, there was a recursive algorithm I implemented in my magix script the other day. It's very nearly ready. I just need to be able to add actual files (rather than crap to be stuck into a template) for CSS and images. Then it will be operational. There will be no pretty UI (yet). I can just use phpMyAdmin or MySQL CC to edit the data.
Until I write a pretty UI, the trainee gallery curator will just have to learn some 1337 MySQL skillz.
The script technically almost works. But if it's to become a general tool, I'll have to do some serious tidying. A pretty PHP-based web UI would be nice too.
posted by holizz at 02:13
0 Comments:
Post a Comment
<< Home