Re: MySQL - PostgreSQL migration

2002-11-20 Thread the hatter
On Tue, 19 Nov 2002, Chris Devers wrote: I've put copies of Pg on pretty old equipment it ran tolerably well -- good enough to put sample databases in, write code against it, etc. I've tried putting the demo version of Oracle on somewhat better hardware (sorry, it's been a while I forget

RE: MySQL - PostgreSQL migration

2002-11-20 Thread Mark Buckle
Title: RE: MySQL - PostgreSQL migration And I am one of those scapegoats, ;-) On a side-note, there are enormous numbers of people whose entire career consists of Oracle DBA or Oracle Consultant, many of whom are entirely ignorant of concepts I would consider fundamental to the role. I

RE: MySQL - PostgreSQL migration

2002-11-20 Thread Mark Buckle
Title: RE: MySQL - PostgreSQL migration Correction, -Original Message- From: Steve Keay [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 00:43 To: [EMAIL PROTECTED] Subject: Re: MySQL - PostgreSQL migration On Tue, Nov 19, 2002 at 05:43:32PM -0500, Chris Devers wrote: On Tue

Re: MySQL - PostgreSQL migration

2002-11-20 Thread Chris Benson
On Wed, Nov 20, 2002 at 02:06:44AM +, Paul Makepeace wrote: On Tue, Nov 19, 2002 at 06:49:52PM -0500, Chris Devers wrote: I've tried putting the demo version of Oracle on somewhat better hardware (sorry, it's been a while I forget all specs) and, aside from the fact You really do have

Re: MySQL - PostgreSQL migration

2002-11-20 Thread Dirk Koopman
On Wed, 2002-11-20 at 14:25, Chris Benson wrote: Tell me about it: Memory: 12G real, 5823M free, 1999M swap free Only 5.8GB free because I restarted Solaris this morning to change max shmem to 4GB ... it'll be gone by tonight and the app (Oracle Financials) still runs like a dog.

Re: MySQL - PostgreSQL migration

2002-11-20 Thread Chris Benson
On Wed, Nov 20, 2002 at 02:46:36PM +, Dirk Koopman wrote: That is a insult to several lurchers that I know and love. The simile I think you are groping for is: like a snail on mogodon. I stand corrected ... until I can think of a metaphor that conjures the massive bulk that is Oracle

Re: MySQL - PostgreSQL migration

2002-11-19 Thread Walt Mankowski
On Mon, Nov 18, 2002 at 11:39:45AM -, Mark Buckle wrote: Good, is there any real commercial benefit to an individual acquiring a good knowledge of PostgreSQL rather than Oracle SQLServer ? Be careful with your terminology. Oracle is Oracle; SQL Server is Microsoft's RDBMS. Having said

Re: MySQL - PostgreSQL migration

2002-11-19 Thread Chris Devers
On Tue, 19 Nov 2002, Walt Mankowski wrote: On Mon, Nov 18, 2002 at 11:39:45AM -, Mark Buckle wrote: Good, is there any real commercial benefit to an individual acquiring a good knowledge of PostgreSQL rather than Oracle SQLServer ? Be careful with your terminology. Oracle is Oracle;

Re: MySQL - PostgreSQL migration

2002-11-19 Thread David Cantrell
On Tue, Nov 19, 2002 at 05:43:32PM -0500, Chris Devers wrote: But is it safe to say that in some ways -- and for most things that one would be likely to do while learning at home, perhaps *all* ways -- Oracle and PostgreSQL can be treated as if they are interchangeable? Depends what you want

Re: MySQL - PostgreSQL migration

2002-11-19 Thread Chris Devers
On Tue, 19 Nov 2002, David Cantrell wrote: On Tue, Nov 19, 2002 at 05:43:32PM -0500, Chris Devers wrote: Put another way, Oracle skills may be more marketable, but paying for the right licenses hardware to learn Oracle may be unfeasible for most. They used to do a free

Re: MySQL - PostgreSQL migration

2002-11-19 Thread Steve Keay
On Tue, Nov 19, 2002 at 05:43:32PM -0500, Chris Devers wrote: On Tue, 19 Nov 2002, Walt Mankowski wrote: On Mon, Nov 18, 2002 at 11:39:45AM -, Mark Buckle wrote: Good, is there any real commercial benefit to an individual acquiring a good knowledge of PostgreSQL rather than Oracle

Re: MySQL - PostgreSQL migration

2002-11-19 Thread Paul Makepeace
On Tue, Nov 19, 2002 at 06:49:52PM -0500, Chris Devers wrote: I've tried putting the demo version of Oracle on somewhat better hardware (sorry, it's been a while I forget all specs) and, aside from the fact that setting everything up was much more of a pain, the strain on the machine was much

RE: MySQL - PostgreSQL migration

2002-11-18 Thread Mark Buckle
Title: RE: MySQL - PostgreSQL migration Hhhhm, I'm worried by statements like this :- How close is PostgreSQL to Oracle in terms of its SQL capabilities? It's done everything that I've expected it to. Triggers and SPs can be written in several languages with PostgreSQL. Including

Re: MySQL - PostgreSQL migration

2002-11-18 Thread Roger Burton West
On Mon, Nov 18, 2002 at 09:28:49AM -, Mark Buckle wrote: Is PostgreSQL ever going to be a database you'd bet the company on ? I have. I won. I wouldn't use the Perl-embedded-statements in Postgres in a production server, because there's no equivalent of mod_perl, so you're stuck with

RE: MySQL - PostgreSQL migration

2002-11-18 Thread Mark Buckle
Title: RE: MySQL - PostgreSQL migration Good, is there any real commercial benefit to an individual acquiring a good knowledge of PostgreSQL rather than Oracle SQLServer ? I'm just looking at my next private own-time project ? Cheers, Mark. -Original Message- From: Roger Burton

Re: MySQL - PostgreSQL migration

2002-11-18 Thread Roger Burton West
On Mon, Nov 18, 2002 at 11:39:45AM -, Mark Buckle wrote: Good, is there any real commercial benefit to an individual acquiring a good knowledge of PostgreSQL rather than Oracle SQLServer ? PostgreSQL doesn't go out of its way to make things difficult for the programmer. Therefore there isn't

Re: MySQL - PostgreSQL migration

2002-11-18 Thread Toby Corkindale
On Mon, Nov 18, 2002 at 09:28:49AM -, Mark Buckle wrote: Hhhhm, I'm worried by statements like this :- How close is PostgreSQL to Oracle in terms of its SQL capabilities? It's done everything that I've expected it to. Triggers and SPs can be written in several languages with

Re: MySQL - PostgreSQL migration

2002-11-17 Thread David Cantrell
On Sun, Nov 17, 2002 at 05:30:52PM +, Paul Makepeace wrote: Does anyone here have experience using both MySQL and PostgreSQL to some reasonable degree they could offer tips or anecdotes on moving from one t'other? I'd be interested in any other comparative experiences too like speed, ease