MySQL comparison ...

Поиск
Список
Период
Сортировка
От Dmitry Samersoff
Тема MySQL comparison ...
Дата
Msg-id XFMail.990702122733.dms@wplus.net
обсуждение исходный текст
Список pgsql-hackers
Too many questions about adding MySQL comparison to 
Postgres web page received.

Really MySQL is closest product to Postgres 
from marketing point of view

IMHO, It's need to add bold red comment about MySQL, at least:
MySQL is not RDBMS, because it miss functionality supported by all other
databases included in comparison. 

This is the quote from MySQL on-line documentation:
 5.3 Functionality missing from MySQL               5.3.1 Sub-selects               5.3.2 SELECT INTO TABLE
 5.3.3 Transactions               5.3.4 Stored procedures and triggers               5.3.5 Foreign Keys
  5.3.5.1 Reasons NOT to use foreign keys               5.3.6 Views               5.3.7 `--' as the start of a comment
       
 

This is my variant of comparison, (based on the MySQL documentation) 

FreeSource: Yes
AnySource:  yes
Online documentation: yes
License:   free for uncomercial use

Client-server: yes
Multi-threaded: yes
Shared SQl cache: ?
Row-level locking: no
Online backup: yes
Online recovery: no
Parallel Query: no
Read only db: no
Multiple Index type: no?
Unique indices: yes
Multicolumn indices: yes

SQL92: no
ODBC: yes

C api: yes
C++ api: yes
Java: yes
Phyton: yes
Perl 4: ?
Perl 5: yes
Tcl: yes

FreeBSD 3.x: yes
NetBSD: yes
Linux 2.0+ : with LinuxThreads
Linux Aplha: ?
Linux Sparc: ?
SGI Irix: yes
Solaris Sparc: yes
Solaris x86: yes
SunOS 4: with MIT
HP/UX: yes
BSDI: yes
DG-UX: no
AIX: yes
Nextstep: no
Ultrix 4: no
OSF1: no? (Tru64 ???)
SVR4.2: ?
SCO open server: with FSU threads
OS/2: yes
Win32: yes (shareware)
Novell Netware: no
MacOS: no 

SCO UW7: yes

* some of them require MIT threads package




---
Dmitry Samersoff, dms@wplus.net, ICQ:3161705
http://devnull.wplus.net
* There will come soft rains ...


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Hiroshi Inoue"
Дата:
Сообщение: Optimization FAQ ?
Следующее
От: Thomas Lockhart
Дата:
Сообщение: First 6.5 RPMs