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-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: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

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 w

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

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 fo

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

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

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 hobbyist/e

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, 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 Ora

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 th

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 language

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 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: Roge

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 interp

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 >>

Re: MySQL -> PostgreSQL migration

2002-11-17 Thread Roger Burton West
On Sun, Nov 17, 2002 at 05:53:47PM +, David Cantrell wrote: >MySQL is faster, easier, less reliable and less capable. Going from MySQL >to PostgreSQL is pretty easy, you just need to be careful about permissions >on tables and using sequences instead of auto_increments. Going the other >way

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, ea