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 wonder if there's anyone who is an official Postgress DBA who
 is not really doing a load of sysadmin/developer work as well?
 Perhaps PG shops are enlightened enough not to require a scapegoat for
 database problems?




**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**




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


Sorry, there was a comma @,', or 'or' mising in that sentence!


  Be careful with your terminology. Oracle is Oracle; SQL Server is
  Microsoft's RDBMS. Having said that, the main commercial benefit is
  that there are a hell of a lot more Oracle shops in the world than
  PostgreSQL shops.
 




**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**




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 Perl, assuming you're entirely mad. Actually, it's not _that_
 bad, but still not something I'd want to use in production.


Is PostgreSQL ever going to be a database you'd bet the company on ?


Mark




**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**




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 West [mailto:[EMAIL PROTECTED]]
Sent: 18 November 2002 10:27
To: [EMAIL PROTECTED]
Subject: Re: MySQL - PostgreSQL migration



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
interpretation overheads. But Postgres itself? No problem.


Roger




**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**




RE: Usernames?

2002-11-06 Thread Mark Buckle
Title: RE: Usernames?





Or the bug in DBD::Ingres ( or in ingres itself ) which make prepared statements fail randomly

-Original Message-
From: David Cantrell [mailto:[EMAIL PROTECTED]]
Sent: 06 November 2002 14:21
To: [EMAIL PROTECTED]
Subject: Re: Usernames?



On Wed, Nov 06, 2002 at 12:47:09PM +, Paul Makepeace wrote:
 On Wed, Nov 06, 2002 at 11:13:43AM +, David Cantrell wrote:
  Stupid programmers forgetting to appropriately quote/escape data before
  stuffing it into a database.
  
  INSERT INTO users (userid, username, passwd) VALUES
  (usersequence.nextval, '$username', '$passwdmd5hash')
 
 Why would anyone not use bound variables?


Stupidity and/or ignorance. I used to do that, and I plead ignorance.


-- 
David Cantrell | Degenerate | http://www.cantrell.org.uk/david


 When a woman has a man on a string, controlling his every thought
 and motion, backbone in said man is not a requirement.
 -- Ken, in alt.2eggs.sausage.beans.tomatoes.2toast.largetea.cheerslove




**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**




O'Reilly Perl/XML book

2002-04-25 Thread Mark Buckle
Title: O'Reilly Perl/XML book






Has any-one seen this beast in the wild yet ?
Mark.




**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

**