pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
comparision chart
11+ messages / 9 participants
[nested] [flat]

* comparision chart
@ 2002-02-19 23:39 clayton cottingham <drfrog@telus.net>
  2002-02-20 05:43 ` Re: comparision chart Christopher Sawtell <csawtell@paradise.net.nz>
  0 siblings, 1 reply; 11+ messages in thread

From: clayton cottingham @ 2002-02-19 23:39 UTC (permalink / raw)
  To: pgsql-sql

hello:

im working on a comparison chart for features between different
databases

mysql postgresql db2 sqlserver oracle and sybase

im not looking for anything too granular
10000ft level totally cool

thanks!!



^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: comparision chart
  2002-02-19 23:39 comparision chart clayton cottingham <drfrog@telus.net>
@ 2002-02-20 05:43 ` Christopher Sawtell <csawtell@paradise.net.nz>
  2002-02-20 08:36   ` Re: comparision chart Johannes Grødem <johs@copyleft.no>
  2002-02-21 13:47   ` Re: comparision chart Troels Arvin <troels@arvin.dk>
  0 siblings, 2 replies; 11+ messages in thread

From: Christopher Sawtell @ 2002-02-20 05:43 UTC (permalink / raw)
  To: clayton cottingham <drfrog@telus.net>; pgsql-sql

On Wednesday 20 February 2002 12:39 pm, clayton cottingham wrote:
> hello:
>
> im working on a comparison chart for features between different
> databases
>

Open Source Projects.
==================

mysql
------

http://www.mysql.com/

Widely used as a very fast read only database. Backs _many_ web sites.
Locking at the table level only, thus update of the database best done when 
effectively in single-user-mode. Transactions implemented using external 
methods. Questionable stability under heavy load. Said to be improving.

Weird semi-open licence. See:- http://www.mysql.com/support/arrangements.html

postgresql
-----------

http://www.postgresql.org/

Somewhat slower, but absolutely solid. Many datatypes, with inheritance.
Transactions implemented using builtin methods. Fine grained locking thus 
safe multi-user read-write operations possible. Extensively used for reseach 
and beginning to used for real world financial recording. Many "add-on" 
third-party projects and language APIs. Documentation sometimes rather 
cryptic and difficult to understand, but definitely improving.

Source code available under BSD Licence.
Several very helpful mail lists. 
Several pretty well-written books available.

Commercial Offerings.
==================

db2
---

http://www-4.ibm.com/software/data/db2/

Dirived directly from the original RDBMS from IBM. Mature stable system, 
possibly suffering from compounding overbyte and creeping featureitis. Fast 
and works well. Extensively used in the commercial world. 

Free downloads and CDROMs for personal use; commercial binaries available for 
many platforms including Linux.


sqlserver oracle and sybase

I have no experience of these.

you forgot

Interbase
----------

http://www.borland.com/interbase/

SAP
---

http://www.sap.com/

Purports to be Europe's leading commercial database.
Underlying engine GPL licensed. Binaries for several platforms and source 
available for d/l and free on CDROMs. Huge range of commercial applications 
supported.
 
Infomix.
--------

http://www.informix.com/     which forwards to:-
http://www-4.ibm.com/software/data/informix/

IBM have recently bought Infomix to both extend their customer base and for 
its technical features. Commercial binaries available for many platforms, 
free for personal educational use on Linux. Truly extensive, well written, 
but chaotically organised, documentation. Works very well. Common distant 
ancestor with postgresql.

HTH

--
Sincerely etc.,
Christopher Sawtell.



^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: comparision chart
  2002-02-19 23:39 comparision chart clayton cottingham <drfrog@telus.net>
  2002-02-20 05:43 ` Re: comparision chart Christopher Sawtell <csawtell@paradise.net.nz>
@ 2002-02-20 08:36   ` Johannes Grødem <johs@copyleft.no>
  2002-02-20 08:59     ` Re: comparision chart Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  2002-02-22 16:00     ` Re: comparision chart Roberto Mello <rmello@cc.usu.edu>
  1 sibling, 2 replies; 11+ messages in thread

From: Johannes Grødem @ 2002-02-20 08:36 UTC (permalink / raw)
  To: pgsql-sql

* Christopher Sawtell <csawtell@paradise.net.nz>:

> Widely used as a very fast read only database. Backs _many_ web sites.
> Locking at the table level only, thus update of the database best done when 
> effectively in single-user-mode. Transactions implemented using external 
> methods.

The version with InnoDB has row-level locking and transactions.  (And
is supposedly very fast, unlike the BDB-tables.)

http://www.innodb.com/

-- 
johs



^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: comparision chart
  2002-02-19 23:39 comparision chart clayton cottingham <drfrog@telus.net>
  2002-02-20 05:43 ` Re: comparision chart Christopher Sawtell <csawtell@paradise.net.nz>
  2002-02-20 08:36   ` Re: comparision chart Johannes Grødem <johs@copyleft.no>
@ 2002-02-20 08:59     ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  2002-02-20 17:28       ` Re: comparision chart clayton cottingham <drfrog@telus.net>
  1 sibling, 1 reply; 11+ messages in thread

From: Christopher Kings-Lynne @ 2002-02-20 08:59 UTC (permalink / raw)
  To: Johannes Grodem <johs@copyleft.no>; pgsql-sql

> > Widely used as a very fast read only database. Backs _many_ web sites.
> > Locking at the table level only, thus update of the database
> best done when
> > effectively in single-user-mode. Transactions implemented using
> external
> > methods.
>
> The version with InnoDB has row-level locking and transactions.  (And
> is supposedly very fast, unlike the BDB-tables.)

I love how they still call it 'mysql' instead of 'sql wrapper around someone
else's better backend library'...

OK, so they have tables with transactions - so now what happens if you do
this?

* begin a transaction
* do a select for update that joins two tables, one with transactions and
one without
* another connection deletes some rows from the transaction-less table out
from under you
* update the transaction-less table
* update the table with transactions
* drop the table with transactions
* rollback the transaction

All sorts of crazy fun!!!  It's insane!

(Just my 2c - let's not start another flame war...)

Chris




^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: comparision chart
  2002-02-19 23:39 comparision chart clayton cottingham <drfrog@telus.net>
  2002-02-20 05:43 ` Re: comparision chart Christopher Sawtell <csawtell@paradise.net.nz>
  2002-02-20 08:36   ` Re: comparision chart Johannes Grødem <johs@copyleft.no>
  2002-02-20 08:59     ` Re: comparision chart Christopher Kings-Lynne <chriskl@familyhealth.com.au>
@ 2002-02-20 17:28       ` clayton cottingham <drfrog@telus.net>
  2002-02-20 23:32         ` Re: comparision chart Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 11+ messages in thread

From: clayton cottingham @ 2002-02-20 17:28 UTC (permalink / raw)
  To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>; +Cc: Johannes Grodem <johs@copyleft.no>; pgsql-sql


thanks for all your help all,

i guess i wasnt so clear on what i mlooking for, based on your replies.

im looking for something like:


Database	MySQL	Postgresql	Oracle	
Transactions	Partial	Yes	Yes			
RowLock	No	Yes	Yes			
Constraints	No	Partial	Yes			
Programmable	Partial	Yes	Yes			
Secure	Yes	Yes	Yes			
FailSafe	No	Yes	Yes			
Hotback	No 	No	Yes			



but i want the features list to be succinct enough 
to hand off to clients, nothing too in depth but enough that a 
layperson could discern useful features etc 

so i guess what im looking for is:
good keywords for global level features and
the yes or no's for each database, 

i have been searching the net and ive found a few 
but nothing to relevant, usually the veriosn s are out of date.

so for totally approaching off topic status!!



^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: comparision chart
  2002-02-19 23:39 comparision chart clayton cottingham <drfrog@telus.net>
  2002-02-20 05:43 ` Re: comparision chart Christopher Sawtell <csawtell@paradise.net.nz>
  2002-02-20 08:36   ` Re: comparision chart Johannes Grødem <johs@copyleft.no>
  2002-02-20 08:59     ` Re: comparision chart Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  2002-02-20 17:28       ` Re: comparision chart clayton cottingham <drfrog@telus.net>
@ 2002-02-20 23:32         ` Josh Berkus <josh@agliodbs.com>
  2002-02-20 23:57           ` Re: comparision chart clayton cottingham <drfrog@telus.net>
  2002-02-21 14:14           ` Re: comparision chart Brian Knox <laotse@aol.net>
  0 siblings, 2 replies; 11+ messages in thread

From: Josh Berkus @ 2002-02-20 23:32 UTC (permalink / raw)
  To: clayton cottingham <drfrog@telus.net>; +Cc: pgsql-sql

Clayton,

> 
> Database	MySQL	Postgresql	Oracle	
> Transactions	Partial	Yes	Yes			
> RowLock	No	Yes	Yes			
> Constraints	No	Partial	Yes			
> Programmable	Partial	Yes	Yes			
> Secure	Yes	Yes	Yes			
> FailSafe	No	Yes	Yes			
> Hotback	No 	No	Yes			

SQL-92 Compliance   50%    85%    75%  (very rough estimate)

Regarding your rating of Postgres, what do you mean by "partial"
 support of constraints?  And what is "hotBack"?

-Josh 


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco



^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: comparision chart
  2002-02-19 23:39 comparision chart clayton cottingham <drfrog@telus.net>
  2002-02-20 05:43 ` Re: comparision chart Christopher Sawtell <csawtell@paradise.net.nz>
  2002-02-20 08:36   ` Re: comparision chart Johannes Grødem <johs@copyleft.no>
  2002-02-20 08:59     ` Re: comparision chart Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  2002-02-20 17:28       ` Re: comparision chart clayton cottingham <drfrog@telus.net>
  2002-02-20 23:32         ` Re: comparision chart Josh Berkus <josh@agliodbs.com>
@ 2002-02-20 23:57           ` clayton cottingham <drfrog@telus.net>
  1 sibling, 0 replies; 11+ messages in thread

From: clayton cottingham @ 2002-02-20 23:57 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-sql

Josh Berkus wrote:
> 
> Clayton,
> 
> >
> > Database      MySQL   Postgresql      Oracle
> > Transactions  Partial Yes     Yes
> > RowLock       No      Yes     Yes
> > Constraints   No      Partial Yes
> > Programmable  Partial Yes     Yes
> > Secure        Yes     Yes     Yes
> > FailSafe      No      Yes     Yes
> > Hotback       No      No      Yes
> 
> SQL-92 Compliance   50%    85%    75%  (very rough estimate)
> 
> Regarding your rating of Postgres, what do you mean by "partial"
>  support of constraints?  And what is "hotBack"?
> 


sorry i guess i wasnt clear
i grabbed that from another site, 
and i got confused by some of the terms!

thats why i was looking for some insight from the list!!


im glad to know someone else doesnt know what that mean

ttfn

> -Josh
> 
> ______AGLIO DATABASE SOLUTIONS___________________________
>                                        Josh Berkus
>   Complete information technology      josh@agliodbs.com
>    and data management solutions       (415) 565-7293
>   for law firms, small businesses        fax 621-2533
>     and non-profit organizations.      San Francisco



^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: comparision chart
  2002-02-19 23:39 comparision chart clayton cottingham <drfrog@telus.net>
  2002-02-20 05:43 ` Re: comparision chart Christopher Sawtell <csawtell@paradise.net.nz>
  2002-02-20 08:36   ` Re: comparision chart Johannes Grødem <johs@copyleft.no>
  2002-02-20 08:59     ` Re: comparision chart Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  2002-02-20 17:28       ` Re: comparision chart clayton cottingham <drfrog@telus.net>
  2002-02-20 23:32         ` Re: comparision chart Josh Berkus <josh@agliodbs.com>
@ 2002-02-21 14:14           ` Brian Knox <laotse@aol.net>
  1 sibling, 0 replies; 11+ messages in thread

From: Brian Knox @ 2002-02-21 14:14 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: clayton cottingham <drfrog@telus.net>; pgsql-sql

What is the definition of 'hotback' in this case? I thought that you could
run pg_dump to dump a database while it was being actively used... could
you give more information as to why you say that postgres does not support
hot backups?

On Wed, 20 Feb 2002, Josh Berkus wrote:

> Clayton,
>
> >
> > Database	MySQL	Postgresql	Oracle
> > Transactions	Partial	Yes	Yes
> > RowLock	No	Yes	Yes
> > Constraints	No	Partial	Yes
> > Programmable	Partial	Yes	Yes
> > Secure	Yes	Yes	Yes
> > FailSafe	No	Yes	Yes
> > Hotback	No 	No	Yes
>
> SQL-92 Compliance   50%    85%    75%  (very rough estimate)
>
> Regarding your rating of Postgres, what do you mean by "partial"
>  support of constraints?  And what is "hotBack"?
>
> -Josh
>
>
> ______AGLIO DATABASE SOLUTIONS___________________________
>                                        Josh Berkus
>   Complete information technology      josh@agliodbs.com
>    and data management solutions       (415) 565-7293
>   for law firms, small businesses        fax 621-2533
>     and non-profit organizations.      San Francisco
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>




^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: comparision chart
  2002-02-19 23:39 comparision chart clayton cottingham <drfrog@telus.net>
  2002-02-20 05:43 ` Re: comparision chart Christopher Sawtell <csawtell@paradise.net.nz>
  2002-02-20 08:36   ` Re: comparision chart Johannes Grødem <johs@copyleft.no>
@ 2002-02-22 16:00     ` Roberto Mello <rmello@cc.usu.edu>
  1 sibling, 0 replies; 11+ messages in thread

From: Roberto Mello @ 2002-02-22 16:00 UTC (permalink / raw)
  To: ; +Cc: pgsql-sql

On Wed, Feb 20, 2002 at 09:36:12AM +0100, Johannes Gr?dem wrote:
> 
> The version with InnoDB has row-level locking and transactions.  (And
> is supposedly very fast, unlike the BDB-tables.)

And the InnoDB implementors seem to have as much a distorted mind as the
rest of the MySQL Team:

"Exchange on MySQL and Innobase: Are They DBMSs, Let Alone Relational?"
http://www.dbdebunk.com/

One of the "pearls" by Heikki Tuuri from Innobase:

"This is semantics, but I think Codd and Date in the 70s meant by a
relational database something which has a relational query language. Thus
any database which has a query language somewhat similar to the relational
algebra or SQL can be called a relational database."

Should tell you something about what kind of product they are building.

-Roberto

-- 
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
  Roberto Mello - Computer Science, USU - http://www.brasileiro.net/ 
       http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer    



^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: comparision chart
  2002-02-19 23:39 comparision chart clayton cottingham <drfrog@telus.net>
  2002-02-20 05:43 ` Re: comparision chart Christopher Sawtell <csawtell@paradise.net.nz>
@ 2002-02-21 13:47   ` Troels Arvin <troels@arvin.dk>
  1 sibling, 0 replies; 11+ messages in thread

From: Troels Arvin @ 2002-02-21 13:47 UTC (permalink / raw)
  To: pgsql-sql

On Wed, 20 Feb 2002 07:08:46 +0100, "Christopher Sawtell"
<csawtell@paradise.net.nz> wrote:

> mysql
> ------
[...]

MySQL has a well-documented replication system (which also works well, I
hear). Simple one-way replication seems easy to set up.

> postgresql
> -----------

There doesn't seem to be a consensus about how to replicate PostgreSQL
databases.


(Normally, I don't advocate MySQL before PostgreSQL, but as this
discussion shows, there _are_ areas where MySQL is in front.)

-- 
Greetings from Troels Arvin, Copenhagen, Denmark



^ permalink  raw  reply  [nested|flat] 11+ messages in thread

* Re: comparision chart
@ 2002-02-22 23:47 Mark kirkwood <markir@slingshot.co.nz>
  0 siblings, 0 replies; 11+ messages in thread

From: Mark kirkwood @ 2002-02-22 23:47 UTC (permalink / raw)
  To: clayton cottingham <drfrog@telus.net>; Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-sql


Previously...
>
> Regarding your rating of Postgres, what do you mean by "partial"
>  support of constraints?  And what is "hotBack"?
> 

The confusing terms probably my fault - (Someone probably saw an old
posting of mine) - apologies in the time travelled sense...

I think partial constraint meant that there was "create" but no
"alter/drop/disable/enable" for them (This was circa Pg 7.0.0).

And I seem to recall thinking about a hotbackup in the sense of :
i) able to back up the db while it is running (and)
ii) able to use use the transaction logs to "catch up" after a media
failure (assuming the logs are backed up somehow too)

Clearly most of the crowd can do i), but fewer do ii) - mainly the
commercial ones.

I am less sure these days the ii) is so important. Many folks seem to
manage by means of using i) combined with replication or fault tolerance
at the os or hardware level (but I am ranging off the topic here...)

best wishes for the chart

regards

Mark

  




^ permalink  raw  reply  [nested|flat] 11+ messages in thread


end of thread, other threads:[~2002-02-22 23:47 UTC | newest]

Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-02-19 23:39 comparision chart clayton cottingham <drfrog@telus.net>
2002-02-20 05:43 ` Christopher Sawtell <csawtell@paradise.net.nz>
2002-02-20 08:36   ` Johannes Grødem <johs@copyleft.no>
2002-02-20 08:59     ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2002-02-20 17:28       ` clayton cottingham <drfrog@telus.net>
2002-02-20 23:32         ` Josh Berkus <josh@agliodbs.com>
2002-02-20 23:57           ` clayton cottingham <drfrog@telus.net>
2002-02-21 14:14           ` Brian Knox <laotse@aol.net>
2002-02-22 16:00     ` Roberto Mello <rmello@cc.usu.edu>
2002-02-21 13:47   ` Troels Arvin <troels@arvin.dk>
2002-02-22 23:47 Re: comparision chart Mark kirkwood <markir@slingshot.co.nz>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox