RE: Oracle vs Mysql
If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. My $.02, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, January 14, 2004 11:05 AM To: Multiple recipients of list ORACLE-L Hi, I've been asked by management to explore the pros and cons of Mysql vs Oracle. The database in question will be a web based text and multimedia retrieval system. The size will be around 100 Gb. Can someone let me know the advantages of Oracle over Mysql or the problems we can face using Mysql for example support issues or availability/performance issues. Thanks in advance Mujeeb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: > If you have the choice, look at PostgreSQL in addition to MySQL. From what > I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see "what the heck is Postgres"), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing of clustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but it can be quite a convenient storage space for a small corner shop or a small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database could have handled that. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 14, 2004 1:44 PM > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: > > If you have the choice, look at PostgreSQL in addition to MySQL. From what > > I've seen, it's more mature than MySQL. > > I second that. PostgresSQL supports transactions and uses perl as its > scripting language. From what little I read and saw (just a little pilot > project with the goal to see "what the heck is Postgres"), it's a very > decent database, with a decent performance and capabilities sufficient > for a small, departmental database server. I know nothing of clustering, > distributed database, database links, replication and alike. In other words, > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but > it can be quite a convenient storage space for a small corner shop or a > small department. Because of perl and DBI, exchanging data with other > servers like oracle or UDB (DB2) is easy. > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
1) DBI is a perl module to handle the communication with various databases. 2) Postgres is free. I believe that you can buy commercial support, but I don't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap & easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: > what is DBI? > > is postgre free? Is it like linux where you pay for support? I cant find any > licensing info on the website. Most shops dont need oracle, sql server, > sybase, or DB2. > > Most applications are small. I was on a project where the government had an > Oracle EE license on windows. They didnt even use foreign key constraints. > Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database > could have handled that. > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, January 14, 2004 1:44 PM > > > > > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: > > > If you have the choice, look at PostgreSQL in addition to MySQL. From > what > > > I've seen, it's more mature than MySQL. > > > > I second that. PostgresSQL supports transactions and uses perl as its > > scripting language. From what little I read and saw (just a little pilot > > project with the goal to see "what the heck is Postgres"), it's a very > > decent database, with a decent performance and capabilities sufficient > > for a small, departmental database server. I know nothing of clustering, > > distributed database, database links, replication and alike. In other > words, > > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but > > it can be quite a convenient storage space for a small corner shop or a > > small department. Because of perl and DBI, exchanging data with other > > servers like oracle or UDB (DB2) is easy. > > > > -- > > Mladen Gogala > > Oracle DBA > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mladen Gogala > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ryan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
DBI is an extension to perl language which can then be used by perl to talk with various databases. DBI stands for "database interface". With DBI you also have to load in a specific database driver which is called DBD. For instance for oracle you have to install DBI and DBD::Oracle. Its really cool to use and very fast. I wrote a poor man's replication built on DBI/DBD::Oracle/DBD::Sybase. I like mysql but the sql is just not that rich as it is in oracle. They are fixing some of the shortcomings soon so it will be pretty competitive is basic database usage with Oracle. BTW, I agree that a lot of people only need a simple db and for them mysql/postgres is appropriate. As far as I know, Postgres is free to use, so you don't have to worry about licensing at all. Hope this helps Masroor -Original Message- Ryan Sent: Wednesday, January 14, 2004 12:35 PM To: Multiple recipients of list ORACLE-L what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database could have handled that. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 14, 2004 1:44 PM > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: > > If you have the choice, look at PostgreSQL in addition to MySQL. From what > > I've seen, it's more mature than MySQL. > > I second that. PostgresSQL supports transactions and uses perl as its > scripting language. From what little I read and saw (just a little pilot > project with the goal to see "what the heck is Postgres"), it's a very > decent database, with a decent performance and capabilities sufficient > for a small, departmental database server. I know nothing of clustering, > distributed database, database links, replication and alike. In other words, > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but > it can be quite a convenient storage space for a small corner shop or a > small department. Because of perl and DBI, exchanging data with other > servers like oracle or UDB (DB2) is easy. > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Masroor Farooqi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
I don't think MySQL is free for commercial application, for dev and test purpose it is free. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 14, 2004 4:29 PM > DBI is an extension to perl language which can then be used by perl to talk with various databases. DBI stands for "database interface". With DBI you also have to load in a specific database driver which is called DBD. For instance for oracle you have to install DBI and DBD::Oracle. Its really cool to use and very fast. I wrote a poor man's replication built on DBI/DBD::Oracle/DBD::Sybase. > > I like mysql but the sql is just not that rich as it is in oracle. They are fixing some of the shortcomings soon so it will be pretty competitive is basic database usage with Oracle. BTW, I agree that a lot of people only need a simple db and for them mysql/postgres is appropriate. > > As far as I know, Postgres is free to use, so you don't have to worry about licensing at all. > > Hope this helps > > Masroor > > > -Original Message- > Ryan > Sent: Wednesday, January 14, 2004 12:35 PM > To: Multiple recipients of list ORACLE-L > > > what is DBI? > > is postgre free? Is it like linux where you pay for support? I cant find any > licensing info on the website. Most shops dont need oracle, sql server, > sybase, or DB2. > > Most applications are small. I was on a project where the government had an > Oracle EE license on windows. They didnt even use foreign key constraints. > Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database > could have handled that. > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, January 14, 2004 1:44 PM > > > > > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: > > > If you have the choice, look at PostgreSQL in addition to MySQL. From > what > > > I've seen, it's more mature than MySQL. > > > > I second that. PostgresSQL supports transactions and uses perl as its > > scripting language. From what little I read and saw (just a little pilot > > project with the goal to see "what the heck is Postgres"), it's a very > > decent database, with a decent performance and capabilities sufficient > > for a small, departmental database server. I know nothing of clustering, > > distributed database, database links, replication and alike. In other > words, > > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but > > it can be quite a convenient storage space for a small corner shop or a > > small department. Because of perl and DBI, exchanging data with other > > servers like oracle or UDB (DB2) is easy. > > > > -- > > Mladen Gogala > > Oracle DBA > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Mladen Gogala > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ryan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Masroor Farooqi > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: eric king INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, C
Re: Oracle vs Mysql
I'm suspicious about using MySQL or Postgres with a database 100 gigabytes in size. (Especially, when their main website appeared to be down when I wanted to check some of their recent references). Anyway, if you have availability requirements which don't allow you to take down your system for backup, then you have to use replication (about which quality I'm suspicious again) in order to take "online" backups from a clone db. For that you need another 100GB of storage. Anyway, if I was persuaded to go with MySQL or Postgres for large databases, I'd try to split them up somehow (kind of partitioning), if possible, to have separate databases with separate server processes serving them. That way taking down or crashing of one server wouldn't affect other data that much... Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 14, 2004 8:44 PM > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: > > If you have the choice, look at PostgreSQL in addition to MySQL. From what > > I've seen, it's more mature than MySQL. > > I second that. PostgresSQL supports transactions and uses perl as its > scripting language. From what little I read and saw (just a little pilot > project with the goal to see "what the heck is Postgres"), it's a very > decent database, with a decent performance and capabilities sufficient > for a small, departmental database server. I know nothing of clustering, > distributed database, database links, replication and alike. In other words, > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but > it can be quite a convenient storage space for a small corner shop or a > small department. Because of perl and DBI, exchanging data with other > servers like oracle or UDB (DB2) is easy. > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
i thought postgre was a for profit company? how do they generate revenues? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 14, 2004 4:19 PM > 1) DBI is a perl module to handle the communication with various databases. > 2) Postgres is free. I believe that you can buy commercial support, but I don't know >where. May be Rich can jump in with that. > 3) DBI is free and so is perl. I'm cheap & easy, but not free. > > > On 01/14/2004 02:34:52 PM, Ryan wrote: > > what is DBI? > > > > is postgre free? Is it like linux where you pay for support? I cant find any > > licensing info on the website. Most shops dont need oracle, sql server, > > sybase, or DB2. > > > > Most applications are small. I was on a project where the government had an > > Oracle EE license on windows. They didnt even use foreign key constraints. > > Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database > > could have handled that. > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Wednesday, January 14, 2004 1:44 PM > > > > > > > > > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: > > > > If you have the choice, look at PostgreSQL in addition to MySQL. From > > what > > > > I've seen, it's more mature than MySQL. > > > > > > I second that. PostgresSQL supports transactions and uses perl as its > > > scripting language. From what little I read and saw (just a little pilot > > > project with the goal to see "what the heck is Postgres"), it's a very > > > decent database, with a decent performance and capabilities sufficient > > > for a small, departmental database server. I know nothing of clustering, > > > distributed database, database links, replication and alike. In other > > words, > > > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but > > > it can be quite a convenient storage space for a small corner shop or a > > > small department. Because of perl and DBI, exchanging data with other > > > servers like oracle or UDB (DB2) is easy. > > > > > > -- > > > Mladen Gogala > > > Oracle DBA > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Mladen Gogala > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > San Diego, California-- Mailing list and web hosting services > > > - > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Ryan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
There is a commercial arm of PostgreSQL (or at least a partner) for businesses that require support. Surf on over to: http://www.pgsql.com Expect to pay about the same for PostgreSQL support as you would for Oracle. I don't know of any support for DBI other than the Perl DBI mailing list (which, like this list, is excellent!). Traffic is about the same as ORACLE-L. To subscribe to the list, send a message to: <[EMAIL PROTECTED]> Better yet, head to http://www.oreilly.com and find the books, then over to http://www.bookpool.com and order 'em. HTH! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, January 14, 2004 3:20 PM To: Multiple recipients of list ORACLE-L 1) DBI is a perl module to handle the communication with various databases. 2) Postgres is free. I believe that you can buy commercial support, but I don't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap & easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: > what is DBI? > > is postgre free? Is it like linux where you pay for support? I cant find any > licensing info on the website. Most shops dont need oracle, sql server, > sybase, or DB2. > > Most applications are small. I was on a project where the government had an > Oracle EE license on windows. They didnt even use foreign key constraints. > Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database > could have handled that. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Ryan > Sent: Thursday, 15 January 2004 09:05 > To: Multiple recipients of list ORACLE-L > Subject: Re: Oracle vs Mysql > > > i thought postgre was a for profit company? how do they > generate revenues? Don't confuse the PostgreSQL dev team with PostgreSQL Inc. The latter makes some commercially licenced add-ons for PostgreSQL, but the db itself is released under the Berkeley licence. Completely free for commercial use. Unlike MySQL, where you need to licence the server, AND licence the connectivity for commercial use. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
One more thing which you can tell your boss: MySQL and Oracle are not comparable, at least not with any trustworthy results. (the same goes with MySQL and DB2 or Access and SQL server...) Tanel. - Original Message - From: Mujeeb Chowdhry To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 14, 2004 7:04 PM Subject: Oracle vs Mysql Hi, I've been asked by management to explore the pros and cons of Mysql vs Oracle. The database in question will be a web based text and multimedia retrieval system. The size will be around 100 Gb. Can someone let me know the advantages of Oracle over Mysql or the problems we can face using Mysql for example support issues or availability/performance issues. Thanks in advance Mujeeb
Re: Oracle vs Mysql
- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 15, 2004 4:04 AM Hi, I've been asked by management to explore the pros and cons of Mysql vs Oracle. The database in question will be a web based text and multimedia retrieval system. The size will be around 100 Gb. Can someone let me know the advantages of Oracle over Mysql or the problems we can face using Mysql for example support issues or availability/performance issues. Thanks in advance Mujeeb Ask your damagement if they are ready to give up on Microslop Office in favour of OpenOffice. If the reply is yes, then come back and we'll talk again. If the reply is no, ask for the reasons and use PRECISELY the same to argue in favour of Oracle. Don't even bother with MySQL. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
On 01/14/2004 04:49:52 PM, "Jesse, Rich" wrote: > Expect to pay about the same for PostgreSQL support as you would for Oracle. 15% of the purchase price/year? -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
can't beat them, join them... :) Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - > Excellent reasoning Nuno. I hadn't thought of that. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
I think he is talking about 100GB database. Can PostgreSQL and MySQL handle that size? We used MySQL in some of the web projects, but it just stores small set of operational data and later on those data are moved to Oracle as a permenant store. For small set of data, MySQL is quite good, but it lacks features such as foreign key constraints, triggers etc. Eric - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 14, 2004 1:44 PM > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: > > If you have the choice, look at PostgreSQL in addition to MySQL. From what > > I've seen, it's more mature than MySQL. > > I second that. PostgresSQL supports transactions and uses perl as its > scripting language. From what little I read and saw (just a little pilot > project with the goal to see "what the heck is Postgres"), it's a very > decent database, with a decent performance and capabilities sufficient > for a small, departmental database server. I know nothing of clustering, > distributed database, database links, replication and alike. In other words, > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but > it can be quite a convenient storage space for a small corner shop or a > small department. Because of perl and DBI, exchanging data with other > servers like oracle or UDB (DB2) is easy. > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: eric king INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Ryan, It's postgres.org. I'm not sure how they generate the operating revenue they need, but that's why they are not advertising like MySql AB is. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 5:05 PM To: Multiple recipients of list ORACLE-L i thought postgre was a for profit company? how do they generate revenues? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 14, 2004 4:19 PM > 1) DBI is a perl module to handle the communication with various databases. > 2) Postgres is free. I believe that you can buy commercial support, but I don't know >where. May be Rich can jump in with that. > 3) DBI is free and so is perl. I'm cheap & easy, but not free. > > > On 01/14/2004 02:34:52 PM, Ryan wrote: > > what is DBI? > > > > is postgre free? Is it like linux where you pay for support? I cant find any > > licensing info on the website. Most shops dont need oracle, sql server, > > sybase, or DB2. > > > > Most applications are small. I was on a project where the government had an > > Oracle EE license on windows. They didnt even use foreign key constraints. > > Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database > > could have handled that. > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Wednesday, January 14, 2004 1:44 PM > > > > > > > > > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: > > > > If you have the choice, look at PostgreSQL in addition to MySQL. From > > what > > > > I've seen, it's more mature than MySQL. > > > > > > I second that. PostgresSQL supports transactions and uses perl as its > > > scripting language. From what little I read and saw (just a little pilot > > > project with the goal to see "what the heck is Postgres"), it's a very > > > decent database, with a decent performance and capabilities sufficient > > > for a small, departmental database server. I know nothing of clustering, > > > distributed database, database links, replication and alike. In other > > words, > > > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but > > > it can be quite a convenient storage space for a small corner shop or a > > > small department. Because of perl and DBI, exchanging data with other > > > servers like oracle or UDB (DB2) is easy. > > > > > > -- > > > Mladen Gogala > > > Oracle DBA > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Mladen Gogala > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > San Diego, California-- Mailing list and web hosting services > > > - > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Ryan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing
RE: Oracle vs Mysql
Sounds like the old Oracle vs. Ingress battles. Oracle won because it was better at marketing. All detailed in the book "The Difference Between God and Larry Ellison". I can see it now -- MySQL, the Oracle of the free databases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 4:39 PM To: Multiple recipients of list ORACLE-L Ryan, It's postgres.org. I'm not sure how they generate the operating revenue they need, but that's why they are not advertising like MySql AB is. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 5:05 PM To: Multiple recipients of list ORACLE-L i thought postgre was a for profit company? how do they generate revenues? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 14, 2004 4:19 PM > 1) DBI is a perl module to handle the communication with various databases. > 2) Postgres is free. I believe that you can buy commercial support, but I don't know >where. May be Rich can jump in with that. > 3) DBI is free and so is perl. I'm cheap & easy, but not free. > > > On 01/14/2004 02:34:52 PM, Ryan wrote: > > what is DBI? > > > > is postgre free? Is it like linux where you pay for support? I cant find any > > licensing info on the website. Most shops dont need oracle, sql server, > > sybase, or DB2. > > > > Most applications are small. I was on a project where the government had an > > Oracle EE license on windows. They didnt even use foreign key constraints. > > Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database > > could have handled that. > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Wednesday, January 14, 2004 1:44 PM > > > > > > > > > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: > > > > If you have the choice, look at PostgreSQL in addition to MySQL. From > > what > > > > I've seen, it's more mature than MySQL. > > > > > > I second that. PostgresSQL supports transactions and uses perl as its > > > scripting language. From what little I read and saw (just a little pilot > > > project with the goal to see "what the heck is Postgres"), it's a very > > > decent database, with a decent performance and capabilities sufficient > > > for a small, departmental database server. I know nothing of clustering, > > > distributed database, database links, replication and alike. In other > > words, > > > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but > > > it can be quite a convenient storage space for a small corner shop or a > > > small department. Because of perl and DBI, exchanging data with other > > > servers like oracle or UDB (DB2) is easy. > > > > > > -- > > > Mladen Gogala > > > Oracle DBA > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Mladen Gogala > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > > San Diego, California-- Mailing list and web hosting services > > > - > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Ryan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP comman
RE: Oracle vs Mysql
If MySQL comes to have the same capabilities that many people expect from Oracle, marketing will have no effect. The huge differential in price point will be all that matters. Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/19/2004 04:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Oracle vs Mysql Sounds like the old Oracle vs. Ingress battles. Oracle won because it was better at marketing. All detailed in the book "The Difference Between God and Larry Ellison". I can see it now -- MySQL, the Oracle of the free databases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 4:39 PM To: Multiple recipients of list ORACLE-L Ryan, It's postgres.org. I'm not sure how they generate the operating revenue they need, but that's why they are not advertising like MySql AB is. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 5:05 PM To: Multiple recipients of list ORACLE-L i thought postgre was a for profit company? how do they generate revenues? - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 14, 2004 4:19 PM > 1) DBI is a perl module to handle the communication with various databases. > 2) Postgres is free. I believe that you can buy commercial support, but I don't know > where. May be Rich can jump in with that. > 3) DBI is free and so is perl. I'm cheap & easy, but not free. > > > On 01/14/2004 02:34:52 PM, Ryan wrote: > > what is DBI? > > > > is postgre free? Is it like linux where you pay for support? I cant find any > > licensing info on the website. Most shops dont need oracle, sql server, > > sybase, or DB2. > > > > Most applications are small. I was on a project where the government had an > > Oracle EE license on windows. They didnt even use foreign key constraints. > > Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database > > could have handled that. > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Wednesday, January 14, 2004 1:44 PM > > > > > > > > > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: > > > > If you have the choice, look at PostgreSQL in addition to MySQL. From > > what > > > > I've seen, it's more mature than MySQL. > > > > > > I second that. PostgresSQL supports transactions and uses perl as its > > > scripting language. From what little I read and saw (just a little pilot > > > project with the goal to see "what the heck is Postgres"), it's a very > > > decent database, with a decent performance and capabilities sufficient > > > for a small, departmental database server. I know nothing of clustering, > > > distributed database, database links, replication and alike. In other > > words, > > > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but > > > it can be quite a convenient storage space for a small corner shop or a > > > small department. Because of perl and DBI, exchanging data with other > > > servers like oracle or UDB (DB2) is easy. > > > > > > -- > > > Mladen Gogala > > > Oracle DBA > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Mladen Gogala > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > > San Diego, California -- Mailing list and web hosting services > > > - > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Ryan > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --
Re: Oracle vs Mysql
It needs not to have the same capabilities, it needs to have capabilities that people are using. The primary capabilities that people need, in my opinion, are a decent scripting language, with the full complement of the database triggers, procedures, packages and functions, ability to store/access/administer huge objects, hundreds of gigabytes in size, a decent SQL implementation with plethora of functions and a support for standard APIs like JDBC, ODBC, OLE and DBI. A good compiler support with something similar to long extinct SQL*Module (originally an IBM technology) and there would be huge number of users. Fortunately for oracle, MySQL still has problems with the most basic things: transactions, versioning, locking and SQL implementation. My conclusion is that MySQL will never be much more then a toy, despite the hype, catchy name and apparent popularity. I see much more dangerous adversaries in UDB (artist formerly known as DB2) and PostgresSQL. If IBM decides to play open source on Unix, and there are rumors of IBM musing over such a move, Oracle would most probably be toast. I must say that after some oracle's mischiefs, I wouldn't be the last one to defect and switch the databases. I wasn't the last one to leave DEC either, despite the fact that I was teaching VMS courses in 1992. My point is that Oracle is extremely feature rich. Very few people are using more then 20% of the database capabilities. Initially, in V8, I worked hard to learn about the Object PL/SQL, datatypes and classes. Believe it or not, I've never seen it used in production. By now, I've forgotten it all. It's almost the same situation with Java in the database. Very few are using it. Most people test it, then say "aha!" and move on. Those two features will not make a whole lot of difference when a viable competitor emerges. Oracle 10g was written, for the most part outside of US. With beta testing this closed and restricted, it's not going to be tested thoroughly, not even close to thoroughly. What we are likely to get is an unstable, buggy and almost unusable "gridlock" version. Competitor might emerge sooner then some people are realizing. On 2004.01.19 20:42, [EMAIL PROTECTED] wrote: > If MySQL comes to have the same capabilities that many people expect > from Oracle, marketing will have no effect. The huge differential in > price > point will be all that matters. > > > Jared > > > > > > > DENNIS WILLIAMS <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 01/19/2004 04:04 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:RE: Oracle vs Mysql > > > Sounds like the old Oracle vs. Ingress battles. Oracle won because it was > better at marketing. All detailed in the book "The Difference Between God > and Larry Ellison". I can see it now -- MySQL, the Oracle of the free > databases. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Wednesday, January 14, 2004 4:39 PM > To: Multiple recipients of list ORACLE-L > > > Ryan, > > It's postgres.org. I'm not sure how they generate the > operating > revenue they need, but that's why they are not advertising like MySql AB > is. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Wednesday, January 14, 2004 5:05 PM > To: Multiple recipients of list ORACLE-L > > > i thought postgre was a for profit company? how do they generate revenues? > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, January 14, 2004 4:19 PM > > > > 1) DBI is a perl module to handle the communication with various > databases. > > 2) Postgres is free. I believe that you can buy commercial support, but > I > don't know > >where. May be Rich can jump in with that. > > 3) DBI is free and so is perl. I'm cheap & easy, but not free. > > > > > > On 01/14/2004 02:34:52 PM, Ryan wrote: > > > what is DBI? > > > > > > is postgre free? Is it like linux where you pay for support? I cant > find > any > > > licensing info on the website. Most shops dont need oracle, sql > server, > > > sybase, or DB2. > > > > > > Most applications are small. I was on a project where the government > had > an > > > Oracle EE license on windows. They didnt even use foreign key > constraints. > > > Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free
Re: Oracle vs Mysql
> It needs not to have the same capabilities, it needs to have capabilities that people > are using. Um, that's what I said, or at least meant. On Mon, 2004-01-19 at 20:04, Mladen Gogala wrote: > It needs not to have the same capabilities, it needs to have capabilities that people > are using. The primary capabilities that people need, in my opinion, are a decent > scripting language, with the full complement of the database triggers, procedures, > packages and functions, ability to store/access/administer huge objects, hundreds > of gigabytes in size, a decent SQL implementation with plethora of functions and a > support for standard APIs like JDBC, ODBC, OLE and DBI. A good compiler support > with something similar to long extinct SQL*Module (originally an IBM technology) > and > there would be huge number of users. Fortunately for oracle, MySQL still has problems > with the most basic things: transactions, versioning, locking and SQL > implementation. > My conclusion is that MySQL will never be much more then a toy, despite the hype, > catchy name and apparent popularity. I see much more dangerous adversaries in > UDB (artist formerly known as DB2) and PostgresSQL. If IBM decides to play open > source on Unix, and there are rumors of IBM musing over such a move, Oracle > would most probably be toast. I must say that after some oracle's mischiefs, I > wouldn't be the last one to defect and switch the databases. I wasn't the last one > to leave DEC either, despite the fact that I was teaching VMS courses in 1992. > My point is that Oracle is extremely feature rich. Very few people are using more > then 20% of the database capabilities. Initially, in V8, I worked hard to learn about > the Object PL/SQL, datatypes and classes. Believe it or not, I've never seen it used > in production. By now, I've forgotten it all. It's almost the same situation with > Java > in the database. Very few are using it. Most people test it, then say "aha!" and > move > on. Those two features will not make a whole lot of difference when a viable > competitor > emerges. Oracle 10g was written, for the most part outside of US. With beta testing > this closed and restricted, it's not going to be tested thoroughly, not even close > to thoroughly. > What we are likely to get is an unstable, buggy and almost unusable "gridlock" > version. > Competitor might emerge sooner then some people are realizing. > > On 2004.01.19 20:42, [EMAIL PROTECTED] wrote: > > If MySQL comes to have the same capabilities that many people expect > > from Oracle, marketing will have no effect. The huge differential in > > price > > point will be all that matters. > > > > > > Jared > > > > > > > > > > > > > > DENNIS WILLIAMS <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 01/19/2004 04:04 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > cc: > > Subject:RE: Oracle vs Mysql > > > > > > Sounds like the old Oracle vs. Ingress battles. Oracle won because it was > > better at marketing. All detailed in the book "The Difference Between God > > and Larry Ellison". I can see it now -- MySQL, the Oracle of the free > > databases. > > > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Wednesday, January 14, 2004 4:39 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Ryan, > > > > It's postgres.org. I'm not sure how they generate the > > operating > > revenue they need, but that's why they are not advertising like MySql AB > > is. > > > > Dick Goulet > > Senior Oracle DBA > > Oracle Certified 8i DBA > > > > -Original Message- > > Sent: Wednesday, January 14, 2004 5:05 PM > > To: Multiple recipients of list ORACLE-L > > > > > > i thought postgre was a for profit company? how do they generate revenues? > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > Sent: Wednesday, January 14, 2004 4:19 PM > > > > > > > 1) DBI is a perl module to handle the communication with various > > databases. > > > 2) Postgres is free. I believe that you can buy commercial support, but > > I > > don't know > > >where. May be Rich can jump in with
RE: Oracle vs Mysql
Well, PostGreSql has all of those features, but handling 100GB? Not sure & not sure I'd trust it that far. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 2:10 PM To: Multiple recipients of list ORACLE-L I think he is talking about 100GB database. Can PostgreSQL and MySQL handle that size? We used MySQL in some of the web projects, but it just stores small set of operational data and later on those data are moved to Oracle as a permenant store. For small set of data, MySQL is quite good, but it lacks features such as foreign key constraints, triggers etc. Eric - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, January 14, 2004 1:44 PM > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote: > > If you have the choice, look at PostgreSQL in addition to MySQL. From what > > I've seen, it's more mature than MySQL. > > I second that. PostgresSQL supports transactions and uses perl as its > scripting language. From what little I read and saw (just a little pilot > project with the goal to see "what the heck is Postgres"), it's a very > decent database, with a decent performance and capabilities sufficient > for a small, departmental database server. I know nothing of clustering, > distributed database, database links, replication and alike. In other words, > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but > it can be quite a convenient storage space for a small corner shop or a > small department. Because of perl and DBI, exchanging data with other > servers like oracle or UDB (DB2) is easy. > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: eric king INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
AMEN!! Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Monday, January 19, 2004 8:42 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle vs MysqlIf MySQL comes to have the same capabilities that many people expect from Oracle, marketing will have no effect. The huge differential in price point will be all that matters. Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/19/2004 04:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Oracle vs MysqlSounds like the old Oracle vs. Ingress battles. Oracle won because it wasbetter at marketing. All detailed in the book "The Difference Between Godand Larry Ellison". I can see it now -- MySQL, the Oracle of the freedatabases.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Wednesday, January 14, 2004 4:39 PMTo: Multiple recipients of list ORACLE-LRyan, It's postgres.org. I'm not sure how they generate the operatingrevenue they need, but that's why they are not advertising like MySql AB is.Dick GouletSenior Oracle DBAOracle Certified 8i DBA-Original Message-Sent: Wednesday, January 14, 2004 5:05 PMTo: Multiple recipients of list ORACLE-Li thought postgre was a for profit company? how do they generate revenues?- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Wednesday, January 14, 2004 4:19 PM> 1) DBI is a perl module to handle the communication with variousdatabases.> 2) Postgres is free. I believe that you can buy commercial support, but Idon't know> where. May be Rich can jump in with that.> 3) DBI is free and so is perl. I'm cheap & easy, but not free.>>> On 01/14/2004 02:34:52 PM, Ryan wrote:> > what is DBI?> >> > is postgre free? Is it like linux where you pay for support? I cant findany> > licensing info on the website. Most shops dont need oracle, sql server,> > sybase, or DB2.> >> > Most applications are small. I was on a project where the government hadan> > Oracle EE license on windows. They didnt even use foreign keyconstraints.> > Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any freedatabase> > could have handled that.> > - Original Message -> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>> > Sent: Wednesday, January 14, 2004 1:44 PM> >> >> > >> > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote:> > > > If you have the choice, look at PostgreSQL in addition to MySQL.From> > what> > > > I've seen, it's more mature than MySQL.> > >> > > I second that. PostgresSQL supports transactions and uses perl as its> > > scripting language. From what little I read and saw (just a littlepilot> > > project with the goal to see "what the heck is Postgres"), it's a very> > > decent database, with a decent performance and capabilities sufficient> > > for a small, departmental database server. I know nothing ofclustering,> > > distributed database, database links, replication and alike. In other> > words,> > > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart,but> > > it can be quite a convenient storage space for a small corner shop ora> > > small department. Because of perl and DBI, exchanging data with other> > > servers like oracle or UDB (DB2) is easy.> > >> > > --> > > Mladen Gogala> > > Oracle DBA> > > --> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net> > > -- > > > Author: Mladen Gogala> > > INET: [EMAIL PROTECTED]> > >> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com> > > San Diego, California -- Mailing list and web hosting services> > > -> > > To REMOVE yourself from this mailing list, send an E-Mail message> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> > > the message BODY, include a line containing: UNSUB ORACLE-L> > > (or the name of mailing list you want to be removed from). You may> > > also send the HELP command for other information (like subscribing).> >> > --> > Please see the official ORACLE-L FAQ: http://www.orafaq.net> > --> > Author: Ryan> > INET: [EMAIL PROTECTED]> >> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com> > San Diego, California -- Mailing list and web hosting services> > -> > To REMOVE yourself from this mailing list, send an E-Mail message> > to: [EMAIL PROTECTED] (note EXACT
RE: Oracle vs Mysql
Title: Message Most people only use a fraction of Oracle's features and some are deceived by the Oracle Marketeers who tell them that they NEED them all. Maybe the 80/20 rule also applies to technology purchases... Especially when the cost differential is huge. My 4X4 pickup works just fine and I don't need a Hummer or Land Rover. Offroad in Montana, Steve -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Monday, January 19, 2004 6:42 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle vs MysqlIf MySQL comes to have the same capabilities that many people expect from Oracle, marketing will have no effect. The huge differential in price point will be all that matters. Jared DENNIS WILLIAMS <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/19/2004 04:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Oracle vs MysqlSounds like the old Oracle vs. Ingress battles. Oracle won because it wasbetter at marketing. All detailed in the book "The Difference Between Godand Larry Ellison". I can see it now -- MySQL, the Oracle of the freedatabases.Dennis WilliamsDBALifetouch, Inc.[EMAIL PROTECTED] -Original Message-Sent: Wednesday, January 14, 2004 4:39 PMTo: Multiple recipients of list ORACLE-LRyan, It's postgres.org. I'm not sure how they generate the operatingrevenue they need, but that's why they are not advertising like MySql AB is.Dick GouletSenior Oracle DBAOracle Certified 8i DBA-Original Message-Sent: Wednesday, January 14, 2004 5:05 PMTo: Multiple recipients of list ORACLE-Li thought postgre was a for profit company? how do they generate revenues?- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Wednesday, January 14, 2004 4:19 PM> 1) DBI is a perl module to handle the communication with variousdatabases.> 2) Postgres is free. I believe that you can buy commercial support, but Idon't know> where. May be Rich can jump in with that.> 3) DBI is free and so is perl. I'm cheap & easy, but not free.>>> On 01/14/2004 02:34:52 PM, Ryan wrote:> > what is DBI?> >> > is postgre free? Is it like linux where you pay for support? I cant findany> > licensing info on the website. Most shops dont need oracle, sql server,> > sybase, or DB2.> >> > Most applications are small. I was on a project where the government hadan> > Oracle EE license on windows. They didnt even use foreign keyconstraints.> > Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any freedatabase> > could have handled that.> > - Original Message -> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>> > Sent: Wednesday, January 14, 2004 1:44 PM> >> >> > >> > > On 01/14/2004 12:44:25 PM, "Jesse, Rich" wrote:> > > > If you have the choice, look at PostgreSQL in addition to MySQL.From> > what> > > > I've seen, it's more mature than MySQL.> > >> > > I second that. PostgresSQL supports transactions and uses perl as its> > > scripting language. From what little I read and saw (just a littlepilot> > > project with the goal to see "what the heck is Postgres"), it's a very> > > decent database, with a decent performance and capabilities sufficient> > > for a small, departmental database server. I know nothing ofclustering,> > > distributed database, database links, replication and alike. In other> > words,> > > I wouldn't use it for an enterprise-wide server for GE or Wall-Mart,but> > > it can be quite a convenient storage space for a small corner shop ora> > > small department. Because of perl and DBI, exchanging data with other> > > servers like oracle or UDB (DB2) is easy.> > >> > > --> > > Mladen Gogala> > > Oracle DBA> > > --> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net> > > -- > > > Author: Mladen Gogala> > > INET: [EMAIL PROTECTED]> > >> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com> > > San Diego, California -- Mailing list and web hosting services> > > -> > > To REMOVE yourself from this mailing list, send an E-Mail message> > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> > > the message BODY, include a line containing: UNSUB ORACLE-L> > > (or the name of mailing list you want to be removed from). You may> > > also send the HELP command for other information (like subscribing).> >> > --> > Please see the official ORACLE-L FAQ: http://www.orafaq.net> > --> > Author: Ryan> > INET: [EMAIL PROTECTED
RE: Oracle vs Mysql
Mladen, Well, I'll agree with you over 90% of your post. Oracle is extremely feature rich, to my vast enjoyment. BTW: We use pl/sql objects and Java stuff in production, mostly Oracle's pre-canned Java, but we do have a production application with it's own Java function too. As for IBM, looks like their going to play on Linux as well & Uncle Larry better get his stuff together if he plans to compete. Still looking for the details of his site licensing idea. Got a CIO who's willing to sign on and toss out all other RDBMS's, if it's reasonable. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, January 19, 2004 11:04 PM To: Multiple recipients of list ORACLE-L It needs not to have the same capabilities, it needs to have capabilities that people are using. The primary capabilities that people need, in my opinion, are a decent scripting language, with the full complement of the database triggers, procedures, packages and functions, ability to store/access/administer huge objects, hundreds of gigabytes in size, a decent SQL implementation with plethora of functions and a support for standard APIs like JDBC, ODBC, OLE and DBI. A good compiler support with something similar to long extinct SQL*Module (originally an IBM technology) and there would be huge number of users. Fortunately for oracle, MySQL still has problems with the most basic things: transactions, versioning, locking and SQL implementation. My conclusion is that MySQL will never be much more then a toy, despite the hype, catchy name and apparent popularity. I see much more dangerous adversaries in UDB (artist formerly known as DB2) and PostgresSQL. If IBM decides to play open source on Unix, and there are rumors of IBM musing over such a move, Oracle would most probably be toast. I must say that after some oracle's mischiefs, I wouldn't be the last one to defect and switch the databases. I wasn't the last one to leave DEC either, despite the fact that I was teaching VMS courses in 1992. My point is that Oracle is extremely feature rich. Very few people are using more then 20% of the database capabilities. Initially, in V8, I worked hard to learn about the Object PL/SQL, datatypes and classes. Believe it or not, I've never seen it used in production. By now, I've forgotten it all. It's almost the same situation with Java in the database. Very few are using it. Most people test it, then say "aha!" and move on. Those two features will not make a whole lot of difference when a viable competitor emerges. Oracle 10g was written, for the most part outside of US. With beta testing this closed and restricted, it's not going to be tested thoroughly, not even close to thoroughly. What we are likely to get is an unstable, buggy and almost unusable "gridlock" version. Competitor might emerge sooner then some people are realizing. On 2004.01.19 20:42, [EMAIL PROTECTED] wrote: > If MySQL comes to have the same capabilities that many people expect > from Oracle, marketing will have no effect. The huge differential in > price > point will be all that matters. > > > Jared > > > > > > > DENNIS WILLIAMS <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 01/19/2004 04:04 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:RE: Oracle vs Mysql > > > Sounds like the old Oracle vs. Ingress battles. Oracle won because it was > better at marketing. All detailed in the book "The Difference Between God > and Larry Ellison". I can see it now -- MySQL, the Oracle of the free > databases. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Wednesday, January 14, 2004 4:39 PM > To: Multiple recipients of list ORACLE-L > > > Ryan, > > It's postgres.org. I'm not sure how they generate the > operating > revenue they need, but that's why they are not advertising like MySql AB > is. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -Original Message- > Sent: Wednesday, January 14, 2004 5:05 PM > To: Multiple recipients of list ORACLE-L > > > i thought postgre was a for profit company? how do they generate revenues? > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, January 14, 2004 4:19 PM > > > > 1) DBI is a perl module to handle the communication with various > databases. > > 2) Postgres is free. I believe that you can buy commercial support, but > I > don't kno
Re: Oracle vs Mysql
On 01/20/2004 09:19:44 AM, "Goulet, Dick" wrote: Well, PostGreSql has all of those features, but handling 100GB? Not sure & not sure I'd trust it that far. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA Given the price, I believe that some testing would be warranted, don't you think? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Inprocess actually. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 10:54 AM To: Multiple recipients of list ORACLE-L On 01/20/2004 09:19:44 AM, "Goulet, Dick" wrote: > Well, PostGreSql has all of those features, but handling 100GB? Not > sure & not sure I'd trust it that far. > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA Given the price, I believe that some testing would be warranted, don't you think? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
On Wed, 14 Jan 2004, eric king wrote: > I think he is talking about 100GB database. Can PostgreSQL and MySQL handle > that size? We used MySQL in some of the web projects, but it just stores > small set of operational data and later on those data are moved to Oracle as > a permenant store. For small set of data, MySQL is quite good, but it lacks > features such as foreign key constraints, triggers etc. I seem to recall reports of Monty (the creator of MySQL) supporting terabyte size databases with earlier versions of MySQL. Not sure what types of storage systems were used to achieve that, though. And to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only (iirc) if you use the 'Innodb' table type. Now whether or not a database allowing some tables to have FK support and others not is a good proposition you'll have to judge for yourself. I still prefer Pg to MySQL. Fwiw, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Back to MySQL and whether Postgres is the way to go, I can recall editorials debating whether Unix/Oracle would ever be industrial strength enough to support critical applications. The point the book "The Difference Between God and Larry Ellison" tries to make is that the technically superior product isn't always the one that succeeds. Often it is the one that is marketed better. A quick check of Amazon reveals several books devoted to MySQL, but I don't see any devoted to Postgres. The story the author relates has to do with distributed databases. Ingres was developing a distributed database capability. Larry got wind of this and announced an new product "SQL*Star", that hadn't even been discussed within Oracle. When Ingres announced their product, the press asked "isn't than like Oracle's SQL*Star?". My point is that each time these free databases are discussed, people mention the fact that Postgres is superior from a technical standpoint. But from what I see, often it is the best marketed product that prevails. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 20, 2004 11:45 AM To: Multiple recipients of list ORACLE-L On Wed, 14 Jan 2004, eric king wrote: > I think he is talking about 100GB database. Can PostgreSQL and MySQL handle > that size? We used MySQL in some of the web projects, but it just stores > small set of operational data and later on those data are moved to Oracle as > a permenant store. For small set of data, MySQL is quite good, but it lacks > features such as foreign key constraints, triggers etc. I seem to recall reports of Monty (the creator of MySQL) supporting terabyte size databases with earlier versions of MySQL. Not sure what types of storage systems were used to achieve that, though. And to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only (iirc) if you use the 'Innodb' table type. Now whether or not a database allowing some tables to have FK support and others not is a good proposition you'll have to judge for yourself. I still prefer Pg to MySQL. Fwiw, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Huh???!?? What did you search for? I get many hits searching for "postgresql". Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, January 20, 2004 12:29 PM To: Multiple recipients of list ORACLE-L [snip] A quick check of Amazon reveals several books devoted to MySQL, but I don't see any devoted to Postgres. [snip] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
On 01/20/2004 01:29:25 PM, DENNIS WILLIAMS wrote: Back to MySQL and whether Postgres is the way to go, I can recall editorials debating whether Unix/Oracle would ever be industrial strength enough to support critical applications. The point the book "The Difference Between God and Larry Ellison" tries to make is that the technically superior product isn't always the one that succeeds. Often it is the one that is marketed better. A quick check of Amazon reveals several books devoted to MySQL, but I don't see any devoted to Postgres. I have a book devoted to PostgresSQL at home. When I come home, I'll post the information. The story the author relates has to do with distributed databases. Ingres was developing a distributed database capability. Larry got wind of this and announced an new product "SQL*Star", that hadn't even been discussed within Oracle. When Ingres announced their product, the press asked "isn't than like Oracle's SQL*Star?". My point is that each time these free databases are discussed, people mention the fact that Postgres is superior from a technical standpoint. But from what I see, often it is the best marketed product that prevails. Not often, it's the rule. After all, technical merits are not the only criteria. The company management usually wants to know whether they can get 7x24 support, what happens if a critical security flaw is discovered, how long will it take to get the solution, are there any training facilities or will they have to pay for the airplane tickets in order to train people. That is why I keep mentioning IBM. None of these two databases stands the chance of a snowflake in heck if the big blue decides to put its weight behind UDB on Linux. For a technically good product to succeed, it needs to fulfill the requirements of the corporate world. That is why ElectroLux robot, despite the price tag of $3000 is more successful in the commercial environment then iRobot's Roomba, with the price tag of $200 (I love my Roomba, and it doesn't make any trouble). ElectroLux has service contract with Sears and the only thing you can do with Roomba is to pack it up and send it back. That is acceptable to me, but not acceptable to Hilton (and I don't mean Paris). It's exactly the same with the databases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 20, 2004 11:45 AM To: Multiple recipients of list ORACLE-L On Wed, 14 Jan 2004, eric king wrote: > I think he is talking about 100GB database. Can PostgreSQL and MySQL handle > that size? We used MySQL in some of the web projects, but it just stores > small set of operational data and later on those data are moved to Oracle as > a permenant store. For small set of data, MySQL is quite good, but it lacks > features such as foreign key constraints, triggers etc. I seem to recall reports of Monty (the creator of MySQL) supporting terabyte size databases with earlier versions of MySQL. Not sure what types of storage systems were used to achieve that, though. And to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only (iirc) if you use the 'Innodb' table type. Now whether or not a database allowing some tables to have FK support and others not is a good proposition you'll have to judge for yourself. I still prefer Pg to MySQL. Fwiw, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET
Re: Oracle vs Mysql
On Tue, 20 Jan 2004, Mladen Gogala wrote: > I have a book devoted to PostgresSQL at home. When I come home, I'll > post the information. O'Reilly has "Practical Postgresql", the full text of which is also available online: http://www.commandprompt.com/ppbook/ I know there are a couple of others floating around as well. But you're right, MySQL (sadly, IMO) has the mindshare. -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Hence why Sql*Server is out there. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 1:29 PM To: Multiple recipients of list ORACLE-L Back to MySQL and whether Postgres is the way to go, I can recall editorials debating whether Unix/Oracle would ever be industrial strength enough to support critical applications. The point the book "The Difference Between God and Larry Ellison" tries to make is that the technically superior product isn't always the one that succeeds. Often it is the one that is marketed better. A quick check of Amazon reveals several books devoted to MySQL, but I don't see any devoted to Postgres. The story the author relates has to do with distributed databases. Ingres was developing a distributed database capability. Larry got wind of this and announced an new product "SQL*Star", that hadn't even been discussed within Oracle. When Ingres announced their product, the press asked "isn't than like Oracle's SQL*Star?". My point is that each time these free databases are discussed, people mention the fact that Postgres is superior from a technical standpoint. But from what I see, often it is the best marketed product that prevails. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 20, 2004 11:45 AM To: Multiple recipients of list ORACLE-L On Wed, 14 Jan 2004, eric king wrote: > I think he is talking about 100GB database. Can PostgreSQL and MySQL handle > that size? We used MySQL in some of the web projects, but it just stores > small set of operational data and later on those data are moved to Oracle as > a permenant store. For small set of data, MySQL is quite good, but it lacks > features such as foreign key constraints, triggers etc. I seem to recall reports of Monty (the creator of MySQL) supporting terabyte size databases with earlier versions of MySQL. Not sure what types of storage systems were used to achieve that, though. And to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only (iirc) if you use the 'Innodb' table type. Now whether or not a database allowing some tables to have FK support and others not is a good proposition you'll have to judge for yourself. I still prefer Pg to MySQL. Fwiw, -- Dan Daniel Hanks - Systems/Database Administrator About Inc., Web Services Division -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Hanks INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Rich Amazon - Enter MySQL - 412 hits. The first screen of books are nearly all devoted to MySQL. Enter Postgres - 94 hits. None of the books on the first screen seem to be devoted to Postgres, but just mention it incidentally. Google - Enter MySQL - 15.6 million hits. Postgres - 733,000 hits or less than 5% of the MySQL hits. Admittedly these are just rough comparisons, and I think Jonathan's statement that MySQL books sell much better is a much more reliable statement. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 20, 2004 12:59 PM To: Multiple recipients of list ORACLE-L Huh???!?? What did you search for? I get many hits searching for "postgresql". Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, January 20, 2004 12:29 PM To: Multiple recipients of list ORACLE-L [snip] A quick check of Amazon reveals several books devoted to MySQL, but I don't see any devoted to Postgres. [snip] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs Mysql
Ahh. Re-read my post. The proper name of the product is "postgresql" and not "postgres". You should find 112 hits on books... HTH! :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, January 20, 2004 3:00 PM To: Multiple recipients of list ORACLE-L Rich Amazon - Enter MySQL - 412 hits. The first screen of books are nearly all devoted to MySQL. Enter Postgres - 94 hits. None of the books on the first screen seem to be devoted to Postgres, but just mention it incidentally. Google - Enter MySQL - 15.6 million hits. Postgres - 733,000 hits or less than 5% of the MySQL hits. Admittedly these are just rough comparisons, and I think Jonathan's statement that MySQL books sell much better is a much more reliable statement. Dennis Williams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle vs Mysql
> > I have a book devoted to PostgresSQL at home. When I come home, I'll > > post the information. > > O'Reilly has "Practical Postgresql", the full text of which is also available > online: http://www.commandprompt.com/ppbook/ > > I know there are a couple of others floating around as well. > > But you're right, MySQL (sadly, IMO) has the mindshare. I'm not sure about sadly, this is very much a development model difference just like between linux and freebsd. Postgresql is (culturally and otherwise) an extension of the university project, mysql is a much more in the weeds do-over. Currently I'd point people looking for opensource databases postgres for complicated problems as it has a lot more of what one would expect to see in a database product, but if their needs are simple or they are looking for long term then i'd suggest mysql. Mysql has (like linux vs. *bsd) a much larger share of the developer mindset and that is the most important thing when it comes to opensource software. -- craig .-... . -.-. .-. . --- . ... ... .- --. . Craig I. Hagan hagan(at)cih.com Scientists have discovered that research causes cancer in rats. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig I. Hagan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs. MySQL
You can't do subqueries in mySQL You can't use derived tables in mySQL The foreign key support is defined as not being "Full", don't know what that means. Dave -Original Message- Sent: Wednesday, August 01, 2001 11:48 AM To: Multiple recipients of list ORACLE-L The comparisons look good for MySQL... not bad for others, but better for mySQL than some comments by some folks on the list would have led me to believe. Anyone here have major gripes about mySQL that oracle solved? -Original Message- Sent: Wednesday, August 01, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Interesting site... Since I am not familiar with some of the other databases, are all the ones listed there 3 versions old or just Oracle? I noticed DB2 was 2 versions old. > -Original Message- > From: Dwayne Cox [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 9:56 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: off topic--oracle Vs ms sql > > > Try this site... > > http://www.mysql.com/information/crash-me.php > > On Mon, 30 Jul 2001 13:29:28 -0800 > "Ravindra Basavaraja" <[EMAIL PROTECTED]> wrote: > > > Does anyone have any doc or links that compares oracle and ms sql. > > > > Also what are the equivalent data types in ms sql for oracle's lobs. > > > > Thanks > > Ravindra > > > __ > Dwayne Cox > DBA, Development Dept. > Info Tech, Inc. > [EMAIL PROTECTED] > http://www.infotechfl.com > ___ > The opinions expressed are the author's own unless otherwise stated > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dwayne Cox > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs. MySQL
AFAIK on big thing 'missing' in mySQL is that it has no journalling (transaction logging) capabilities. So there's no transaction mgt.. rollbacks...etc.. if things bozo in the middle of a process.. you're dead. Restore from last backup and hope for the best. So you wouldn't want to use it for storing data that's really 'important'. Lots of web sites use it to manage connection states etc.. where if it crashes.. well. they just restart. I don't know if it handles replication.. or how well it would digest 10 GB of data ! I think the open source 'postgres' [sic ?] database is supposed to be more robust... It's now being supported and packaged by the Red Hat Linux people. In the long run, you get what you pay for ! -Original Message- Sent: Wednesday, August 01, 2001 11:48 AM To: Multiple recipients of list ORACLE-L The comparisons look good for MySQL... not bad for others, but better for mySQL than some comments by some folks on the list would have led me to believe. Anyone here have major gripes about mySQL that oracle solved? -Original Message- Sent: Wednesday, August 01, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Interesting site... Since I am not familiar with some of the other databases, are all the ones listed there 3 versions old or just Oracle? I noticed DB2 was 2 versions old. > -Original Message- > From: Dwayne Cox [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 9:56 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: off topic--oracle Vs ms sql > > > Try this site... > > http://www.mysql.com/information/crash-me.php > > On Mon, 30 Jul 2001 13:29:28 -0800 > "Ravindra Basavaraja" <[EMAIL PROTECTED]> wrote: > > > Does anyone have any doc or links that compares oracle and ms sql. > > > > Also what are the equivalent data types in ms sql for oracle's lobs. > > > > Thanks > > Ravindra > > > __ > Dwayne Cox > DBA, Development Dept. > Info Tech, Inc. > [EMAIL PROTECTED] > http://www.infotechfl.com > ___ > The opinions expressed are the author's own unless otherwise stated > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dwayne Cox > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs. MySQL
Hi, Ross, I've got some experience with both 1. You dont have transaction (until the very recent versions, at least) 2. You dont have fererential integrity (FK is declared but not enforced) 3. Dont have views 4. Noting like PL/SQL 5. Reader blocks writer 6. Weak type support, for example can put 123456 to the number(1) field - further migration to Oracle may give you some pain Bright side it's fast (beats Oracle sometimes) and free. Regards, Vadim Gorbounov Oracle DBA ( not mySQL:) ) -Original Message- Sent: Wednesday, August 01, 2001 12:48 PM To: Multiple recipients of list ORACLE-L The comparisons look good for MySQL... not bad for others, but better for mySQL than some comments by some folks on the list would have led me to believe. Anyone here have major gripes about mySQL that oracle solved? -Original Message- Sent: Wednesday, August 01, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Interesting site... Since I am not familiar with some of the other databases, are all the ones listed there 3 versions old or just Oracle? I noticed DB2 was 2 versions old. > -Original Message- > From: Dwayne Cox [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 9:56 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: off topic--oracle Vs ms sql > > > Try this site... > > http://www.mysql.com/information/crash-me.php > > On Mon, 30 Jul 2001 13:29:28 -0800 > "Ravindra Basavaraja" <[EMAIL PROTECTED]> wrote: > > > Does anyone have any doc or links that compares oracle and ms sql. > > > > Also what are the equivalent data types in ms sql for oracle's lobs. > > > > Thanks > > Ravindra > > > __ > Dwayne Cox > DBA, Development Dept. > Info Tech, Inc. > [EMAIL PROTECTED] > http://www.infotechfl.com > ___ > The opinions expressed are the author's own unless otherwise stated > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dwayne Cox > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs. MySQL
Yeah, how about basic transaction support? Table locking is a problem when the database/web site starts to experience a modest number of hits. We migrate customers from MySQL to Oracle when there are performance problems and they instantly disappear with Oracle. MySQL is not ANSI SQL compliant because it uses a subset of "standard SQL." In effect, MySQL is it's own unique and distinct dialect. That's why it's called "MySQL" and it's developers admit that they left out certain ANSI SQL functionality for the sake of simplicity and speed in a non-multi-user non-transactional environment. MySQL may be "open source" but it is not truly "standards-based" since it is not ANSI SQL compliant. In essence MySQL is a subset SQL dialect which serves as an interface to file systems and is not a "pure" implementation of a relational database. The following features which are lacking from MySQL: 1) no support for stored procedures and triggers; 2) no support for subqueries; 3) incomplete support for database transactions; 4) no support for referential integrity via database level foreign key constraints. (Some of these features are database vendor "extenstions" to ANSI SQL but they are common to most other real database engines whether commercial or open source.) Notice the "Other features" section at the bottom of the crash-me link... "Atomic updates" are not supported. Transaction support seems to be an afterthought and MySQL does not pass the ACID test. Check out: http://openacs.org/philosophy/why-not-mysql.html If you don't have to update your data then MySQL may have its place. Humbly yours, Steve Orr -Original Message- Sent: Wednesday, August 01, 2001 10:48 AM To: Multiple recipients of list ORACLE-L The comparisons look good for MySQL... not bad for others, but better for mySQL than some comments by some folks on the list would have led me to believe. Anyone here have major gripes about mySQL that oracle solved? -Original Message- Sent: Wednesday, August 01, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Interesting site... Since I am not familiar with some of the other databases, are all the ones listed there 3 versions old or just Oracle? I noticed DB2 was 2 versions old. > -Original Message- > From: Dwayne Cox [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 9:56 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: off topic--oracle Vs ms sql > > > Try this site... > > http://www.mysql.com/information/crash-me.php > > On Mon, 30 Jul 2001 13:29:28 -0800 > "Ravindra Basavaraja" <[EMAIL PROTECTED]> wrote: > > > Does anyone have any doc or links that compares oracle and ms sql. > > > > Also what are the equivalent data types in ms sql for oracle's lobs. > > > > Thanks > > Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs. MySQL
Certain things don't need transactions. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, August 01, 2001 1:27 PM To: Multiple recipients of list ORACLE-L AFAIK on big thing 'missing' in mySQL is that it has no journalling (transaction logging) capabilities. So there's no transaction mgt.. rollbacks...etc.. if things bozo in the middle of a process.. you're dead. Restore from last backup and hope for the best. So you wouldn't want to use it for storing data that's really 'important'. Lots of web sites use it to manage connection states etc.. where if it crashes.. well. they just restart. I don't know if it handles replication.. or how well it would digest 10 GB of data ! I think the open source 'postgres' [sic ?] database is supposed to be more robust... It's now being supported and packaged by the Red Hat Linux people. In the long run, you get what you pay for ! -Original Message- Sent: Wednesday, August 01, 2001 11:48 AM To: Multiple recipients of list ORACLE-L The comparisons look good for MySQL... not bad for others, but better for mySQL than some comments by some folks on the list would have led me to believe. Anyone here have major gripes about mySQL that oracle solved? -Original Message- Sent: Wednesday, August 01, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Interesting site... Since I am not familiar with some of the other databases, are all the ones listed there 3 versions old or just Oracle? I noticed DB2 was 2 versions old. > -Original Message- > From: Dwayne Cox [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 9:56 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: off topic--oracle Vs ms sql > > > Try this site... > > http://www.mysql.com/information/crash-me.php > > On Mon, 30 Jul 2001 13:29:28 -0800 > "Ravindra Basavaraja" <[EMAIL PROTECTED]> wrote: > > > Does anyone have any doc or links that compares oracle and ms sql. > > > > Also what are the equivalent data types in ms sql for oracle's lobs. > > > > Thanks > > Ravindra > > > __ > Dwayne Cox > DBA, Development Dept. > Info Tech, Inc. > [EMAIL PROTECTED] > http://www.infotechfl.com > ___ > The opinions expressed are the author's own unless otherwise stated > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dwayne Cox > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -
RE: Oracle vs. MySQL
I did not look at the site. In the past the MYSQL comparison was pretty shoddy. If a MYSQL had a function, smallest, and another database had a function, least, which did the exact same thing, the database wit the "least" function would not get credit for it. I fabricated the above example, but the gist of the statment was true a few years ago. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 01, 2001 10:16 AM To: Multiple recipients of list ORACLE-L You can't do subqueries in mySQL You can't use derived tables in mySQL The foreign key support is defined as not being "Full", don't know what that means. Dave -Original Message- Sent: Wednesday, August 01, 2001 11:48 AM To: Multiple recipients of list ORACLE-L The comparisons look good for MySQL... not bad for others, but better for mySQL than some comments by some folks on the list would have led me to believe. Anyone here have major gripes about mySQL that oracle solved? -Original Message- Sent: Wednesday, August 01, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Interesting site... Since I am not familiar with some of the other databases, are all the ones listed there 3 versions old or just Oracle? I noticed DB2 was 2 versions old. > -Original Message- > From: Dwayne Cox [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 9:56 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: off topic--oracle Vs ms sql > > > Try this site... > > http://www.mysql.com/information/crash-me.php > > On Mon, 30 Jul 2001 13:29:28 -0800 > "Ravindra Basavaraja" <[EMAIL PROTECTED]> wrote: > > > Does anyone have any doc or links that compares oracle and ms sql. > > > > Also what are the equivalent data types in ms sql for oracle's lobs. > > > > Thanks > > Ravindra > > > __ > Dwayne Cox > DBA, Development Dept. > Info Tech, Inc. > [EMAIL PROTECTED] > http://www.infotechfl.com > ___ > The opinions expressed are the author's own unless otherwise stated > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dwayne Cox > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 F
RE: Oracle vs. MySQL
www.mysqlsucks.com mySQL is great for some things, not so great for other things. For what it is, it is great in general. I am not one to praise one and bash all the others, but I don't think mySQL is the best for everything, let alone Oracle the same. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, August 01, 2001 12:48 PM To: Multiple recipients of list ORACLE-L The comparisons look good for MySQL... not bad for others, but better for mySQL than some comments by some folks on the list would have led me to believe. Anyone here have major gripes about mySQL that oracle solved? -Original Message- Sent: Wednesday, August 01, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Interesting site... Since I am not familiar with some of the other databases, are all the ones listed there 3 versions old or just Oracle? I noticed DB2 was 2 versions old. > -Original Message- > From: Dwayne Cox [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 9:56 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: off topic--oracle Vs ms sql > > > Try this site... > > http://www.mysql.com/information/crash-me.php > > On Mon, 30 Jul 2001 13:29:28 -0800 > "Ravindra Basavaraja" <[EMAIL PROTECTED]> wrote: > > > Does anyone have any doc or links that compares oracle and ms sql. > > > > Also what are the equivalent data types in ms sql for oracle's lobs. > > > > Thanks > > Ravindra > > > __ > Dwayne Cox > DBA, Development Dept. > Info Tech, Inc. > [EMAIL PROTECTED] > http://www.infotechfl.com > ___ > The opinions expressed are the author's own unless otherwise stated > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dwayne Cox > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs. MySQL
Title: RE: Oracle vs. MySQL - provides master-slave replication only. only 1 master, but i think up to 1000 slaves. - uses only one port for transactions, so you can easily flood that port if you have large emounts of data - no referencial integrity. that all has to be built into your product. - doesn't do well with multiple table joins. i think it was summed up with "you get what you pay for." if you want something to play with and learn or have non-mission critical business app, it's fine. -Original Message- From: Vadim Gorbounov [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 01, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle vs. MySQL Hi, Ross, I've got some experience with both 1. You dont have transaction (until the very recent versions, at least) 2. You dont have fererential integrity (FK is declared but not enforced) 3. Dont have views 4. Noting like PL/SQL 5. Reader blocks writer 6. Weak type support, for example can put 123456 to the number(1) field - further migration to Oracle may give you some pain Bright side it's fast (beats Oracle sometimes) and free. Regards, Vadim Gorbounov Oracle DBA ( not mySQL:) ) -Original Message- Sent: Wednesday, August 01, 2001 12:48 PM To: Multiple recipients of list ORACLE-L The comparisons look good for MySQL... not bad for others, but better for mySQL than some comments by some folks on the list would have led me to believe. Anyone here have major gripes about mySQL that oracle solved? -Original Message- Sent: Wednesday, August 01, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Interesting site... Since I am not familiar with some of the other databases, are all the ones listed there 3 versions old or just Oracle? I noticed DB2 was 2 versions old. > -Original Message- > From: Dwayne Cox [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 9:56 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: off topic--oracle Vs ms sql > > > Try this site... > > http://www.mysql.com/information/crash-me.php > > On Mon, 30 Jul 2001 13:29:28 -0800 > "Ravindra Basavaraja" <[EMAIL PROTECTED]> wrote: > > > Does anyone have any doc or links that compares oracle and ms sql. > > > > Also what are the equivalent data types in ms sql for oracle's lobs. > > > > Thanks > > Ravindra > > > __ > Dwayne Cox > DBA, Development Dept. > Info Tech, Inc. > [EMAIL PROTECTED] > http://www.infotechfl.com > ___ > The opinions expressed are the author's own unless otherwise stated > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dwayne Cox > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the
RE: Oracle vs. MySQL
True, but how can they(MySQL guys) call it a RDBMS if they don't support transaction? Isn't the ACID is what the RDBMS is all about? Richard Ji >>> [EMAIL PROTECTED] 08/01/01 01:56PM >>> Certain things don't need transactions. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, August 01, 2001 1:27 PM To: Multiple recipients of list ORACLE-L AFAIK on big thing 'missing' in mySQL is that it has no journalling (transaction logging) capabilities. So there's no transaction mgt.. rollbacks...etc.. if things bozo in the middle of a process.. you're dead. Restore from last backup and hope for the best. So you wouldn't want to use it for storing data that's really 'important'. Lots of web sites use it to manage connection states etc.. where if it crashes.. well. they just restart. I don't know if it handles replication.. or how well it would digest 10 GB of data ! I think the open source 'postgres' [sic ?] database is supposed to be more robust... It's now being supported and packaged by the Red Hat Linux people. In the long run, you get what you pay for ! -Original Message- Sent: Wednesday, August 01, 2001 11:48 AM To: Multiple recipients of list ORACLE-L The comparisons look good for MySQL... not bad for others, but better for mySQL than some comments by some folks on the list would have led me to believe. Anyone here have major gripes about mySQL that oracle solved? -Original Message- Sent: Wednesday, August 01, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Interesting site... Since I am not familiar with some of the other databases, are all the ones listed there 3 versions old or just Oracle? I noticed DB2 was 2 versions old. > -Original Message- > From: Dwayne Cox [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 9:56 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: off topic--oracle Vs ms sql > > > Try this site... > > http://www.mysql.com/information/crash-me.php > > On Mon, 30 Jul 2001 13:29:28 -0800 > "Ravindra Basavaraja" <[EMAIL PROTECTED]> wrote: > > > Does anyone have any doc or links that compares oracle and ms sql. > > > > Also what are the equivalent data types in ms sql for oracle's lobs. > > > > Thanks > > Ravindra > > > __ > Dwayne Cox > DBA, Development Dept. > Info Tech, Inc. > [EMAIL PROTECTED] > http://www.infotechfl.com > ___ > The opinions expressed are the author's own unless otherwise stated > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dwayne Cox > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED]
Re: Oracle vs. MySQL
>Anyone here have major gripes about >mySQL that oracle solved? I would not dream of developing without foreign keys/referential integrity. Oracle catches many of my programming mistakes as constraint errors before they mess things up and waste a lot of time. I don't get many constraint errors with my programs in fully debugged production environments, so I guess I might be able to get away without constraints there, but I generally would prefer not to take the chance as the consequences are more severe. However, I have not tried Postgres, which I understand is free and has referential integrity. Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gardner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle vs. MySQL
:) Thanks! -Original Message- Sent: Wednesday, August 01, 2001 1:41 PM To: Multiple recipients of list ORACLE-L Hi, Ross, I've got some experience with both 1. You dont have transaction (until the very recent versions, at least) 2. You dont have fererential integrity (FK is declared but not enforced) 3. Dont have views 4. Noting like PL/SQL 5. Reader blocks writer 6. Weak type support, for example can put 123456 to the number(1) field - further migration to Oracle may give you some pain Bright side it's fast (beats Oracle sometimes) and free. Regards, Vadim Gorbounov Oracle DBA ( not mySQL:) ) -Original Message- Sent: Wednesday, August 01, 2001 12:48 PM To: Multiple recipients of list ORACLE-L The comparisons look good for MySQL... not bad for others, but better for mySQL than some comments by some folks on the list would have led me to believe. Anyone here have major gripes about mySQL that oracle solved? -Original Message- Sent: Wednesday, August 01, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Interesting site... Since I am not familiar with some of the other databases, are all the ones listed there 3 versions old or just Oracle? I noticed DB2 was 2 versions old. > -Original Message- > From: Dwayne Cox [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 9:56 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: off topic--oracle Vs ms sql > > > Try this site... > > http://www.mysql.com/information/crash-me.php > > On Mon, 30 Jul 2001 13:29:28 -0800 > "Ravindra Basavaraja" <[EMAIL PROTECTED]> wrote: > > > Does anyone have any doc or links that compares oracle and ms sql. > > > > Also what are the equivalent data types in ms sql for oracle's lobs. > > > > Thanks > > Ravindra > > > __ > Dwayne Cox > DBA, Development Dept. > Info Tech, Inc. > [EMAIL PROTECTED] > http://www.infotechfl.com > ___ > The opinions expressed are the author's own unless otherwise stated > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dwayne Cox > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing List
RE: Oracle vs. MySQL
I think, you can design an application that aware of those non rollback tech things and reverse the contain back properly, quite a lot of work need to be done here. regards, Sinardy -Original Message- Sent: Thursday, 2 August 2001 2:56 AM To: Multiple recipients of list ORACLE-L True, but how can they(MySQL guys) call it a RDBMS if they don't support transaction? Isn't the ACID is what the RDBMS is all about? Richard Ji >>> [EMAIL PROTECTED] 08/01/01 01:56PM >>> Certain things don't need transactions. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Wednesday, August 01, 2001 1:27 PM To: Multiple recipients of list ORACLE-L AFAIK on big thing 'missing' in mySQL is that it has no journalling (transaction logging) capabilities. So there's no transaction mgt.. rollbacks...etc.. if things bozo in the middle of a process.. you're dead. Restore from last backup and hope for the best. So you wouldn't want to use it for storing data that's really 'important'. Lots of web sites use it to manage connection states etc.. where if it crashes.. well. they just restart. I don't know if it handles replication.. or how well it would digest 10 GB of data ! I think the open source 'postgres' [sic ?] database is supposed to be more robust... It's now being supported and packaged by the Red Hat Linux people. In the long run, you get what you pay for ! -Original Message- Sent: Wednesday, August 01, 2001 11:48 AM To: Multiple recipients of list ORACLE-L The comparisons look good for MySQL... not bad for others, but better for mySQL than some comments by some folks on the list would have led me to believe. Anyone here have major gripes about mySQL that oracle solved? -Original Message- Sent: Wednesday, August 01, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Interesting site... Since I am not familiar with some of the other databases, are all the ones listed there 3 versions old or just Oracle? I noticed DB2 was 2 versions old. > -Original Message- > From: Dwayne Cox [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 9:56 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: off topic--oracle Vs ms sql > > > Try this site... > > http://www.mysql.com/information/crash-me.php > > On Mon, 30 Jul 2001 13:29:28 -0800 > "Ravindra Basavaraja" <[EMAIL PROTECTED]> wrote: > > > Does anyone have any doc or links that compares oracle and ms sql. > > > > Also what are the equivalent data types in ms sql for oracle's lobs. > > > > Thanks > > Ravindra > > > __ > Dwayne Cox > DBA, Development Dept. > Info Tech, Inc. > [EMAIL PROTECTED] > http://www.infotechfl.com > ___ > The opinions expressed are the author's own unless otherwise stated > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Dwayne Cox > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or th
Re: RE: Oracle vs Mysql
> DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > > Sounds like the old Oracle vs. Ingress battles. Oracle won because it > was > better at marketing. All detailed in the book "The Difference Between > God > and Larry Ellison". I can see it now -- MySQL, the Oracle of the free Bzzzt. Oracle won because it actually delivered a database that could be recovered from after a system crash. Which Ingres never did despite their claims to the contrary. And because Oracle's product could actually deliver performance very similar to Ingres, despite the unilateral RTI claims that their code was "vastly" superior. A similar situation to Sybase, really. It's really very simple: Ingres lost because they did not over the years deliver any major improvement to the original Uni-developed code. They simply milked it out all it could, then folded. Typical attitude back then. And I don't give a hoot what the book says: I WAS there, back then. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Pinto do Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: Oracle vs Mysql
if Oracle is offshoring its develeoping of its database, everyone else will also... so much for job security. anyone I heard postgre sql has multi-versioning? Is it implemented like Oracle? So UDB is the new DB2? Oracle claims that DB2 is not one database but a different database for different Operating Systems, is this true? Is it true with UDB? > > From: Mladen Gogala <[EMAIL PROTECTED]> > Date: 2004/01/19 Mon PM 11:04:26 EST > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: Re: Oracle vs Mysql > > It needs not to have the same capabilities, it needs to have capabilities that people > are using. The primary capabilities that people need, in my opinion, are a decent > scripting language, with the full complement of the database triggers, procedures, > packages and functions, ability to store/access/administer huge objects, hundreds > of gigabytes in size, a decent SQL implementation with plethora of functions and a > support for standard APIs like JDBC, ODBC, OLE and DBI. A good compiler support > with something similar to long extinct SQL*Module (originally an IBM technology) > and > there would be huge number of users. Fortunately for oracle, MySQL still has problems > with the most basic things: transactions, versioning, locking and SQL > implementation. > My conclusion is that MySQL will never be much more then a toy, despite the hype, > catchy name and apparent popularity. I see much more dangerous adversaries in > UDB (artist formerly known as DB2) and PostgresSQL. If IBM decides to play open > source on Unix, and there are rumors of IBM musing over such a move, Oracle > would most probably be toast. I must say that after some oracle's mischiefs, I > wouldn't be the last one to defect and switch the databases. I wasn't the last one > to leave DEC either, despite the fact that I was teaching VMS courses in 1992. > My point is that Oracle is extremely feature rich. Very few people are using more > then 20% of the database capabilities. Initially, in V8, I worked hard to learn about > the Object PL/SQL, datatypes and classes. Believe it or not, I've never seen it used > in production. By now, I've forgotten it all. It's almost the same situation with > Java > in the database. Very few are using it. Most people test it, then say "aha!" and > move > on. Those two features will not make a whole lot of difference when a viable > competitor > emerges. Oracle 10g was written, for the most part outside of US. With beta testing > this closed and restricted, it's not going to be tested thoroughly, not even close > to thoroughly. > What we are likely to get is an unstable, buggy and almost unusable "gridlock" > version. > Competitor might emerge sooner then some people are realizing. > > On 2004.01.19 20:42, [EMAIL PROTECTED] wrote: > > If MySQL comes to have the same capabilities that many people expect > > from Oracle, marketing will have no effect. The huge differential in > > price > > point will be all that matters. > > > > > > Jared > > > > > > > > > > > > > > DENNIS WILLIAMS <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 01/19/2004 04:04 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > cc: > > Subject:RE: Oracle vs Mysql > > > > > > Sounds like the old Oracle vs. Ingress battles. Oracle won because it was > > better at marketing. All detailed in the book "The Difference Between God > > and Larry Ellison". I can see it now -- MySQL, the Oracle of the free > > databases. > > > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Wednesday, January 14, 2004 4:39 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Ryan, > > > > It's postgres.org. I'm not sure how they generate the > > operating > > revenue they need, but that's why they are not advertising like MySql AB > > is. > > > > Dick Goulet > > Senior Oracle DBA > > Oracle Certified 8i DBA > > > > -Original Message- > > Sent: Wednesday, January 14, 2004 5:05 PM > > To: Multiple recipients of list ORACLE-L > > > > > > i thought postgre was a for profit company? how do they generate revenues? > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PRO
RE: Re: Oracle vs Mysql
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Tuesday, 20 January 2004 23:59 > To: Multiple recipients of list ORACLE-L > Subject: Re: Re: Oracle vs Mysql > > > if Oracle is offshoring its develeoping of its database, > everyone else will also... so much for job security. > > anyone I heard postgre sql has multi-versioning? Is it > implemented like Oracle? No, its implementation is different. For deletes, it doesn't reclaim space immediately. Instead, it marks a flag indicating at what point (analogous to SCN) the row became deleted, and relevant transactions can still see the row, whereas future transactions can't. Works quite well in practice. The obvious question is "what happens to these rows once all transactions have moved on?". Currently, there's a maintenance job (called Vacuum) that needs to be run to reclaim the space ... at the Linix.conf.au last week there was a presentation that showed a new lazy daemon that would do this automagically. Updates are handled as a delete+insert, with similar control. One big benefit - you'll never have to size a rollback/undo tablespace, or see 1555 errors :-) :-) :-) > So UDB is the new DB2? Oracle claims that DB2 is not one > database but a different database for different Operating > Systems, is this true? Is it true with UDB? It used to be, but IBM is tidying things up. The Linux/Unix/Windoze stuff is all identical (it's the old "common server" reborn), and they've made a big effort at harmonising the zOS (and to a lesser extent, AS400) forms. The biggest improvement in the last couple of years was ANSI standard stored procedures (ANSI "Stored Persistent Modules"). Very nice - the structured error handling alone is amazingly good. You can still find the occasional "version lag", where one platform won't have a new feature until a minor version later than another. Ciao Fuzzy (my coffee coaster has something written on it ... "IBM DB2 Certified Database ... " ... what the *#&^$!?!?) :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).