EvanK has asked for the wisdom of the Perl Monks concerning the following question:

the company i work for is using a very slow, very antiquated content management system, and we'd like to switch over to something faster and more stable. the reason our current system is so slow is that:

now, the system uses several flatfile databases:

catalog
- contains a record for every unique product (ex: upc, name, price)

transactions
- contains a record for every transaction (ex: product, transaction id, quantity)

customers
- contains a record for every company that purchases from us (ex: company id, name, address)

news
- contains a record for every 'news' story on our external site, publicly available (ex: story date, title, byline, content)

photos
- contains a record for every photograph in our online photo galleries, also publicly available (ex: photo id, category, filename)

on our internal sites, we use all but the last two. we allow customers to view our product catalog so they can place orders. we fluctuate our inventory by adding or subtracting quantities in transactions.

on our external public site, we have company and industry news, we have several company photo galleries. we also allow anyone to search our product catalog for general product info, seeing as how our product is publicly available through distributors.

now, both the internal and external sites are dynamic content. the individual pages are generated on-the-fly from templates.

i figured we could do something pretty much the same with mysql, but it would all be indexed and cross-referenced in several tables, all within one database. and we could do all our templating and dynamic content via perl or php or any other server-side scripting languages. i don't, however, want to spend months developing a cms from scratch, especially if we can find a suitable one that already exists and is maintained.

since i know perl better than any other language, i'd like to find one that is either written in, or utilizes perl. (mabye written in c, for speed?) does anyone know of a cms suitable for what we need?

__________
Build a man a fire, and he'll be warm for a day. Set a man on fire, and he'll be warm for the rest of his life.
- Terry Pratchett

  • Comment on Looking for a suitable content management system...suggestions?

Replies are listed 'Best First'.
Re: Looking for a suitable content management system...suggestions?
by BMaximus (Chaplain) on Jan 26, 2006 at 23:06 UTC
    Maybe Bricolage is what you're looking for.

    BMaximus
Re: Looking for a suitable content management system...suggestions?
by planetscape (Chancellor) on Jan 27, 2006 at 14:06 UTC
Re: Looking for a suitable content management system...suggestions?
by bart (Canon) on Jan 27, 2006 at 12:50 UTC
    All I can offer you is an external link. Somebody went to a lot of trouble examining every systsem he could find, and you can see the resulting overview in this comprehensive CMS directory.
Re: Looking for a suitable content management system...suggestions?
by perrin (Chancellor) on Jan 27, 2006 at 17:11 UTC
    It doesn't sound like you want a CMS. It sounds like you want something that specifically publishes a product catalog, more like an e-commerce app. Most CMSes are designed more around articles, with a looser data model.

    If you do want to try to get a CMS to handle your content, it will need to be one that you can customize the data model of. I currently use and contribute to Krang, and I believe it is the most customizable system I've seen in Perl, but it still may not be enough to adapt to your data model.

Re: Looking for a suitable content management system...suggestions?
by bibliophile (Prior) on Jan 27, 2006 at 15:06 UTC
Re: Looking for a suitable content management system...suggestions?
by lima1 (Curate) on Jan 26, 2006 at 21:59 UTC
    Plone/Zope:

    + written in python. very nice interface for users, good API (the incredible Archtypes), powerful workflow features, huge community, layers, internationalization, looks good out of the box

    - not very fast (but ok with a not too outdated server), Zope managment interface is very cluttered

    Typo 3 (php/mysql): + good admin interface (evaluated this only a few days)

    - own scripting language

    Drupal: + easy to install, nice templates - lakes many "enterprise" features

    I used Plone for a bigger project, drupal for small sites

      EvanK (perlmonk) asked
      since i know perl better than any other language, i'd like to find one that is either written in, or utilizes perl

        While this may be a troll, I cannot let this one rest.

        While the above response was not a Perl solution, the original poster did not ask for only a Perl solution. Many of the Perl people I have seen want the "best" solution for a job - not necessarily a Perl solution, but one that gets the job done. Since many users here utilize a CMS in their daily Perl jobs, why cannot the OP ask those that use them?

        A myopic view of a solution space is a way to miss many good and reasonible alternatives.

        Update: Teach me to just scan a post before replying :)

        --MidLifeXis

Re: Looking for a suitable content management system...suggestions?
by Kevad (Scribe) on Jan 30, 2006 at 19:06 UTC
    A good site to keep in mind, in case you want to try out the backend/frontend sections of many different CMS's without installing: http://www.opensourcecms.com
      This site only covers PHP/mysql based CMSs, however.