Hi

I plan to switch from an old database (paradox) to a new one.
I need security, speed and low cost.

Is MySQL the better choice ? Why ? Why not ?
What is the best operating system for install and configure the server
Windows ? Linux (which distribution in this case ?)

Thanks a lot to give me your feed-back.

Bye

On Mon, 30 Oct 2006 19:11:00 +0100, Jazzoroastre wrote:

MySQL is an excellent choice. BUT ...
So is Oracle, Microsoft SQL Server, and IBM's DB2.

If you really get down to it, they are all about the same. Pick one.

If your total data is less than 4 GB, they all have a free version. Some
are free beyond that limit. So the price is not an issue. Pick one.

All the free ones are supported by the community. They can all be made
reasonably secure as long as you don't use stoopid programming techniques
that allow SQL Injection. Pick one.


Do you WANT to use Linux? Then you eliminate SQL Server. Otherwise pick
one.

If you want to use Linux, choose a 'mainstream' version such as Debian,
Fedora or SuSE for the free versions or RedHat or SuSE Enterprise for the
'paid support' versions. It's easier to find a supporting community for
these. But ... pick one.



No matter what you pick for database and operating system, you need to get
familiar with it. This will take some effort and will need you to ask
questions in one community or other.

Once you are familiar with it, all the others will have 'problems'. You
will be able to espouse the benefits of yours over all the others without
any need to acknowledge that they all do the same basic job with slightly
different syntax. (This is called 'religion'.)

Bottom line is: pick one.
Chose based on what your friends are using OR who you want to be your
friends.



My personal preference is Oracle. Reasons:
- It's very configurable;
- It works on Linux and Windows;
- It's got good security (as good as any);
- I've used it for years more than the others;
- All my friends use it;
- Just 'cause.

--
Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com)
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

HansF wrote on 30.10.2006 19:38:
And don't forget PostgreSQL. In my opinion a far better choice in the OpenSource
world than MySQL. The whole transaction handling and implementation of
relational concepts is simply much better than MySQL (although MySQL is catching
up).

Thomas

On Mon, 30 Oct 2006 20:05:51 +0100, Thomas Kellerer wrote:

LOL ... here we go ...

--
Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com)
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

A long time ago, in a galaxy far, far away, Thomas Kellerer <TAAXADSCBIXW (AT) spammotel (DOT) com> wrote:
MySQL(tm) is "catching up" in the sense that there are fewer vital
RDBMS features that they are missing. And since the set of vital
RDBMS features isn't actually growing, that means they might actually
get there some day.

Compare:
<http://sql-info.de/mysql/gotchas.html>
<http://sql-info.de/postgresql/postgresql-gotchas.html>

On Linux, it ought to be a no-brainer; all the major options will be
trivially installable via your favorite package management system.

You want security? PostgreSQL is the only one of the lot that offers
network support that has no network security exploits out of the box,
because remote access is, by default, rejected.

You want speed? Pretty much anything moderately modern will be
quicker than Paradox. PostgreSQL, MySQL(tm), SQLite, ... PostgreSQL
keeps getting faster each time a version comes out. It was pretty
slow back in the 6.5 days, but that was a long time ago.

Low cost? That puts you between PostgreSQL and SQLite, because with
them you don't have to wonder whether or not you owe MySQL AB $595 per
server per year.
--
let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;;
http://cbbrowne.com/info/slony.html
Build a man a fire and he will be warm for a day.
Set a man on fire and he will be warm for the rest of his life.

On 31.10.2006 03:34 Christopher Browne wrote:
The second one should be
<http://sql-info.de/postgresql/postgres-gotchas.html>