Now, I can hold a note for a long time...actually I can hold a note forever. But eventually that's just noise. It's the change we're listening for. The note coming after, and the one after that. That's what makes it music.

Host ,'Why We Fight'


Buffistas Building a Better Board ++

Do you have problems, concerns, or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.


§ ita § - Apr 06, 2007 2:48:55 pm PDT #1212 of 4673
Well not canonically, no, but this is transformative fiction.

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.


Jon B. - Apr 06, 2007 5:31:37 pm PDT #1213 of 4673
A turkey in every toilet -- only in America!

What's the advantages of PostgreSQL vs. mySQL?


§ ita § - Apr 06, 2007 5:36:55 pm PDT #1214 of 4673
Well not canonically, no, but this is transformative fiction.

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.


Tom Scola - Apr 06, 2007 5:38:06 pm PDT #1215 of 4673
Mr. Scola’s wardrobe by Botany 500

You might want to experiment with SQLite, also.


§ ita § - Apr 06, 2007 11:30:59 pm PDT #1216 of 4673
Well not canonically, no, but this is transformative fiction.

From looking at their web page I don't think they support everything we currently use in terms of SQL commands. Do many hosts offer it?


Kevin - Apr 07, 2007 3:56:18 am PDT #1217 of 4673
Never fall in love with somebody you actually love.

Hosts are generally MySQL, then PostgreSQL. PostgreSQL's been more advanced for many years. That said, I use MySQL myself nowadays and later versions are much improved, both in features and -- rather critically -- stability. I still wish I didn't have to manually rebuild and optimize tables, though, and the lack of active-active replication bugs me.


Tom Scola - Apr 07, 2007 4:41:26 am PDT #1218 of 4673
Mr. Scola’s wardrobe by Botany 500

SQLite is a library that's built into PHP 5.


§ ita § - Apr 07, 2007 6:03:37 am PDT #1219 of 4673
Well not canonically, no, but this is transformative fiction.

From the docs, SQLite looks like an extension to PHP. The install we're running doesn't seem to have it.


Jon B. - Apr 07, 2007 11:09:13 am PDT #1220 of 4673
A turkey in every toilet -- only in America!

New Suggestion:

Y'know how there are people who don't like white-fonted discussions? What if we changed the "s" quickedit to substitute a class, let's call it "spoiler", that was defined as {color: #FFF} in the default stylesheet? Then, once we implement the css update, users who don't like whitefont could use the custom stylesheet utility to redefine the spoiler class to any color they like!

t on edit I see that there's already a spoiler class with that exact definition, but it's not being used for the quickedit.


§ ita § - Apr 07, 2007 11:46:38 am PDT #1221 of 4673
Well not canonically, no, but this is transformative fiction.

I see that there's already a spoiler class with that exact definition, but it's not being used for the quickedit.

I'm not sure why it's not being used for the quickedit. That's an oversight on my part. Let me fix that right now.

And then I'll look over the files you sent, and toss you the password in question.

Part of what I am trying to achieve with the rewrite exercise is to put all the HTML generation on one level, so it's easier to maintain. Right now all sorts of code, classes and pages, can generate HTML. Messy, messy, messy. Want to separate form from function as much as possible.