dbTalk Databases Forums  

Differences between databases

comp.databases comp.databases


Discuss Differences between databases in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Brian P. Giroux
 
Posts: n/a

Default Differences between databases - 07-20-2004 , 10:19 AM






Is there a FAQ that explains the differences between PostgreSQL, MySQL,
Oracle, and MS-Access?

Thanks for your direction.

--
Brian P. Giroux

Reply With Quote
  #2  
Old   
Brian P. Giroux
 
Posts: n/a

Default Re: Differences between databases - 07-20-2004 , 07:06 PM






Noel <no.spam (AT) thank (DOT) you> wrote in news:k67rf09idkomuvsftptarl42he1k4c88jq@
4ax.com:

Quote:
On 20 Jul 2004 15:19:07 GMT, "Brian P. Giroux" <bpg (AT) onlink (DOT) net> wrote:

Is there a FAQ that explains the differences between PostgreSQL, MySQL,
Oracle, and MS-Access?

I can't think of any, but I will give you a good start. MS Access is
a desktop database, and not a DBMS, so that is not really comparable
to the others. Oracle and MySQL are commercial products, PostgreSQL
is open-source, like the other open-source DBMS, Firebird. You may
find individual comparisons between say Oracle and the other two, but
you will find it difficult to find all in the one place.
MySQL is commercial? On their website < http://www.mysql.com/ > they say
"The world's most popular open source database", and they say they are GPL,
and they are on SourceForge. Is there another MySQL, or are only some
modules of it GPL?

--
Brian P. Giroux


Reply With Quote
  #3  
Old   
Christopher Browne
 
Posts: n/a

Default Re: Differences between databases - 07-20-2004 , 11:52 PM



A long time ago, in a galaxy far, far away, "Brian P. Giroux" <bpg (AT) onlink (DOT) net> wrote:
Quote:
Noel <no.spam (AT) thank (DOT) you> wrote in news:k67rf09idkomuvsftptarl42he1k4c88jq@
4ax.com:

On 20 Jul 2004 15:19:07 GMT, "Brian P. Giroux" <bpg (AT) onlink (DOT) net> wrote:

Is there a FAQ that explains the differences between PostgreSQL, MySQL,
Oracle, and MS-Access?

I can't think of any, but I will give you a good start. MS Access is
a desktop database, and not a DBMS, so that is not really comparable
to the others. Oracle and MySQL are commercial products, PostgreSQL
is open-source, like the other open-source DBMS, Firebird. You may
find individual comparisons between say Oracle and the other two, but
you will find it difficult to find all in the one place.

MySQL is commercial? On their website < http://www.mysql.com/ > they say
"The world's most popular open source database", and they say they are GPL,
and they are on SourceForge. Is there another MySQL, or are only some
modules of it GPL?
On their web site, they do NOT advertise "MySQL(tm) being free" as one of
its "advantages."

They indicate its "advantages" being thus:

MySQL offers several key advantages:

* Reliability and Performance
* Ease of Use and Deployment
* Freedom from Platform Lock-in
* Cross-Platform Support
* Millions of Trained and Certified Developers

And they quite clearly indicate that it is NOT "free" software.

<http://www.mysql.com/products/licensing/>

"If you distribute a proprietary application in any way, and you are
not licensing and distributing your source code under GPL, you need to
purchase a commercial license of MySQL"

There is evidently some sort of danger involved if you don't buy
licenses from the vendor, otherwise their statement that
"That is the safest solution."
wouldn't make sense.

Their intent is evidently for the GPL form of it to provide some form
of "try before you buy" scheme.

"Nevertheless, you can test MySQL under the GPL license and inspect
the source code before you purchase a commercial non-GPL license."

There is no question but that it is a commercial product; the vendor
presents that position with eminent vigor.
--
let name="cbbrowne" and tld="acm.org" in name ^ "@" ^ tld;;
http://www.ntlug.org/~cbbrowne/unix.html
Nothing takes the taste out of peanut butter quite like unrequited
love. -- Charlie Brown [Charles Schultz]


Reply With Quote
  #4  
Old   
Pascal Damian
 
Posts: n/a

Default Re: Differences between databases - 07-21-2004 , 03:55 AM



"Brian P. Giroux" <bpg (AT) onlink (DOT) net> wrote

Quote:
I can't think of any, but I will give you a good start. MS Access is
a desktop database, and not a DBMS, so that is not really comparable
to the others. Oracle and MySQL are commercial products, PostgreSQL
is open-source, like the other open-source DBMS, Firebird. You may
find individual comparisons between say Oracle and the other two, but
you will find it difficult to find all in the one place.

MySQL is commercial? On their website < http://www.mysql.com/ > they say
"The world's most popular open source database", and they say they are GPL,
and they are on SourceForge. Is there another MySQL, or are only some
modules of it GPL?
MySQL is dual-licensed, so it's open source as well as commercial.

--
Pascal


Reply With Quote
  #5  
Old   
Bruce Lewis
 
Posts: n/a

Default Re: Differences between databases - 07-21-2004 , 08:05 AM



Christopher Browne <cbbrowne (AT) acm (DOT) org> writes:

Quote:
And they quite clearly indicate that it is NOT "free" software.

http://www.mysql.com/products/licensing/
I don't disagree with you, but want to point somethign out. One problem
with the text of this page is that is propagates a misconception about
the GPL:

The Commercial License, which allows you to provide commercial software
licenses to your customers or distribute MySQL-based applications within
your organization. This is for organizations that do not want to release
the source code for their applications as open source / free software;
in other words they do not want to comply with the GNU General Public
License (GPL). For more detail on the Commercial non-GPL License, click
here. Or, if you want more information on pricing, click here.

"Distributing" derived works within an organization does not violate the
GPL. The GPL does not tell you how widely to distribute derived works;
it merely keeps you from placing additional restrictions on whatever
recipients you choose to distribute to.

I put "distributing" in quotes, because I'm not convinced that within an
organization is considered distribution under any country's copyright
law.



Reply With Quote
  #6  
Old   
Christopher Browne
 
Posts: n/a

Default Re: Differences between databases - 07-23-2004 , 07:40 PM



Oops! Bruce Lewis <brlspam (AT) yahoo (DOT) com> was seen spray-painting on a wall:
Quote:
I put "distributing" in quotes, because I'm not convinced that within an
organization is considered distribution under any country's copyright
law.
There is _definitely_ ambiguity to that; while the FSF's understanding
of distribution would fit with your reading, the license on Sleepycat
DB (one of the DBM variations) actually specifically contemplates that
if there is more than one physical site, that IS to be treated as
distribution.

And what would cause MySQL AB to sic their lawyers on people could be
an entirely third item...
--
If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me
http://www.ntlug.org/~cbbrowne/finances.html
"So, does this mean goodbye to the "Bluescreen of Death" and hello to
the "Bluescreen of Holy Vengeance?"" -- Observed on Slashdot after
hearing Al Qaeda terrorists may have hacked on Windows XP...


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.