Re: Getting started with Postgres or MySQL

2007-02-03 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/03/07 12:26, David Baron wrote: > OK, I withdraw the question. Will find useful answers elsewhere or stay with > OpenOffice's DB (as I said, not all that bad!). > > The flame war has gotten too ugly. I think we can argue about the merits of >

Re: Getting started with Postgres or MySQL

2007-02-03 Thread David Baron
OK, I withdraw the question. Will find useful answers elsewhere or stay with OpenOffice's DB (as I said, not all that bad!). The flame war has gotten too ugly. I think we can argue about the merits of one of the other programs with a bit more common courtesy and civility and end the discussion

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Roberto C. Sanchez
On Fri, Feb 02, 2007 at 01:26:13PM +0100, Danesh Daroui wrote: > Roberto C. Sanchez wrote: > > > >Really? What should I learn? I've given specific things where your > >knowledge of/experience with databases is clearly deficient. Care to > >be specific and refrain from making sweeping statements

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Danesh Daroui
Ron Johnson wrote: > On 02/02/07 07:54, Dan H. wrote: >> Danesh Daroui wrote: > >>> 5. Again back to your example, yes, the PayPal web site offers you to >>> choose the data by using a combo box and not inserting it manually. So >>> the date which is sent to the database is definitely correct befo

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/02/07 07:54, Dan H. wrote: > Danesh Daroui wrote: > >> 5. Again back to your example, yes, the PayPal web site offers you to >> choose the data by using a combo box and not inserting it manually. So >> the date which is sent to the database is d

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Dan H.
Danesh Daroui wrote: > 5. Again back to your example, yes, the PayPal web site offers you to > choose the data by using a combo box and not inserting it manually. So > the date which is sent to the database is definitely correct before > inserting. This is one of the most pathetic things I've eve

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Dan H.
Danesh Daroui wrote: > 5. Again back to your example, yes, the PayPal web site offers you to > choose the data by using a combo box and not inserting it manually. So > the date which is sent to the database is definitely correct before > inserting. This is one of the most pathetic things I've eve

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Dan H.
Danesh Daroui wrote: > 5. Again back to your example, yes, the PayPal web site offers you to > choose the data by using a combo box and not inserting it manually. So > the date which is sent to the database is definitely correct before > inserting. This is one of the most pathetic things I've eve

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Roberto C. Sanchez
On Fri, Feb 02, 2007 at 12:15:31PM +0100, Danesh Daroui wrote: > > 1. The one who should learn something is you, and not me. So, I would > suggest you to learn something basic about database concepts and I don't > care if you ever come back or not! Really? What should I learn? I've given spec

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Danesh Daroui
1. The one who should learn something is you, and not me. So, I would suggest you to learn something basic about database concepts and I don't care if you ever come back or not! 2. You do not have to involve yourself in any single topic you see in the forum, specially if you are not asked to d

Re: Re: Re: Getting started with Postgres or MySQL

2007-02-02 Thread Roberto C. Sanchez
On Thu, Feb 01, 2007 at 09:10:27PM -0500, Angelo Bertolli wrote: > > But you're coming from an angle where people know or must learn all of > that just before they're able to even start. Don't you see how not > having to learn that is faster for some people? > Ever have to share the road with so

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Roberto C. Sanchez
On Fri, Feb 02, 2007 at 05:53:52AM +0100, Danesh Daroui wrote: > > What a useless and boring discussion you have started Ron!! Do you have > to just be against everyone who thinks MySQL has at least some good > features too? I just dropped the discussion when realized that it goes > nowhere, but i

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/01/07 23:41, Angelo Bertolli wrote: > Ron Johnson wrote: >> That splatting noise is my hurl splatting onto the opposite wall. >> >> Remind me never to hire you. >> >> Are you sure you don't work for Microsoft? Or maybe you're an MCSE? >> >> It's

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Angelo Bertolli
Ron Johnson wrote: > That splatting noise is my hurl splatting onto the opposite wall. > > Remind me never to hire you. > > Are you sure you don't work for Microsoft? Or maybe you're an MCSE? > > It's confirmed. You *are* an MCSE. For that I may implement my next database with MySQL (instead of

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Danesh Daroui
Ron Johnson wrote: > On 02/01/07 20:10, Angelo Bertolli wrote: >> Roberto C. Sanchez wrote: >>> On Thu, Feb 01, 2007 at 01:16:18PM -0500, Angelo Bertolli wrote: >>> (2) MySQL is a shorter learning curve for new users >>> What? In what way? Learning to develop against MySQL

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Greg Folkert
On Thu, 2007-02-01 at 20:37 -0600, Ron Johnson wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 02/01/07 20:10, Angelo Bertolli wrote: > > Roberto C. Sanchez wrote: > >> On Thu, Feb 01, 2007 at 01:16:18PM -0500, Angelo Bertolli wrote: > >> > >>> (2) MySQL is a shorter learning cu

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/01/07 20:10, Angelo Bertolli wrote: > Roberto C. Sanchez wrote: >> On Thu, Feb 01, 2007 at 01:16:18PM -0500, Angelo Bertolli wrote: >> >>> (2) MySQL is a shorter learning curve for new users >>> >>> >> What? In what way? Learning to dev

Re: Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Angelo Bertolli
Roberto C. Sanchez wrote: > On Thu, Feb 01, 2007 at 01:16:18PM -0500, Angelo Bertolli wrote: > >> (2) MySQL is a shorter learning curve for new users >> >> > What? In what way? Learning to develop against MySQL is no harder or > easier than learning to develop against PostgreSQL (besides

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/01/07 17:03, Roberto C. Sanchez wrote: > On Thu, Feb 01, 2007 at 04:37:39PM -0500, Angelo Bertolli wrote: [snip] > Yes, they were "fast" when computers were still slow. Unfortunately, > many people were willing to give up data integrity in excha

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Roberto C. Sanchez
On Thu, Feb 01, 2007 at 04:37:39PM -0500, Angelo Bertolli wrote: > > The fundamental difference is licensing. If Windows was open source, I > certainly wouldn't bother disagreeing with them if they specified which > users would benefit more from Windows. And on that issue MySQL wins > because

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Roberto C. Sanchez
On Thu, Feb 01, 2007 at 01:16:18PM -0500, Angelo Bertolli wrote: > > (1) MySQL is shown to be faster in a single-user environment than > Postgres, especially with complicated SELECT statements > IIRC, this does not hold for transactional tables. So, we are back to the "if you don't care about y

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Angelo Bertolli
Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/01/07 12:16, Angelo Bertolli wrote: I've been debating whether or not to make a comment on this discussion, but it finally got to me. I think you're being way too hard on MySQL considering the fact that this question ori

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/01/07 07:31, Max Hyre wrote: > Roberto C. Sanchez wrote: >> On Wed, Jan 31, 2007 at 02:54:01PM -0900, Joshua J. Kugler wrote: >>> In that same document, they give the reason for doing so: >>> "The reason for using the preceding rules in non-stric

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/01/07 12:16, Angelo Bertolli wrote: > I've been debating whether or not to make a comment on this discussion, > but it finally got to me. I think you're being way too hard on MySQL > considering the fact that this question originated from the id

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Angelo Bertolli
I've been debating whether or not to make a comment on this discussion, but it finally got to me. I think you're being way too hard on MySQL considering the fact that this question originated from the idea of using a database backend for OpenOffice.org. Yeah, I didn't like "MySQL is definitel

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Max Hyre
Roberto C. Sanchez wrote: > On Wed, Jan 31, 2007 at 02:54:01PM -0900, Joshua J. Kugler wrote: > >> In that same document, they give the reason for doing so: >> >> "The reason for using the preceding rules in non-strict >> mode is that we can't check these conditions until the >> statement has begu

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Dave Ewart
On Thursday, 01.02.2007 at 06:18 +0100, Danesh Daroui wrote: > About allowing corrupted data, it is not the responsibility of database > engine to verify if the data is valid or not since the database engine > only "Manages" data and not validate. It depends what you mean by 'validate'. The da

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/31/07 23:18, Danesh Daroui wrote: > Roberto C. Sanchez wrote: >> On Wed, Jan 31, 2007 at 02:54:01PM -0900, Joshua J. Kugler wrote: >> [snip] > Maybe MySQL is not the best database engine in the world but it is one > the best engines. I have wor

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Roberto C. Sanchez
On Thu, Feb 01, 2007 at 06:18:03AM +0100, Danesh Daroui wrote: > > Maybe MySQL is not the best database engine in the world but it is one > the best engines. I have worked on MySQL for several years and from four > years ago I have started to develop my own database engine inspired by > MySQL.

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Danesh Daroui
Roberto C. Sanchez wrote: On Wed, Jan 31, 2007 at 02:54:01PM -0900, Joshua J. Kugler wrote: In that same document, they give the reason for doing so: "The reason for using the preceding rules in non-strict mode is that we can't check these conditions until the statement has begun executing.

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Roberto C. Sanchez
On Wed, Jan 31, 2007 at 02:54:01PM -0900, Joshua J. Kugler wrote: > > In that same document, they give the reason for doing so: > > "The reason for using the preceding rules in non-strict mode is that we can't > check these conditions until the statement has begun executing. We can't just > rol

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Roberto C. Sanchez
On Wed, Jan 31, 2007 at 01:50:14PM -0900, Joshua J. Kugler wrote: > On Wednesday 31 January 2007 13:19, Roberto C. Sanchez wrote: > > > How do I get started here? > > > > First. Please do not use MySQL, unless you don't care about your data. > > Please stop this MySQL vs. PostgreSQL bashing. Eac

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Joshua J. Kugler
On Wednesday 31 January 2007 15:27, Ron Johnson wrote: > You're talking to someone who's been a DBA for 10 years; you will > not win this argument. Eh, so ya got three years on me. :) j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/31/07 17:54, Joshua J. Kugler wrote: > On Wednesday 31 January 2007 14:20, Ron Johnson wrote: >> On 01/31/07 16:50, Joshua J. Kugler wrote: >>> On Wednesday 31 January 2007 13:19, Roberto C. Sanchez wrote: > How do I get started here? Fi

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Joshua J. Kugler
On Wednesday 31 January 2007 14:20, Ron Johnson wrote: > On 01/31/07 16:50, Joshua J. Kugler wrote: > > On Wednesday 31 January 2007 13:19, Roberto C. Sanchez wrote: > >>> How do I get started here? > >> > >> First. Please do not use MySQL, unless you don't care about your data. > > > > Please sto

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/31/07 16:50, Joshua J. Kugler wrote: > On Wednesday 31 January 2007 13:19, Roberto C. Sanchez wrote: >>> How do I get started here? >> First. Please do not use MySQL, unless you don't care about your data. > > Please stop this MySQL vs. Postgre

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Joshua J. Kugler
On Wednesday 31 January 2007 13:19, Roberto C. Sanchez wrote: > > How do I get started here? > > First. Please do not use MySQL, unless you don't care about your data. Please stop this MySQL vs. PostgreSQL bashing. Each has their place. If users of MySQL don't care about their data, then I gue

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Roberto C. Sanchez
On Wed, Jan 31, 2007 at 07:17:48PM +0200, David Baron wrote: > I have an openoffice spreadsheet from which I want to generate two related > tables. I have tried most everything installed. > > Stuff from OpenOffice will generate a database with table entries named by > the > first line in the sp

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/31/07 12:29, Danesh Daroui wrote: > David Baron wrote: [snip] > MySQL is definitely best choice. If you have not still installed > latest version of MySQL do it as following: Well, if you *insist* on starting a war, so be it. MySQL is a toy pie

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Danesh Daroui
David Baron wrote: > I have an openoffice spreadsheet from which I want to generate two related > tables. I have tried most everything installed. > > Stuff from OpenOffice will generate a database with table entries named by > the > first line in the spreadsheet. This can, indeed, be queried, s

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Clive Menzies
On (31/01/07 19:17), David Baron wrote: > I have an openoffice spreadsheet from which I want to generate two related > tables. I have tried most everything installed. > > Stuff from OpenOffice will generate a database with table entries named by > the > first line in the spreadsheet. This can,

Getting started with Postgres or MySQL

2007-01-31 Thread David Baron
I have an openoffice spreadsheet from which I want to generate two related tables. I have tried most everything installed. Stuff from OpenOffice will generate a database with table entries named by the first line in the spreadsheet. This can, indeed, be queried, sort of. I would like to get thi