The FreeBSD Diary

The FreeBSD Diary (TM)

Providing practical examples since 1998

If you buy from Amazon USA, please support us by using this link.
[ HOME | TOPICS | INDEX | WEB RESOURCES | BOOKS | CONTRIBUTE | SEARCH | FEEDBACK | FAQ | FORUMS ]
Article Feedback - scp tricks
 New Topic  |  Go to Top  |  Go to Topic  |  Search  |  Log In   Newer Topic  |  Older Topic 
 Good analysis
Author: Murray Taylor 
Date:   12-03-03 23:51

We are currently uing MySQL for a production database and I have been trying to beat in the developers the use of the similar EXPLAIN there...

FWIW MySQL 4 now has subselects... and I didnt know that PostgreSQL had the cascading stuff

We are about to commence a systems review for the next major version and this article will be grist for the mill.

Thanks

Reply To This Message
 
 Re: Good analysis
Author: Dan Langille 
Date:   15-03-03 13:43

I used mySQL for a long time. I stopped using mySQL for FreshPorts because mySQL did not support stored procedures, triggers, and relational integrity items such as foreign keys. That is why I went to PostgreSQL which has these items.

Regardless of whether or not mySQL has caught up, I see no reason to move back.

Reply To This Message
 Forum List  |  Threaded View   Newer Topic  |  Older Topic 


 Forum List  |  Need a Login? Register Here 
 User Login
 User Name:
 Password:
 Remember my login:
   
 Forgot Your Password?
Enter your email address or user name below and a new password will be sent to the email address associated with your profile.
How to get the most out of the forum

phorum.org