I've been poking around at the versions of software we're based on and what's out there. We're way behind, and I can see definite gains for the board's stability, expandability, and reusability by taking advantage of more recent versions of PHP and MySQL, not to mention the PostgreSQL option.
I sent an email to support asking for more details about our required upgrade, and also asked if our current activity could be supported on one of their newer offerings, the virtual dedicated server.
And, in all that, when we can get PHP 5, MySQL 5 and at least PostgreSQL 8 without breaking all our links.
Will post when the answers come.
Okay, the board font just jumped about four sizes. Is this me or the board, and how do I change it if it's me?
Did you do the mouse wheel thing?
Hold Ctrl and scroll up. The font will go down.
ita, yeah, Redhat 7.3 is seriously behind the times. Later MySQL versions are much, much more stable under heavy load, for instance.
They're on about upgrading you to CentOS 3 from memory, which is a couple of years old. I think from memory it's PHP 4 and MySQL 4 based. I've used VPS hosting for Serenitymovie.org in the past -- it worked, but I had issues with MySQL so ended up moving away from it.
Jon, this is probably not a good place in the sequence to mention it, but I'm wondering if the CSS (or at least the ids and classes in the HTML) can't be streamlined using inheritance. I'm going to read up this weekend. I'm combing through it now, and it's just so
wordy.
I agree ita.*
Can you fling me the password to the CSS site? I've got some time and could help out more.
* (See, despite the temptation, I did not write "ITA, ita." Oh, wait, damn).
Jon, I'll get that to you this evening/tomorrow morning.
It's probably no big surprise, but I've been working on the internals of the code with an eye to fresher platforms.
Current ramifications include much of the site rewritten on paper (okay, text files untested) in PHP 5 and PostgreSQL. By much, okay, I don't mean most. But if in a miracle it didn't need debugging, one could read and post and many of the internals are awaiting presentation for things like editing and deleting and admin stuff.
What's the advantages of PostgreSQL vs. mySQL?
I can't speak for later versions of MySQL, since I haven't developed for it past the version we're running now. I think it's catching up, but PostgreSQL has long had stuff like stored procedures and triggers and the like. It's supposed to be more stable, but like most stuff, it depends who you ask.
