Re: Relational DB's & pics - a long business-related question

On Jul 14, 2006, at 1:35 AM, Eric Matthew Finnin wrote:

> So I'm wondering, what are the pieces that need to be put together to
> get it this to work? I assume this would involve developing an
> (internal) website that accesses a database of information and
> pictures. Would Postgresql be an ideal program for this? MS Access
> is ideal for data entry by people who are familiar with spreadsheets,
> but have no knowledge of SQL. Is there an extension or software
> related to Postgres that is ideal for data entry for people used to
> visual/mouse-based computing? Any suggestions are welcome.

I would suggest looking into existing web-based e-commerce solutions.
Plenty are open source and I'm sure have a "inventory management"
view for specifying product attributes and and pictures. For example,
Drupal has an e-commerce module:

http://drupal.org/project/ecommerce

Also opentaps (http://www.opentaps.org/) has a product management
module which I pretty sure supports pictures. Check out the online demo.

Both solutions are open source and support PostgreSQL.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL