|
|
|
|
|
|
by ceejayoz
938 days ago
|
|
|
Back in the Drupal... 6, I think? days it was a really, really nice way to do a rapid prototype of a CRUD app. CCK, Views, etc. would let even a minimally technical person whip together what they wanted for something like an in-house ticketing system or knowledgebase or whatnot. We put some neat stuff together for the newspaper I worked at using it. All that flexibility resulted in pages with 1k+ queries on them, and nasty upgrade paths. I hear D8 is Symfony-based now, and a lot got cleaned up, but after one project upgrading a Drupal app from one major version to another I won't touch it again. After a month's worth of work we refunded the client and canceled the job. |
|
|
Wrote something called the "page module" that let them build out the various landing pages using extremely flexible criteria ... everything from tags to specofic articles to category - and probably more that I'm forgetting. I built specically because views just wasn't good enough. It was able to do a couple of very important things... It had what was essentially a materialized view that was maintained by the import scripts (All actual content editing was done in the propritary publishing software they used, then sent as XML to the web importer which ran constantly looking for new xml files in a directory).
The big upshot of this was that is that getting, saying, the articles for a given "page" (Which wasn't necessarily actually a page - there were also presentations like sidebar lists) was a SINGLE query with no joins. Very performant. We did millions of page views daily on one web server and one db server... both low end commodity boxes.
It was kinda fun, but when I left I made a promise to myself to never, ever, work with Drupal or PHP every again professionally, and I've been quite happy to stick to that.