April 12, 2008

Short Updates

Posted by Scott at 11:44 PM

The dynamic aspects of my website are down this morning. It's one of those times I wish I'd used SQLite instead of MySQL for its database. 6:33am

Back from a class at the local gym. Although my foot was still a bit sore yesterday, today it was feeling better and up for a workout. 10:43am

After a hearty, sinus clearing lunch of Michelle's white chicken chili, she was sweet enough to let me catch a short nap. 1:39pm

Picked up iced coffees for me and Michelle. We're all outside enjoying the spring 70 degree temps. 2:42pm

At the Pheasant Lane Mall. We boys are at GameStop while the girls go for Abby's ear piercing. 4:57pm

Abby's ears are pierced! My good friend Ed (Daniel's godfather) successfully defended his PhD dissertation! 5:06pm

Comments

At some point, I would love to learn how to set up a website with a database back end. One day you can teach me. I want to learn to set up a local one first with IIS and see what I can do with it.

Posted by: Chris at April 15, 2008 10:31 PM

Databases are the main thing I thought were boring as heck when I was in Dayton. Granted the ones that are popular now where not the big names back then. But I remember as I was considering getting out of the USAF, the top civilian tech opportunities around Dayton all seemed to want database experience. Since I didn't have my heart on *staying* in Dayton, I didn't worry.

I actually have done almost no database programming. I've read a little bit about it here and there. But I do know that the software that powers a lot of this site has the option of using either MySQL, SQLite, or PostgreSQL. This web host has hundred of web sites all fed by one dedicated MySQL server. If it goes down, all those websites (mine included) go down. In my case it's the dynamic aspects, like accepting/integrating a new comment, or looking at a Webnote. SQLite is *local file based* and *serverless*. So it works for lightweight applications like mine even if the database server is hammered. http://www.sqlite.org/

Lastly, I've never used IIS. I've always used Apache as a web server. I'd like to play with lighttpd some day, but don't have the time. http://www.lighttpd.net/

Posted by: Scott at April 15, 2008 10:48 PM