always wondered

[mindfullsilence]

July 3rd, 2009, 1:23 am

What sort of scripting language or database would you use to create login info and website member profiles and whatnot. Not for a forum, but for, say, a gaming site or a hosting site

[spork]

July 3rd, 2009, 9:28 am

Whatever language you plan on building the rest of the site with.

[Rabid Dog]

July 3rd, 2009, 11:49 am

Well I am biased

I wouldn't touched mysql with a barge poll (too many issues with foreign key constraints and the likes)

Free database I would probably go with Postgres.

[Bogey]

July 5th, 2009, 11:11 pm

Rabid Dog wrote:

Well I am biased

I wouldn't touched mysql with a barge poll (too many issues with foreign key constraints and the likes)

Free database I would probably go with Postgres.

I really like to use MySQL and PHP

Foreign key constraints aren't a problem if you be specific to what it is (such as 'session_keys'), especially if you use prefixes for tables (such as 'site_keys').

[joebert]

July 6th, 2009, 12:39 am

I think Rabid Dog is refering to a feature of INNODB tables Bogey. Then again I might misunderstand what you're refering to Bogey.

MySQL does seem to be on shaky ground as of late with the creating developers jumping ship and discussions about forks going all over the place.

[Rabid Dog]

July 6th, 2009, 2:58 am

Yeah Joe I am talking about the database managed foreign key contraints only available in InnoDB tables. That being said I think mysql is a great database to learn the concepts of databases on and if you need a fast database and are not concerned about data integrity then go for it

Didn't Sun buy up MySQL or something? Prehaps they looking at shelving it to get the Derby DB up and running? Needless to say, I only use mysql if I have no other choice.

[joebert]

July 6th, 2009, 3:44 am

Sun bought MySQL, then Oracle bought Sun. Somewhere along the way lead developers started jumping ship.

[Rabid Dog]

July 6th, 2009, 3:49 am

@Bogey
I wrote a description on FK's and mysql http://www.rabiddog.co.za/tutorial.php? ... onstraints if you interested in reading more

@Joebert
Oracle bought Sun?!?!?! NO!!!!! When?

[joebert]

July 6th, 2009, 3:50 am

http://www.sun.com/third-party/global/oracle/

[Rabid Dog]

July 6th, 2009, 3:55 am

joebert wrote:

http://www.sun.com/third-party/global/oracle/

Was just reading that. How sad Hope they don't turn Sun into a money hungry machine. Think the route they were going was pretty smart.

[joebert]

July 6th, 2009, 4:18 am

I personally think Sun and Oracle had this all planned out beforehand, knowing the MySQL community wouldn't be too keen on the idea of being bought out by Oracle, whereas if Oracle buys MySQL using Sun Microsystems as a proxy it takes everyone awhile to catch on to what's happening.

Sun had been on the verge of death as a company for ages and pretty much the entire open source community loved Sun. They were the perfect proxy for Oracle to funnel all that cash through to get their hands on MySQL.

The wait between Sun buying MySQL and Oracle buying Sun was almost non-existent.

[Rabid Dog]

July 6th, 2009, 4:44 am

Interesting, pity it always has to be so under handed