MySQL comparison ... - Mailing list pgsql-hackers

From Dmitry Samersoff
Subject MySQL comparison ...
Date
Msg-id XFMail.990702122733.dms@wplus.net
Whole thread Raw
List 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 by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: Optimization FAQ ?
Next
From: Thomas Lockhart
Date:
Subject: First 6.5 RPMs