Re: [ossig] CA open-sources Ingres database - News & Technology- CNETAsia

["Raja Iskandar Shah" <ris.riscniaga@xxxxxxxxxxx>]

i have got on my windows xp notebook:

1. mysql (is it really free ??) - no stored procedures, does not migrate
ms-sql / oracle databases very well, does not comply to acid / sql-99.

2. msde (a scaled-down ?? version of ms-sql) - no visual admin tools,
performance limitations for more than 5 concurrent users. need to pay
for ms-sql to overcome these limitations.

3. ms-jet (aka ms-access) - only for standalone desktop applications,
poor performance over networks.

4. firebird - not found a reason to complain. works well with jsp, php
and any of the ms development tools.

i have not got postgresql. because: 
"
Client

It is possible to compile the libpq C library, psql, and other
interfaces and client applications to run on MS Windows platforms. In
this case, the client is running on MS Windows, and communicates via
TCP/IP to a server running on one of our supported Unix platforms. A
file win32.mak is included in the distribution for making a Win32 libpq
library and psql. PostgreSQL also communicates with ODBC clients.

Server

The database server can run on Windows NT and Win2k using Cygwin, the
Cygnus Unix/NT porting library. See pgsql/doc/FAQ_MSWIN in the
distribution or the MS Windows FAQ at
http://www.PostgreSQL.org/docs/faqs/text/FAQ_MSWIN.

A native port to MS Win NT/2000/XP is currently being worked on. For
more details on the current status of PostgreSQL on Windows see
http://techdocs.postgresql.org/guides/Windows and
http://momjian.postgresql.org/main/writings/pgsql/win32.html.

"




Raja Iskandar Shah
http://riscniaga.netfirms.com

----- Original Message -----
From: Lim Kheng Huat <khenghuatlim@time.net.my>
Date: Wednesday, May 26, 2004 1:37 pm
Subject: Re: [ossig] CA open-sources Ingres database - News & Technology
- CNETAsia

> hi,
> Yup, Imaran is right, start from MySql 4.1 supported all form of 
> subquery. http://dev.mysql.com/doc/mysql/en/Subqueries.html
> 
> About store procedure only available on version 5
> http://dev.mysql.com/doc/mysql/en/Stored_Procedures.html
> Bottom of heart, MySql is the best among the open databases.
> 
> Current production is MySQL 4.0
> 
> 
> 
> 
> Imran William Smith wrote:
> 
> > Lim Kheng Huat wrote:
> >
> >> hi all,
> >> Does anyone know which database more reliable, better 
> performance 
> >> (Mysql, Postgresql or Ingres) ?
> >> I know that current mysql version lack of features such as sub-
> query, 
> >> store-procedure (i guess will improve it all in version 5) 
> Anything 
> >> to share?
> >
> >
> > I believe MySQL has had subqueries for a long time now, and I
> > think they might have stored procedures.  They also have clustering
> > in their latest version.  In terms of adding features, MySQL seems
> > fastest.  According to the speech given by David Axmark at
> > FOSSCON2003, MySQL has never had any significant complaints 
> about data 
> > loss that could be attributed to the database (as long as you 
> use 
> > stable, not alpha or beta versions).
> >
> > Imran
> >
> 
> 
> 
> ---------------------------------------------------------
> To unsubscribe: send mail to ossig-request@mncc.com.my
> with "unsubscribe ossig" in the body of the message
> 
> 
begin:vcard
n:Shah;Raja Iskandar
fn:Raja Iskandar Shah
url:http://riscniaga.netfirms.com
org:RISC Niaga Enterprise;
version:2.1
email;internet:ris.riscniaga@time.net.my
end:vcard