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 9 2882
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
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)
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 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)
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
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
> 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
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
> 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Paul Bruneau |
last post by:
Hi,
I hope someone can help me make a working shopping cart, as a learning tool.
If I have a "Product Demo" html page with a "Buy Me" button, there must be
a simple javascript method of...
|
by: madison |
last post by:
Hi,
I am trying to start a website using paypals shopping cart function.
If i have 10 items and they sell out, how do I make it so the item is
then listed as sold out. The next person would not...
|
by: Penny |
last post by:
Hi all,
I've built an online shopping cart using ASP Classic(based on a 'WebThang'
tutorial). The shop cart page (with table showing customers selected items
and costs) has only 3 buttons/links....
|
by: Adil Akram |
last post by:
I have created a site shopping cart in ASP.net.
I am using ASP session object's SessionID on non SSL connection to track
session.
While adding products to cart DB I insert product and SessionID...
|
by: Guadala Harry |
last post by:
I'm looking to implement some *minimal* shopping cart. I've looked at a few
3rd party packages, and they're all way too involved for what I need. So,
I'm thinking it might make sense to roll my...
| |
by: G.E.M.P |
last post by:
High Level Session Handling Design for a Shopping cart
0) What am I missing?
1) How does OSCommerce do it?
I'm thinking about building a shopping cart from scratch,
using a library of dynamic...
|
by: isaac2004 |
last post by:
hi i have a basic asp page that acts as an online bookstore. on my cart
page i am having trouble generating 3 numbers; a subtotal, a shipping
total, and a final price. here is my code
i would...
|
by: lawrence k |
last post by:
I know this question has been asked before, but every few months there
are different levels of activity on the various open source projects,
so I figured I'd ask again to hear what the current...
|
by: jecha |
last post by:
I'm implementing a shopping cart but am having a problem in checking out a person who has added item in his/her shopping busket.The code for the checkout.php script is given below
<?...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |