Re: Oracle vs Mysql

2004-01-25 Thread Craig I. Hagan
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

RE: Re[2]: Oracle vs Mysql

2004-01-21 Thread Igor Neyman
]: Oracle vs Mysql At 03:29 PM 1/20/2004, you wrote: I do indeed. Rumor was that rpt/rpf was written by Larry himself. Now I understand! I once applied for a job at Oracle, and got asked: What do you think about RPT/RPF. My answer: Probably som hobby-project of one or another developer, which

RE: Re[2]: Oracle vs Mysql

2004-01-21 Thread Goulet, Dick
yup Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Carel-Jan Engel [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 20, 2004 5:29 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Re[2]: Oracle vs MysqlAt 03:29 PM 1/20/2004, you wrote:

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mladen Gogala
On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Jonathan, I've been around for a long time.

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Nuno Souto
- Original Message - Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle Beat ya: Oracle Add-In for Lotus 123. Using Ora*Net (Async), V4.1.4. 1987. And demoed to the press that same year. g,dr

Re: Re: Oracle vs Mysql

2004-01-20 Thread ryan.gaffuri
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

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Thater, William
Mladen Gogala scribbled on the wall in glitter crayon: On 2004.01.19 23:39, Jonathan Gennick wrote: I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mercadante, Thomas F
Ahhh. Sql*Calc, Sql*Graph, Sqr EasySqr. Those were the good old days. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, January 20, 2004 8:05 AM To: Multiple recipients of list ORACLE-L Mladen Gogala scribbled on the wall in glitter crayon: On

RE: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
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

RE: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
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

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Jesse, Rich
Then here's a rare treat for you! I *loved* SQL mods in RDB. I could make a program in MACRO, BASIC, FORTRAN, BLISS, Ada, DIBOL, or Mladen's favorite COBOL, and could effortlessly have them do DB work. I also didn't have to hunt thru all the source for a single SQL statement since they were in

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread KENNETH JANUSZ
Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards? No hard drives? My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 8:39 AM Careful Mladen, your revealing your

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mercadante, Thomas F
The RPT RPF Oracle class was what made me go looking very quickly for a batch Oracle tool. Then I found SQR. (This was all before PL/SQL and the current versions of Oracle Reports). We bought it and the rest was history. Why Oracle didn't buy SQR when they had a chance amazes me. Tom

RE: Oracle vs Mysql

2004-01-20 Thread Orr, Steve
Title: Message Most people only use a fraction of Oracle's featuresand some are deceived bythe Oracle Marketeerswho tell themthatthey 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

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Jesse, Rich
I've got my GX21-9129-9 right here in front of me. It should be in a museum... I'll take Obscure Geek References for $800, Alex. Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message-

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mladen Gogala
I do indeed. Rumor was that rpt/rpf was written by Larry himself. On 01/20/2004 09:39:34 AM, Goulet, Dick wrote: Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday,

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mladen Gogala
On 01/20/2004 08:04:33 AM, Thater, William wrote: Mladen Gogala scribbled on the wall in glitter crayon: oh damn, have we been at this too long?;-) Yes, we probably have. I must say that the spirit of Oracle Corp. has changed significantly since the days of Geoff Squire, Chris Ellis, Richard

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
Probably because they were dropping RPT RPF SQR smells a lot like it, YUCK! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 10:09 AM To: Multiple recipients of list ORACLE-L The RPT RPF Oracle class was what made me go

RE: Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Stephane Faroult
[snip] 120 col. punch cards? You had a high-density model. Mine only had 80 cols, of which 72 were usable for my goto-happy Fortran statements. SF No hard drives? My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
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

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
Careful Mladen, your revealing your age!! Bet you remember RPT RPF as well!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 2:04 AM To: Multiple recipients of list ORACLE-L On 2004.01.19 23:39, Jonathan Gennick wrote: I

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mladen Gogala
On 01/20/2004 10:09:34 AM, KENNETH JANUSZ wrote: Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards? No hard drives? My $0.02 worth, Ken Janusz, CPIM I've never done anything with System/3. My first IBM was 3084 with MVS and IMS, running on 8M RAM. After an upgrade, it was a

Re[2]: Oracle vs Mysql

2004-01-20 Thread Jonathan Gennick
Tuesday, January 20, 2004, 9:19:44 AM, Goulet, Dick ([EMAIL PROTECTED]) wrote: GD Well, PostGreSql has all of those features, but handling 100GB? Not sure not sure I'd trust GD it that far. You know, I talked to someone at last year's MySQL conference who was using MySQL to manage three

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Orr, Steve
RPT was great stuff. In addition to SELECT statements it could do full DML, DDL, and DCL (I think.) Like Unix it was just particular on who it was friendly with. :-) Then there was RPT2C. Now there's perl. Eschewing the pointy-clicky stuff. -Original Message- Sent: Tuesday, January

Re[4]: Oracle vs Mysql

2004-01-20 Thread Jonathan Gennick
Tuesday, January 20, 2004, 9:34:25 AM, Jesse, Rich ([EMAIL PROTECTED]) wrote: JR Then here's a rare treat for you! I *loved* SQL mods in RDB. I could make JR a program in MACRO, BASIC, FORTRAN, BLISS, Ada, DIBOL, or Mladen's favorite JR COBOL, and could effortlessly have them do DB work. Yep!

Re: Oracle vs Mysql

2004-01-20 Thread Mladen Gogala
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? --

RE: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
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?

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
YES! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 10:10 AM To: Multiple recipients of list ORACLE-L Do you remember IBM System 3/10? RPGII flat files? 120 col. punch cards? No hard drives? My $0.02 worth, Ken Janusz, CPIM

Re: Oracle vs Mysql

2004-01-20 Thread Daniel Hanks
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

Re: Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread KENNETH JANUSZ
The old IBM System3 machines used 120 col. punch cards. And initially they had no HD's. Everything was done with cards and a reader/sorter. To compile a program you took the code you wrote, punched it into cards and then put it behind a stack of cards that was the compiler. The machine read

Re[2]: Oracle vs Mysql

2004-01-20 Thread Jonathan Gennick
Tuesday, January 20, 2004, 12:44:43 PM, Daniel Hanks ([EMAIL PROTECTED]) wrote: DH nd to be fair, MySQL _does_ offer foreign key constraints (it used to not, though), but only DH (iirc) if you use the 'Innodb' table type. My experience recently was just the opposite. I could create foreign key

RE: Oracle vs Mysql

2004-01-20 Thread DENNIS WILLIAMS
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

RE: Oracle vs Mysql

2004-01-20 Thread Jesse, Rich
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:

Re: Oracle vs Mysql

2004-01-20 Thread Mladen Gogala
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

Re[2]: Oracle vs Mysql

2004-01-20 Thread Jonathan Gennick
Tuesday, January 20, 2004, 1:29:25 PM, DENNIS WILLIAMS ([EMAIL PROTECTED]) wrote: DW I can recall editorials debating whether Unix/Oracle would ever be DW industrial strength enough to support critical applications. I admit to not being involved in databases that far back, but I've read enough to

Re: Oracle vs Mysql

2004-01-20 Thread Daniel Hanks
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

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread eric king
What RPT and RPF exactly are? Are they some sort of reporting tool? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 11:19 AM RPT was great stuff. In addition to SELECT statements it could do full DML, DDL, and DCL (I

RE: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
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

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
Jonathan, The only reason MySql is known better is that big mouth equal to Bill Gates in Finland. Otherwise PostGreSql is the much better product. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 1:49 PM To: Multiple

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Orr, Steve
Yupp. RPF=report formatter or some such. -Original Message- eric king Sent: Tuesday, January 20, 2004 1:19 PM To: Multiple recipients of list ORACLE-L What RPT and RPF exactly are? Are they some sort of reporting tool? - Original Message - To: Multiple recipients of list

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
Eric, They were the precusors to Oracle reports. RPT was the report extraction tool, and RPF was the report formatter. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 3:19 PM To: Multiple recipients of list ORACLE-L

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Bellow, Bambi
But, unless you have old diskettes... you'll never see them. They died with the demise of v5. -Original Message- Sent: Tuesday, January 20, 2004 2:29 PM To: Multiple recipients of list ORACLE-L Yupp. RPF=report formatter or some such. -Original Message- eric king Sent:

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Mladen Gogala
On 01/20/2004 03:29:33 PM, Goulet, Dick wrote: Jonathan, The only reason MySql is known better is that big mouth equal to Bill Gates in Finland. Otherwise PostGreSql is the much better product. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA Dick, when you are talking about big

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread mkline1
I know I used to set up RPT and do all sorts of complex updating things. At the State and with things coming from mainframes, the data organization seemed to lend itself well to RPT. Since the organization was like of loops within loops, I could take the high order update and then loop through

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Tanel Poder
Dick, when you are talking about big mouth from Finland, you probably don't refer to Pamela Anderson, also from Finland? The other person from Finland, whom I will not mention except by the first name (Linus) should be given credit for a wonderful OS that is successfully breaking the MS

RE: Re[2]: Oracle vs Mysql

2004-01-20 Thread Goulet, Dick
If Mr Torvalds needs a security blanket, I'd be happy to send him several. Yes he crafted a wonderful OS I sincerely hope he knocks Billy Gates down to size. Seems to be doing one heck of a job at it, even with SCO on MicroSlop's side. MS Anderson appears headed for the twilight, thank GOD.

RE: Oracle vs Mysql

2004-01-20 Thread DENNIS WILLIAMS
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 -

RE: Oracle vs Mysql

2004-01-20 Thread Jesse, Rich
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

RE: Re: Oracle vs Mysql

2004-01-20 Thread Grant Allen
-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

Re: Re[2]: Oracle vs Mysql

2004-01-20 Thread Carel-Jan Engel
At 03:29 PM 1/20/2004, you wrote: I do indeed. Rumor was that rpt/rpf was written by Larry himself. Now I understand! I once applied for a job at Oracle, and got asked: What do you think about RPT/RPF. My answer: Probably som hobby-project of one or another developer, which, after demonstration

Re: Oracle vs Mysql

2004-01-19 Thread eric king
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

RE: Oracle vs Mysql

2004-01-19 Thread Goulet, Dick
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

RE: Oracle vs Mysql

2004-01-19 Thread DENNIS WILLIAMS
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

RE: Oracle vs Mysql

2004-01-19 Thread Jared . Still
-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

Re: Oracle vs Mysql

2004-01-19 Thread Mladen Gogala
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

Re: RE: Oracle vs Mysql

2004-01-19 Thread Nuno Pinto do Souto
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

Re[2]: Oracle vs Mysql

2004-01-19 Thread Jonathan Gennick
Monday, January 19, 2004, 11:04:26 PM, Mladen Gogala ([EMAIL PROTECTED]) wrote: MG A good compiler support MG with something similar to long extinct SQL*Module (originally an IBM technology) I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who

Re: Oracle vs Mysql

2004-01-19 Thread Jared Still
[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

Re: Oracle vs Mysql

2004-01-16 Thread Nuno Souto
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

Re: Oracle vs Mysql

2004-01-15 Thread Nuno Souto
- 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

Re: Oracle vs Mysql

2004-01-15 Thread Mladen Gogala
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

Oracle vs Mysql

2004-01-14 Thread Mujeeb Chowdhry
Hi, I've been asked by management to explore the pros and cons of Mysqlvs Oracle. The database in question will be a web based text and multimedia retrieval system. The size will be around 100 Gb.Can someonelet me know the advantages of Oracle over Mysql or the problems we can face

RE: Oracle vs Mysql

2004-01-14 Thread Jesse, Rich
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:

Re: Oracle vs Mysql

2004-01-14 Thread Mladen Gogala
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

Re: Oracle vs Mysql

2004-01-14 Thread Ryan
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

Re: Oracle vs Mysql

2004-01-14 Thread Mladen Gogala
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,

RE: Oracle vs Mysql

2004-01-14 Thread Masroor Farooqi
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

Re: Oracle vs Mysql

2004-01-14 Thread eric king
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

Re: Oracle vs Mysql

2004-01-14 Thread Tanel Poder
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

Re: Oracle vs Mysql

2004-01-14 Thread Ryan
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

RE: Oracle vs Mysql

2004-01-14 Thread Jesse, Rich
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

RE: Oracle vs Mysql

2004-01-14 Thread Grant Allen
-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

Re: Oracle vs Mysql

2004-01-14 Thread Tanel Poder
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 Mysqlvs Oracle. The database in question will be a web based text and multimedia retrieval system. The size will be around 100

RE: Oracle vs. MySQL

2001-08-02 Thread Mohan, Ross
:) 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

RE: Oracle vs. MySQL

2001-08-02 Thread Sinardy
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

Oracle vs. MySQL

2001-08-01 Thread Mohan, Ross
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:

RE: Oracle vs. MySQL

2001-08-01 Thread Farnsworth, Dave
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

RE: Oracle vs. MySQL

2001-08-01 Thread Farnsworth, Dave
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

RE: Oracle vs. MySQL

2001-08-01 Thread Vadim Gorbounov
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

RE: Oracle vs. MySQL

2001-08-01 Thread Orr, Steve
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

RE: Oracle vs. MySQL

2001-08-01 Thread Christopher Spence
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

RE: Oracle vs. MySQL

2001-08-01 Thread Christopher Spence
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

RE: Oracle vs. MySQL

2001-08-01 Thread Jon Baker
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

RE: Oracle vs. MySQL

2001-08-01 Thread Richard Ji
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

Re: Oracle vs. MySQL

2001-08-01 Thread Tim Gardner
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