Two Laptop Bag*
The moose likes JDBC and the fly likes About MySql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "About MySql " Watch "About MySql " New topic
Author

About MySql

Rajesh Savitri
Greenhorn

Joined: Sep 13, 2002
Posts: 21
does mysql support relationship between entities? Whether it can use in production like banking projects? If not which open source RDBMS is the best for the production of like banking and insurance applications?
Andres Gonzalez
Ranch Hand

Joined: Nov 27, 2001
Posts: 1561
you mean, like implementing an entity relationship diagram (ERD).
Yep, it does support that.
However, it doesn't support stored procedures, yet. Version 4 of MySQL plans to support it.
PostGreSQL is another option. It does support stored procedures.
hope it helps


I'm not going to be a Rock Star. I'm going to be a LEGEND! --Freddie Mercury
Rajesh Savitri
Greenhorn

Joined: Sep 13, 2002
Posts: 21
Hi Andres,
Thanks for the reply, Let me make my questions more clear.
I want to choose an open source RDBMS that could be used for a medium level banking project. So I am looking for a ANSI-SQL complaint RDBMS server which is Open Source. I was suggested three choices and I have some questions about them:
1.MySQL - Is it a RDBMS. Does it support Foreign Key Relationship?
2.PostgreSQL
3.InterBase - Is there much activity happening in Interbase Will it have a long life? Is ther good documentations and help around. Do they have good free JDBC Drivers?.
Can some one help me with this? Thanks in Advance.
Andres Gonzalez
Ranch Hand

Joined: Nov 27, 2001
Posts: 1561
Originally posted by Rajesh Savitri:
1.MySQL - Is it a RDBMS. Does it support Foreign Key Relationship?

Yep, it is a RDBMS. But it does NOT support foreign keys. BUT, check this:
http://www.innodb.com/
if you use something like innodb, you can add this feature to mysql.

2.PostgreSQL

I'm not quite sure but i think it does support foreign keys. you'll have to do some research.

3.InterBase - Is there much activity happening in Interbase Will it have a long life? Is ther good documentations and help around. Do they have good free JDBC Drivers?.

I'm honest with you. I know nothing about interbase.
I'd go with MySQL. My personal opinion though.
cheers
Rajesh Savitri
Greenhorn

Joined: Sep 13, 2002
Posts: 21
Hi Andres,
Thanks for your reply
Rajesh
Sudharsan Govindarajan
Ranch Hand

Joined: Jul 03, 2002
Posts: 319
Andres!
Are you sure mySQL does not support foreign keys? I have used foreign keys in one of my DB projects with mySQL 3.23.
Rajesh!
What would be ur platform for the Banking project. PostgreSQL is not available for Windows platforms..
-sudharsan
Rajesh Savitri
Greenhorn

Joined: Sep 13, 2002
Posts: 21
My Application is for Windows platform. Are you sure that PostgreSQL is not availble for windows.
I found that PostgreSQL can be installed in Windows using the cygwin tool. Infact the CygWin comes with the PostgreSQL. But I haven't installed it yet. The reason for me to align towards PostgreSQL is 'cos of the very liberal lisecne policy.
Is it true that if I distribute the MySQL along with my product my product my product also becomes opensource and there by free, unless I buy the commercial liscence. OfCourse I don't want to give away my product as free.
If true can I distribute my product and MySQL DB in seperate CD to the client and avoid the Liscence binding? Pls Clarify me. Thanks in advance.
Sudharsan Govindarajan
Ranch Hand

Joined: Jul 03, 2002
Posts: 319
Rajesh!
This is an extract from the GNU General Public License.
When we speak of free software, we are referring to freedom, not price. Our General Public Licenses are designed to make sure that you have the freedom to distribute copies of free software (and charge for this service if you wish), that you receive source code or can get it if you want it, that you can change the software or use pieces of it in new free programs; and that you know you can do these things.

Hope this clears ur doubt about pricing.
As far as i know, both postgreSQL and mySQL are covered by similar type of licensing..
-sudharsan
Juanjo Bazan
Ranch Hand

Joined: Feb 04, 2002
Posts: 231
Originally posted by Sudharsan G'rajan:

Are you sure mySQL does not support foreign keys? I have used foreign keys in one of my DB projects with mySQL 3.23.

mySQL (up to v3.2x) do support foreing keys, but the FOREIGN KEY syntax does nothing.
It exists only for compatibility with other SQL vendors' CREATE TABLE commands.
As they say, "MySQL only supports these clauses because some applications require them to exist (regardless of whether or not they work)."
They are planning to extend the FOREIGN KEY implementation from v4 on..
Andres Gonzalez
Ranch Hand

Joined: Nov 27, 2001
Posts: 1561
Juanjo is right.
also read this:
http://www.mysql.com/doc/en/example-Foreign_keys.html

The only thing MySQL currently doesn't do (in type types other than InnoDB), is CHECK to make sure that the keys you use really exist in the table(s) you're referencing and it doesn't automatically delete rows from a table with a foreign key definition.
Sudharsan Govindarajan
Ranch Hand

Joined: Jul 03, 2002
Posts: 319
Yup! Andres and Juanjo are right. I've creted the DB and never tested it from the back-end. Thanks for pointing me to a potential bug.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: About MySql