By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,834 Members | 2,265 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,834 IT Pros & Developers. It's quick & easy.

Any commercial shopping cart packages using postgresql?

P: n/a
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 PostgreSQL? I found one web store package in the pgsql
project archives, but it looks like it may need a lot of tinkering to get
it working.
--
Mike Nolan


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #1
Share this Question
Share on Google+
9 Replies


P: n/a
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 little wary of that (I'm still
recovering from reading taht MySQL Gotchas page). So this is just a
pointer to something that exists.

HTH
Alex
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #2

P: n/a
Mike,

You could take a look at:
http://www.oscommerce.com/
While it is not written for postgres but for mySql, it has all data base
access abstracted to a single include file, so it (potentially) could be
easy to adapt to postgres.
It is also not a finished project, but I think it's good enough already
for production usage.
Worths a look.

Just my 2c.

Csaba.
On Thu, 2003-12-11 at 03:39, Mike Nolan wrote:
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 PostgreSQL? I found one web store package in the pgsql
project archives, but it looks like it may need a lot of tinkering to get
it working.
--
Mike Nolan


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #3

P: n/a
I used to follow the AllCommerce system quite closely, but I think
you'll find that it hasn't been actively developed for about 2 years now
IIRC. If that's not a problem for you then it's a good system, although
a little more complicated than I needed.

Regards

Tony

Alex Satrapa wrote:
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 little wary of that (I'm
still recovering from reading taht MySQL Gotchas page). So this is
just a pointer to something that exists.

HTH
Alex
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #4

P: n/a
Are there any commercial web store/shopping cart packages or host sites
that run under PostgreSQL? I found one web store package in the pgsql
project archives, but it looks like it may need a lot of tinkering to get
it working.


http://www.fishcart.org
It runs with MySQL, PostgreSQL, Solid, Oracle and MSSQL.

With the latest version we ran into some minor issues with PostgreSQL but
those will be solved with the new release that is supposed to get out as
soon as all the latest features are fully tested.

B.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #5

P: n/a
My previous query applies here too then...

Is the cart built using full features of PG or is it a port using
database abstraction libs with the same functionality as MySQL?

Obviously the power of PG lies in all the goodies MySQL doesn't yet have.

Cheers

T.

B. van Ouwerkerk wrote:
Are there any commercial web store/shopping cart packages or host sites
that run under PostgreSQL? I found one web store package in the pgsql
project archives, but it looks like it may need a lot of tinkering to
get
it working.

http://www.fishcart.org
It runs with MySQL, PostgreSQL, Solid, Oracle and MSSQL.

With the latest version we ran into some minor issues with PostgreSQL
but those will be solved with the new release that is supposed to get
out as soon as all the latest features are fully tested.

B.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #6

P: n/a
I didn't see your previous question.. but.. no.. it's not coded
specifically for PG if you mean you can use views etc out of the box. In
the past several portions of code have been added to make it run properly
with PG, while installing the cart those are configured on the fly.

I wouldn't be surprised if the developers decide to modify the cart to have
the PG goodies. But there is much more to consider then just using views etc.

Until the PG goodies are used nothing is stopping you to create views from
the current queries, or use any other PG specific feature if you like.

The power of FishCart lies in the fact that it has many features.

B.

At 15:13 16-12-2003 +0000, Tony (Unihost) wrote:
My previous query applies here too then...

Is the cart built using full features of PG or is it a port using database
abstraction libs with the same functionality as MySQL?

Obviously the power of PG lies in all the goodies MySQL doesn't yet have.

Cheers

T.

B. van Ouwerkerk wrote:
Are there any commercial web store/shopping cart packages or host sites
that run under PostgreSQL? I found one web store package in the pgsql
project archives, but it looks like it may need a lot of tinkering to get
it working.

http://www.fishcart.org
It runs with MySQL, PostgreSQL, Solid, Oracle and MSSQL.

With the latest version we ran into some minor issues with PostgreSQL but
those will be solved with the new release that is supposed to get out as
soon as all the latest features are fully tested.

B.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #7

P: n/a
> My previous query applies here too then...

Is the cart built using full features of PG or is it a port using
database abstraction libs with the same functionality as MySQL?

Obviously the power of PG lies in all the goodies MySQL doesn't yet have.


Another question is how many of those goodies are needed to run a shopping
cart app? I'm interested in using PG in large measure because that's what
our membership system is being written in, so I assume that tying the
shopping cart app into the rest of the system will be easier with a
PG-based app than with one that uses MySQL or some other data platform.
--
Mike Nolan

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #8

P: n/a
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?

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

Nov 12 '05 #9

P: n/a
> 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
would think medical DB designers are wont to be paranoid about
quality/integrity of data ...

Karsten Hilbert, MD
www.gnumed.org
(we do try to do a better job and this list is invaluable for it)
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #10

This discussion thread is closed

Replies have been disabled for this discussion.