Re: [GENERAL] Any commercial shopping cart packages using postgresql?

2003-12-19 Thread Jeff Cave
> When they did the port, did they also "do the right thing" with foriegn > keys, stored procs, etc? No. The pg port was an unofficial thing and appears to be very much in its infancy. The objective of the individual who wrote it was to "get it working". While I haven't looked too closely at th

Re: [GENERAL] Any commercial shopping cart packages using postgresql?

2003-12-16 Thread Karsten Hilbert
> Ick... this product is *so* the poster child of the MySQL generation: ... > No foreign keys! Look at all those "DEFAULT '' NOT NULL" columns! What > are they thinking? You'd be surprised what the schema of most MEDICAL apps looks like (if they aren't built off MS ACCESS, that is...). And one wou

Re: [GENERAL] Any commercial shopping cart packages using postgresql?

2003-12-16 Thread Martijn van Oosterhout
On Tue, Dec 16, 2003 at 07:37:33PM -0800, Dann Corbit wrote: > But as for the DEFAULT '' NOT NULL entries, CODD and Date eventually > decided that NULL data was a big mistake. > > I tend to agree that every column should have a default and not be > allowed to become NULL. Just to keep end-user

Re: [GENERAL] Any commercial shopping cart packages using postgresql?

2003-12-16 Thread Alex Satrapa
Dann Corbit wrote: But as for the DEFAULT '' NOT NULL entries, CODD and Date eventually decided that NULL data was a big mistake. While SQL programmers are used to it, most end users with slim SQL familiarity will be pretty shocked when: And so, too, will man people with little or no understanding

Re: [GENERAL] Any commercial shopping cart packages using postgresql?

2003-12-16 Thread Dann Corbit
> -Original Message- > From: Alex Satrapa [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 16, 2003 7:24 PM > To: [EMAIL PROTECTED] > Subject: Re: [GENERAL] Any commercial shopping cart packages > using postgresql? > > > Alex Satrapa wrote: > > I&#

Re: [GENERAL] Any commercial shopping cart packages using postgresql?

2003-12-16 Thread Alex Satrapa
Alex Satrapa wrote: I'm currently exploring the Zelerate AllCommerce system http://allcommerce.sourceforge.net Ick... this product is *so* the poster child of the MySQL generation: # # Table structure for table 'addresses' # CREATE TABLE addresses ( objid

Re: [GENERAL] Any commercial shopping cart packages using postgresql?

2003-12-15 Thread James Moe
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 15 Dec 2003 09:13:49 +, Tony wrote: >excel it's previous incantation. > The spelling is "its", not "it's". "Its" is a possessive pronoun. "It's" is a contraction for "it is". - -- jimoe at sohnen-moe dot com pgp/gpg public key: ht

Re: [GENERAL] Any commercial shopping cart packages using postgresql?

2003-12-10 Thread Alex Satrapa
Mike Nolan wrote: I may need to move a web store to another hosting facility or rewrite it. I'm currently exploring the Zelerate AllCommerce system http://allcommerce.sourceforge.net I haven't even reached the stage of installing it yet. It's designed to run out-of-the-box on MySQL, so I'm a lit

[GENERAL] Any commercial shopping cart packages using postgresql?

2003-12-10 Thread Mike Nolan
I may need to move a web store to another hosting facility or rewrite it. I will need to be able to tie it to the in-house order entry system (which is/will be in Postgresql) for inventory status information. Are there any commercial web store/shopping cart packages or host sites that run under