944,099 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 12399
  • MySQL RSS
Aug 11th, 2005
0

Cost and pros of MYSQL

Expand Post »
I have never used MySQL and am a little unfamiliar with the pros and cons of using it. Is it true that it has no front end? I know that it is free but would like to know what the options are if we use JSP, ODBC or VB as the front end.

I am trying to see the pros and cons of using Access VS MySQL and also how much it would cost for each of them.
Thank you.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
DigitalAngel is offline Offline
1 posts
since Aug 2005
Aug 14th, 2005
0

Re: Cost and pros of MYSQL

One of the major cons of MySQL is the fact that it is open source...and thereby free of charge.
Also it is both faster and more stable than Access.
You can download it from http://dev.mysql.com/downloads/

It is true that it has no front end, but you can download a graphical front end from mySQL.com called 'MySQL Administrator'. I've never tried 'MySQL Adminstrator' so I can't really comment on that.

But there are also other freeware front ends available, like
DB Manager Pro Freeware from
http://www.dbtools.com.br/EN/downloads.php

or phpMyAdmin from
http://www.phpmyadmin.net


Using the command prompt interface of mySQL isn't really that hard, though, and the mySQL manual has pretty good syntax descriptions.
Reputation Points: 10
Solved Threads: 5
Junior Poster
madmital is offline Offline
119 posts
since Jun 2005
Nov 3rd, 2006
0

Re: Cost and pros of MYSQL

Well, none of those "admins" are what I would call a "font end" acceptable for commercial use. A secretary would be baffled.

OpenOffice.base is an ODBC program that has a wizard to generate a "reasonable" interface for a single table database. anything more complex will require a bit of work, but it has all the GUI widgets. Another one is QT designer by Trolltech. QT works alot like Access, but is GPL and more flexible.

Another DB to look into might be PostgreSQL, same idea as MySQL but preferred by GPL purists. Both are OK IMHO.
JRM
Reputation Points: 130
Solved Threads: 75
Practically a Master Poster
JRM is offline Offline
618 posts
since Oct 2006
Jan 4th, 2007
0

Re: Cost and pros of MYSQL

I would recommend mysql over access anyday, but i would like to second JRM's recommendation of postgreSQL. Here is a pretty good comparison of the two:

http://www-css.fnal.gov/dsg/external...-vs-mysql.html

What i like about postgres is it has better support for triggers and PL/sQL.
Reputation Points: 74
Solved Threads: 0
Junior Poster in Training
ses5909 is offline Offline
91 posts
since Sep 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: dataabse connectin string problem?
Next Thread in MySQL Forum Timeline: Importing Data





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC