- it uses unindexed flat file databases (ugh)
- it parses EVERY non-binary file before serving it via http (think server-side includes, but much much worse)
- its just old. the company that developed it went under in 1998, for godsake, so it hasnt been revised since then.
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
+ 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
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 - net 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 ad reasonible alternatives.
--MidLifeXis
You may also wish to have a look at the following:
Off-Line Content Management Scheme?
modules, auto generated code and content management
A CMS That Doesn't Suck
Perl based Content Management System
HTH,
http://www.cmsmatrix.org/matrix/cms-matrix
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 CPAN://krang.sf.net/. 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.