From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
---|---|
To: | "Alex Satrapa" <alex(at)lintelsys(dot)com(dot)au>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Any commercial shopping cart packages using postgresql? |
Date: | 2003-12-17 03:37:33 |
Message-ID: | D90A5A6C612A39408103E6ECDD77B829408CB0@voyager.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----Original Message-----
> From: Alex Satrapa [mailto:alex(at)lintelsys(dot)com(dot)au]
> Sent: Tuesday, December 16, 2003 7:24 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Any commercial shopping cart packages
> using postgresql?
>
>
> 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 varchar(20) DEFAULT '' NOT NULL,
> objclass varchar(20) DEFAULT '' NOT NULL,
> objtype varchar(20) DEFAULT '' NOT NULL,
> ...
> PRIMARY KEY objid
> );
>
> No foreign keys! Look at all those "DEFAULT '' NOT NULL"
> columns! What
> are they thinking?
The no foreign keys thing means RI is out the window, of course. A sea
of tables, floating in a soupy database fog of danger.
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:
SELECT COUNT(*) FROM addresses WHERE <column> = 'some_constant'
Added with
SELECT COUNT(*) FROM addresses WHERE NOT <column> =
'some_constant'
Is not equal to
SELECT COUNT(*) FROM addresses
I tend to agree that every column should have a default and not be
allowed to become NULL. Just to keep end-user astonishment at a
minimum.
> As penance for suggesting this product, I will clean up the
> SQL and at
> least post my experiences with installing and using this product on
> PostgreSQL.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Satrapa | 2003-12-17 04:10:23 | Re: Any commercial shopping cart packages using postgresql? |
Previous Message | Alex Satrapa | 2003-12-17 03:23:41 | Re: Any commercial shopping cart packages using postgresql? |