Hi Drupalians,

I was hoping if someone may help us customize Drupal for the project requirements demonstrating the following features -

  1. Scalable - Should not crash with 100,000 visitors and hundreds of logged-in users using the site on a daily basis.
  2. Multi-site setup - Host multiple web sites using the same installation.
  3. Multi-lingual setup - Editor interfaces and content should support different Indian regional languages like Tamil, Bengali, Hindi etc apart from English.
  4. Workflow - Content approval process should be customizable with different levels of approval.
  5. Databases - Admin should be able to easily create customized DBs.
  6. Reports - Admin should be able to easily create customized reports which should be achieved without any PHP or SQL coding. These could be in any like surveys, forms, questionnaires, articles having large amount of meta-data, etc.

If you could please let me know when we can discuss further on this project, I would really appreciate it. You can reach me at vijay@padipom.org

Thank you for your time and assistance.

Cheers VJ

Comments

brycefisherfleig’s picture

Hi VJ,

Welcome to the Drupal community! I'm not sure if you're seeking out a contractor or you just want to know if Drupal is up to snuff for your needs. Here's some specific responses to your post:

  1. Scalable - This is a great goal actually! Checkout Pantheon or Acquia for scalable Drupal solutions. It's easy to handle anonymous users by leveraging a CDN. You can also improve performance with Redis, Memcache, and Varnish. Scaling up for authenticated users requires multiple servers and database replication.
  2. Multi-site - I personally believe that multisite is a terrible idea that you should avoid at all costs. I've written a bit about why multisite is bad and Pantheon has written against multisite as well. For a contrasting point of view, Larry Garfield (a personal hero of mine) has a great write up that says good things about multisite in certain situations. The bottom line in software development of all kinds is not to do anything too complicated without a really really good reason. Why are you looking for multisite?
  3. Workflow - There are two modules that are really important for managing workflow in Drupal (both are big and require lots of heavy lifting in the database): Workflow (the established module) and WorkBench (a reaction against Workflow). Both modules will let you create very complicated workflows that can do anything you want.
  4. Databases - I'm very curious about what you are trying to accomplish. There's no need to create multiple databases. In many cases, Drupal can create any data structure you want quickly using content types (native to Drupal) or using the Webform module for questionaires that anonymous users would complete. Webform also creates tables that display all the data submitted.
  5. Reports - To the best of my knowledge, this is not something that Drupal does very well. You would likely need to seek a contractor.
  6. I hope I've given you some food for thought. Best of luck with your project!