how to go around mysql

marianne

Registered User.
Local time
Today, 07:27
Joined
Mar 26, 2009
Messages
327
i have downloaded the three requisites Banana, where to open the IDE to make tables?
 
Well, the default package does not have any IDE. The only client that comes included is a command line client (e.g. just like the good old DOS days).

However, if you insist on a GUI environment, you can consider getting MySQL's GUI Tools which is a separate download and free to use or pay a small money for license to several excellent commercial front-end such as Navi-Cat or Toad.

You also may want to look into MySQL Workbench for the ERD (e.g. Access's Relationship Windows).
 
I see. how about ms sql? what version would you advice to me?
 
There's express edition which is free to use, with a 2 GB data capacity cap, and cap of one processor, if my memory serves. You also can buy a developer edition to get all features you can use for developing for $50. For standard or enterprise version, I think it's something like $2,000 per CPU or something like that.
 
why is the developer edition far way cheaper than the standard or enterprise edition? I was planning to have the developer edition thinking it has all the features I need.
 
Because as the name says, it's for developer's use. You cannot use it for production use. It's convenient for someone who may be contracted to develop databases but the company still has to pay the full cost for standard or enterprise licensing.

Just to be sure; this is by no means abberant. Oracle and IBM charges just as much, if not more, for their products, though Oracle provide a free developer edition (with same restrictions). I'm not sure about the IBM's licensing terms, but wouldn't be surprised if the terms were quite similar (e.g. a free copy of developer edition or substantially reduced fee for the same edition).

MySQL, PostgreSQL and Firebird are free because they're open source. I don't know about the other two, but in case of MySQL, one can elect to pay $500/year for "enterprise service" which provides several additional benefits and support whereas the free edition is basically a DIY solution; it's expected that you would learn to administer the server on your own, perhaps with some help of community resources. Of course, this may not be appropriate for mission critical applications where business make or lose money over its working or not working. In that case, enterprise editions (for any products you may choose) start to make more sense.

I work for a project management company which basically provide the service of developing & maintaining a business solution using SQL Server as backend and Access as front end, and that's expected that the clients pay for such services. Also, it's not unusual for a DBA (for any products) to make more than $50,000 a year. Hopefully this help illustrate the true cost of maintaining a full-on RDBMS and *why* the business has to support it. Fortunately, any business has a large range to choose how much they can justify spending on from $0 (well, that's imaginary since you still have to pay someone to administer but $0 for software licensing & hardware acquisition is mighty nice) to prices well into hundred thousand dollars.

I hope that helps.
 
so what would you advice me. I want to get all the features aside from being the developer? should it be enterprise or standard or professional?
 

Users who are viewing this thread

Back
Top Bottom