I would also recommend considering non-JCR Content App: https://www.youtube.com/watch?v=QK9lOIE3cHY&t=19m50s and http://documentation.magnolia-cms.com/display/DOCS/Content+app+with+non-JCR+content
Jozef ----- Original Message ----- From: "Nils Breunese" <[email protected]> To: "Magnolia User-List" <[email protected]> Sent: Friday, January 23, 2015 12:49:49 PM Subject: Re: [magnolia-user] Re: Magnolia: Retrieving data from a database Hasitha Abeynayake wrote: > The objective for us is to learn to retrieve data from a PostgreSQL database > since we are hoping to create a commercial website. For example retrieving > product inventories and displaying the details in the webpage (Similar to the > product app used in Shop module) > > We are a bit confused how to achieve this through an eclipse maven project > running on magnolia-cms. > > Should this be done through normal sql retrieval queries in model classes? or > can we do this through jsp template files? Both should work and I personally prefer model classes to separate logic from a template. Instead of choosing a template technology I'd start by deciding whether the product information is best managed by an external system or in a Magnolia workspace. If it is best managed outside of Magnolia, I would personally recommend building an API for the product system instead of tying Magnolia directly to the external system's database, but that's all up to you. I haven't checked the videos, but there's some information on e-commerce integration here: http://www.magnolia-cms.com/product/features/integration/ecommerce.html Nils. ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ---------------------------------------------------------------- ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
