always wondered

  • mindfullsilence
  • Professor
  • Professor
  • User avatar
  • Posts: 854

Post 3+ Months Ago

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 :wink:
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • spork
  • Brewmaster
  • Silver Member
  • User avatar
  • Posts: 6250
  • Loc: Seattle, WA

Post 3+ Months Ago

Whatever language you plan on building the rest of the site with.
  • Rabid Dog
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

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
  • Genius
  • Genius
  • Bogey
  • Posts: 8388
  • Loc: USA

Post 3+ Months Ago

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
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13502
  • Loc: Florida

Post 3+ Months Ago

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
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

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
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13502
  • Loc: Florida

Post 3+ Months Ago

Sun bought MySQL, then Oracle bought Sun. Somewhere along the way lead developers started jumping ship.
  • Rabid Dog
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

@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
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13502
  • Loc: Florida

Post 3+ Months Ago

http://www.sun.com/third-party/global/oracle/
  • Rabid Dog
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

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
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13502
  • Loc: Florida

Post 3+ Months Ago

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
  • Web Master
  • Web Master
  • User avatar
  • Posts: 3245
  • Loc: South Africa

Post 3+ Months Ago

Interesting, pity it always has to be so under handed

Post Information

  • Total Posts in this topic: 12 posts
  • Users browsing this forum: No registered users and 92 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.