02-03-2005 23:51									#1
	SQL Database shutdown Support Apolyton, buy Galactic Civilizations

When I get this message (see below) is it really that the SQL "server shutdown is in process"

It seems like it's happening a lot recently...

Attachment: poly crash.jpg
This has been downloaded 119 time(s).

	02-03-2005 23:55									#2
	Support Apolyton, pre-order Civilization IV

I think them SQLs is drunk.

	03-03-2005 00:01									#3
	Avatar Enlargement: We've got the solution

Using the DISTINCT command.

	03-03-2005 00:13									#5
	Support Apolyton buy from Amazon

MySQL.

It's about time a site of this size upgrades to a real DB.

	03-03-2005 00:27									#6
	Get a bigger avatar today!

Yeah, got a few of them lately. But not that much more than before though.

	03-03-2005 01:43									#7
	Support Apolyton, buy Civilization: The Boardgame

quote: Originally posted by Asher MySQL. It's about time a site of this size upgrades to a real DB.

Why not? From what I've read MySQL is of the best things around for forum boards.


EDIT: I just got one after using "My Threads"

	03-03-2005 01:46									#8
	Support Apolyton or Terrorists Win

quote: Originally posted by alva Why not? From what I've read MySQL is of the best things around for forum boards. EDIT: I just got one after using "My Threads"

MySQL is simple and free, and fine for small loads.

Its performance sucks for large databases, and it lacks some "basic" features like DB views.

	03-03-2005 14:41									#9
	Support Apolyton or Terrorists Win

quote: Originally posted by Asher It's about time a site of this size upgrades to a real DB.

what DB do you suggest and do you volunteer to do a port of our scripts (vbulletin, vb mods, civgroups, hofs, dir, news, etc) to it?

	03-03-2005 19:46									#10
	Support Apolyton buy from Amazon

I suggest DB2 for Linux, and I'm forced to recommend you use IBM's consulting arm if you need help porting things.

Seriously though, if you're looking for free and open source, PostgreSQL is the obvious choice. It would be unfortunate (and stupid) if all of your scripts used MySQL-specific functions and commands, rather than SQL.

	03-03-2005 22:26									#11
	Suffering from ads?

Well, php has different commands for accessing different types of databases, so even if the SQL queries are pure SQL there would still be changes needed. Also sometimes serverspecific features might have been taken in use in an optimization phase, since the code is creted to run on MySQL. I don't remeber if I've used any MySQL only functionality in my scripts, but a rule of thumb has been that I've not done it unless it would meen a good optimization compared to default SQL syntax.

vBulletin only supports MySQL (at least last time I checked) but that might also only be due to the php access functions.

	04-03-2005 00:46									#12
	Enter the AD-FREE zone

so, is the mysql server (service) really shutting down multiple times a day?

	04-03-2005 12:03									#13
	Suffering from ads?

quote: Originally posted by Asher Seriously though, if you're looking for free and open source, PostgreSQL is the obvious choice.

All the comparative reviews I read put MySQL and PostgresSQL on the same level. Each has its own advantages and disadvantages.

quote: Originally posted by Asher It would be unfortunate (and stupid) if all of your scripts used MySQL-specific functions and commands, rather than SQL.

All MySQL commands are standard SQL AFAIK.

	04-03-2005 12:23									#14
	Tired of ads?

quote: Originally posted by Asher I suggest DB2 for Linux, and I'm forced to recommend you use IBM's consulting arm if you need help porting things. Seriously though, if you're looking for free and open source, PostgreSQL is the obvious choice. It would be unfortunate (and stupid) if all of your scripts used MySQL-specific functions and commands, rather than SQL.

Asher knows his shiznit.


Postgres is free and is an awesome database.

It never, ever crashes.

MySQL isn't in the same league as Postgres.

Developers like MySQL because you don't have to really know databases to use it.

A database administrator will pick Postgres every single time.

	04-03-2005 14:16									#15
	Help yourself to an AD-FREE life

quote: Originally posted by alva Using the DISTINCT command.

Hey, if they want a set of results, what else can they do ?

	04-03-2005 18:05									#16
	Support Apolyton, buy Civilization 2

quote: Originally posted by Urban Ranger All the comparative reviews I read put MySQL and PostgresSQL on the same level. Each has its own advantages and disadvantages.

The main difference is PostgreSQL can scale much higher and handle more concurrent connections.

quote: All MySQL commands are standard SQL AFAIK.

That's not true, there are all kinds of MySQL-specific functions that are common with lazy coders.

Bugzilla is being ported to work on other databases, they're just running into some problems with all the MySQL-specific stuff they've had.

	05-03-2005 09:34									#17
	Support Apolyton, buy Galactic Civilizations: Deluxe Edition

quote: Originally posted by Asher The main difference is PostgreSQL can scale much higher and handle more concurrent connections.

	05-03-2005 14:16									#18
	Support Apolyton

phpBB would be nice, though.

Asmodean

	07-03-2005 14:01									#19
	Increase the size of your Attachments

quote: Originally posted by Asher The main difference is PostgreSQL can scale much higher and handle more concurrent connections.

Again, there's no clear conclusion on the subject. It certainly is interesting that Google, Yahoo! and craigslist use MySQL.

	07-03-2005 19:42									#20
	Support Apolyton, buy Call to Power 2

quote: Originally posted by Urban Ranger Again, there's no clear conclusion on the subject. It certainly is interesting that Google, Yahoo! and craigslist use MySQL.

I think you're trying to imply something that's not the case -- Google and Yahoo certainly do not use MySQL for their search engine. They seem to use it for other, smaller products.

	07-03-2005 19:46									#21
	Enter the AD-FREE zone

There are other issues with MySQL:

It is not ANSI SQL compliant, does not support referential integrity, rules, views, triggers, unicode (? it may now, it didn't last I checked), inheritence, sub-selects, etc.

Even stored procedures are a brand-new feature in 5.0...

	08-03-2005 06:46									#22
	Got spare money?

quote: Originally posted by Asmodean phpBB would be nice, though. Asmodean

I don't like phpBB too much, at least not the default theme.
The Apolyton Forum is fine the way it is!


About MySQL, I still have to cope with shitty 3.23.something (no sub-selects, no transactions or not that I know of - I don't really want to dig into that waste of a technology any further).
PostgreSQL is fine, but people say you have to run a vacuum pretty often. Maybe they changed it with some version.