What's the advantages of PostgreSQL vs. mySQL?
And we live to fight another day.
Mal ,'Objects In Space'
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.
Jon B. - Apr 06, 2007 5:31:37 pm PDT #1213 of 4673
A turkey in every toilet -- only in America!
§ 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.
§ ita § - Apr 09, 2007 3:22:16 pm PDT #1222 of 4673
Well not canonically, no, but this is transformative fiction.
Quick update from support, will detail more later.
Oh, and Jon, I realise I never did any of what I said I'd do for you this weekend. More in email.
They said that we can go up to PHP5 on Plesk, and any version of PostreSQL (because it's not integrated with Plesk), but we'd be kept on MySQL 4.
So I'm even more pro-upgrade than I was before.