by
> >Does anyone have the idea about MySQL and Sybase SAE?
> >I basically want to have a SQL server running on my Linux system and allow
> >other people to access it from MS access through network. Ideally, this SQL
> >server is able to talk to my Web server. The people in client site is able
> >to access my SQL server using their Web browsers. Do the MySQL or Sybase SAE
> >meet this requirement? If yes, which one is better? I would appreciate any
> >helps on this.
> This doesn't answer your question, but I know that PostgreSQL is
> well-supported both by Linux and Apache, and has a free Win32 ODBC
> driver. See www.postgresql.org.
answering the question with either option.
- Sybase is supported by a sizable multinational company, which may be
of value.
- MySQL is probably cheaper.
- MySQL trims off features that are difficult to "do fast."
- Sybase provides a much nearer approximation to ANSI SQL than does
MySQL
- MySQL eschews transactions, nested selects, and (probably?) locking.
- As a result of the t* of features, it is reasonably likely
that MySQL will be faster than Sybase. But it won't be as robust.
In contrast, PostgreSQL does some stuff that neither Sybase nor MySQL
do in the area of object/relational database functionality. It adds
the ability to do temp*queries. It's probably slower than either,
and probably falls in between the two in terms of reliability.
If you don't know what some of these features are, either they may be
irrelevant to you (not unlikely), or you may need to study up more to
understand what you *do* need...
--
"MSDOS didn't get as bad as it is overnight -- it took over ten years