Hi All I have a requirement, where I need to have a form and expected fields are - Name Contact number Email ID Resume (File upload) I hope we can create this form either by using CCK or by Webform. Once user enters the data, I want to save these data to a table in database. Later point of time I will retreive the data from database for showing in same form. Now my questions are - 1. How do I save the data (from above fields such as name, contact number, email id, resume file) to database. 2. How do I retreive the data from database at a later point of time. Given the number of database related operations needs to be performed, I am looking forward the execution speed should be faster. From this point perspective, which module you will suggest the CCK for Webform. Best Regards, Austin
On 3/3/11 9:56 PM, Austin Einter wrote:
Hi All I have a requirement, where I need to have a form and expected fields are - Name Contact number Email ID Resume (File upload) I hope we can create this form either by using CCK or by Webform. Once user enters the data, I want to save these data to a table in database. Later point of time I will retreive the data from database for showing in same form. Now my questions are - 1. How do I save the data (from above fields such as name, contact number, email id, resume file) to database. 2. How do I retreive the data from database at a later point of time. Given the number of database related operations needs to be performed, I am looking forward the execution speed should be faster. From this point perspective, which module you will suggest the CCK for Webform.
Why not just add fields to the user's account profile? This way the info can be retrieved and updated by them (or viewed/edited by site admin or other users depending on permissions) If you upgrade to Drupal 7 you can add fields to the user profile (see "Administer User Profile" http://drupal.org/node/874026 ). This is part of the core install and requires no further modules. For Drupal 6 there is the Profile module (see http://drupal.org/node/23710 ) have fun, kazar
Thanks Kazar Just one quick question. All users, user profile data etc are stored in a single table in Database or per user one table is created. Is there any limit for maximum number of users. Regards, Austin On Sat, Mar 5, 2011 at 7:24 PM, adept techlists - kazar <techlists@ade.pt>wrote:
On 3/3/11 9:56 PM, Austin Einter wrote:
Hi All I have a requirement, where I need to have a form and expected fields are - Name Contact number Email ID Resume (File upload) I hope we can create this form either by using CCK or by Webform. Once user enters the data, I want to save these data to a table in database. Later point of time I will retreive the data from database for showing in same form. Now my questions are - 1. How do I save the data (from above fields such as name, contact number, email id, resume file) to database. 2. How do I retreive the data from database at a later point of time. Given the number of database related operations needs to be performed, I am looking forward the execution speed should be faster. From this point perspective, which module you will suggest the CCK for Webform.
Why not just add fields to the user's account profile? This way the info can be retrieved and updated by them (or viewed/edited by site admin or other users depending on permissions)
If you upgrade to Drupal 7 you can add fields to the user profile (see "Administer User Profile" http://drupal.org/node/874026 ). This is part of the core install and requires no further modules.
For Drupal 6 there is the Profile module (see http://drupal.org/node/23710)
have fun, kazar -- [ Drupal support list | http://lists.drupal.org/ ]
On 3/6/11 4:37 PM, Austin Einter wrote:
Thanks Kazar Just one quick question. All users, user profile data etc are stored in a single table in Database or per user one table is created. Is there any limit for maximum number of users.
There is a single "users" table As far as I know there is no limit (but I am far from expert at Drupal), other than hardware and memory settings that will need to be sufficient if you have many users logged in at once. kazar
On Sat, Mar 5, 2011 at 7:24 PM, adept techlists - kazar <techlists@ade.pt <mailto:techlists@ade.pt>> wrote:
On 3/3/11 9:56 PM, Austin Einter wrote: > Hi All > I have a requirement, where I need to have a form and expected fields > are - > Name > Contact number > Email ID > Resume (File upload)
Why not just add fields to the user's account profile? This way the info can be retrieved and updated by them (or viewed/edited by site admin or other users depending on permissions)
If you upgrade to Drupal 7 you can add fields to the user profile (see "Administer User Profile" http://drupal.org/node/874026 ). This is part of the core install and requires no further modules.
For Drupal 6 there is the Profile module (see http://drupal.org/node/23710 )
Thanks Kazar This option may not be suitable as the number of records are going to be quite high. Probably user name should be hashed and on that basis table name should be selected to store, seach data for better performance. I really appreciate your information, this is really usefull for small to medium scale operations. Regards Austin On Mon, Mar 7, 2011 at 4:15 AM, adept techlists - kazar <techlists@ade.pt>wrote:
On 3/6/11 4:37 PM, Austin Einter wrote:
Thanks Kazar Just one quick question. All users, user profile data etc are stored in a single table in Database or per user one table is created. Is there any limit for maximum number of users.
There is a single "users" table
As far as I know there is no limit (but I am far from expert at Drupal), other than hardware and memory settings that will need to be sufficient if you have many users logged in at once.
kazar
On Sat, Mar 5, 2011 at 7:24 PM, adept techlists - kazar <techlists@ade.pt <mailto:techlists@ade.pt>> wrote:
On 3/3/11 9:56 PM, Austin Einter wrote: > Hi All > I have a requirement, where I need to have a form and expected fields > are - > Name > Contact number > Email ID > Resume (File upload)
Why not just add fields to the user's account profile? This way the info can be retrieved and updated by them (or viewed/edited by site admin or other users depending on permissions)
If you upgrade to Drupal 7 you can add fields to the user profile
(see
"Administer User Profile" http://drupal.org/node/874026 ). This is part of the core install and requires no further modules.
For Drupal 6 there is the Profile module (see http://drupal.org/node/23710 )
-- [ Drupal support list | http://lists.drupal.org/ ]
Kamal, When I first saw your question, it appeared to me to be in the very initial idea stage with out a lot of deep thought about the requirements. In it's crudest form it could easily be implemented with CCK to store resume's and Taxonomy for people to identify (by simply clicking) the multiple skill sets that they possess (after you build a list of them), linking the taxonomies to the resumes stored as nodes could be accessed very quickly, BUT,,,,, The problem is likely more complex than that. Take skill sets for example, you probably want to store more than whether they possess a skill set, perhaps something indicating the degree of competence they have in each skill set, then perhaps assigning these factors to their position in the search result. Next think about the resumes, often built on a series of work experiences, storing them as a single node document might ease your storage/retrieval problems, but not your search or analysis, where you may want to get clues about competence from the time spent on each project, etc, which could get hairy quickly. You might also want to look at what other people who are doing this are doing, check out http://www.dice.com <http://www.dice.com/> or http://www.indeed.com <http://www.indeed.com/> . You are not entering an entirely new area. Warren Vail Vail Systems Technology
I would advise against that. Drupal.org is hosting probably over 500,000 users already and there hasn't been a noticeable performance problem with logging in. Modern databases such as Postgres work fine with large row counts. They support feature like partitioning to make sure that the data is stored in separate places on disk based the value of key fields. Don't make the mistake of thinking that in PHP you can out optimize a database written for such activities. An index of 7 million integer uids is still a pretty small file by todays standards. Solve performance problems when and where they happen, and throw hardware and or database server feature sets at the problem rather than trying to out-program the DB programmers. The account profile is serialized data so I wouldn't store it there, particularly if you want to be querying it, but you can write a custom module to store info that is not natively in the user table there. ________________________________ From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Kamal Palei Sent: Sunday, March 06, 2011 3:07 PM To: support@drupal.org Cc: adept techlists - kazar Subject: Re: [support] Saving and Retreiving Form Data Thanks Kazar This option may not be suitable as the number of records are going to be quite high. Probably user name should be hashed and on that basis table name should be selected to store, seach data for better performance. I really appreciate your information, this is really usefull for small to medium scale operations. Regards Austin On Mon, Mar 7, 2011 at 4:15 AM, adept techlists - kazar <techlists@ade.pt> wrote: On 3/6/11 4:37 PM, Austin Einter wrote:
Thanks Kazar Just one quick question. All users, user profile data etc are stored in a single table in Database or per user one table is created. Is there any limit for maximum number of users.
There is a single "users" table As far as I know there is no limit (but I am far from expert at Drupal), other than hardware and memory settings that will need to be sufficient if you have many users logged in at once. kazar
On Sat, Mar 5, 2011 at 7:24 PM, adept techlists - kazar
<techlists@ade.pt <mailto:techlists@ade.pt>> wrote:
On 3/3/11 9:56 PM, Austin Einter wrote: > Hi All > I have a requirement, where I need to have a form and expected fields > are - > Name > Contact number > Email ID > Resume (File upload)
Why not just add fields to the user's account profile? This way the info can be retrieved and updated by them (or viewed/edited by site admin or other users depending on permissions)
If you upgrade to Drupal 7 you can add fields to the user profile
(see
"Administer User Profile" http://drupal.org/node/874026 ). This is part of the core install and requires no further modules.
For Drupal 6 there is the Profile module (see http://drupal.org/node/23710 )
-- [ Drupal support list | http://lists.drupal.org/ ]
Metzler Thanks for advice. Out of all databases as of now Drupal is compatible with, which one is suitable for high row counts and better performance during search, is it postgres? Currently I am using MySQl (5.5.8), will it scale up to high row counts. Best Regards Austin On Mon, Mar 7, 2011 at 9:42 PM, Metzler, David <metzlerd@evergreen.edu>wrote:
I would advise against that.
Drupal.org is hosting probably over 500,000 users already and there hasn’t been a noticeable performance problem with logging in. Modern databases such as Postgres work fine with large row counts. They support feature like partitioning to make sure that the data is stored in separate places on disk based the value of key fields. Don’t make the mistake of thinking that in PHP you can out optimize a database written for such activities. An index of 7 million integer uids is still a pretty small file by todays standards. Solve performance problems when and where they happen, and throw hardware and or database server feature sets at the problem rather than trying to out-program the DB programmers.
The account profile is serialized data so I wouldn’t store it there, particularly if you want to be querying it, but you can write a custom module to store info that is not natively in the user table there.
------------------------------
*From:* support-bounces@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *Kamal Palei *Sent:* Sunday, March 06, 2011 3:07 PM *To:* support@drupal.org *Cc:* adept techlists - kazar *Subject:* Re: [support] Saving and Retreiving Form Data
Thanks Kazar
This option may not be suitable as the number of records are going to be quite high.
Probably user name should be hashed and on that basis table name should be selected to store, seach data for better performance.
I really appreciate your information, this is really usefull for small to medium scale operations.
Regards
Austin
On Mon, Mar 7, 2011 at 4:15 AM, adept techlists - kazar <techlists@ade.pt> wrote:
On 3/6/11 4:37 PM, Austin Einter wrote:
Thanks Kazar Just one quick question. All users, user profile data etc are stored in a single table in Database or per user one table is created. Is there any limit for maximum number of users.
There is a single "users" table
As far as I know there is no limit (but I am far from expert at Drupal), other than hardware and memory settings that will need to be sufficient if you have many users logged in at once.
kazar
On Sat, Mar 5, 2011 at 7:24 PM, adept techlists - kazar
<techlists@ade.pt <mailto:techlists@ade.pt>> wrote:
On 3/3/11 9:56 PM, Austin Einter wrote: > Hi All > I have a requirement, where I need to have a form and expected fields > are - > Name > Contact number > Email ID > Resume (File upload)
Why not just add fields to the user's account profile? This way the info can be retrieved and updated by them (or viewed/edited by site admin or other users depending on permissions)
If you upgrade to Drupal 7 you can add fields to the user profile
(see
"Administer User Profile" http://drupal.org/node/874026 ). This is part of the core install and requires no further modules.
For Drupal 6 there is the Profile module (see http://drupal.org/node/23710 )
--
[ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Either are possible. I've used both, mostly postgres for its rich feature set, but mysql for web applications that don't care about a rich database feature set. If you don't plan to be a database administrator MySQL is probably a better choice, but then, if your going to be loading million plus row tables, you might want a DBA or learn how to be one. MySQL out of the can typically outperforms postgres, but Postgres has more performance tuning features, and so if you were interested in controlling things like physical storage based on application keys, Postgres is a better bet. In drupal 6, you'll get stronger drupal support in MySQL. I think the jury is still out on postgres. My point really was to not advise you on which to use, but to warn you against designing storage optimization in PHP applications. That is something that's best done in the DB layer Dave ________________________________ From: Austin Einter [mailto:austin.einter@gmail.com] Sent: Monday, March 07, 2011 3:32 PM To: support@drupal.org Cc: Metzler, David Subject: Re: [support] Saving and Retreiving Form Data Metzler Thanks for advice. Out of all databases as of now Drupal is compatible with, which one is suitable for high row counts and better performance during search, is it postgres? Currently I am using MySQl (5.5.8), will it scale up to high row counts. Best Regards Austin On Mon, Mar 7, 2011 at 9:42 PM, Metzler, David <metzlerd@evergreen.edu> wrote: I would advise against that. Drupal.org is hosting probably over 500,000 users already and there hasn't been a noticeable performance problem with logging in. Modern databases such as Postgres work fine with large row counts. They support feature like partitioning to make sure that the data is stored in separate places on disk based the value of key fields. Don't make the mistake of thinking that in PHP you can out optimize a database written for such activities. An index of 7 million integer uids is still a pretty small file by todays standards. Solve performance problems when and where they happen, and throw hardware and or database server feature sets at the problem rather than trying to out-program the DB programmers. The account profile is serialized data so I wouldn't store it there, particularly if you want to be querying it, but you can write a custom module to store info that is not natively in the user table there. ________________________________ From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Kamal Palei Sent: Sunday, March 06, 2011 3:07 PM To: support@drupal.org Cc: adept techlists - kazar Subject: Re: [support] Saving and Retreiving Form Data Thanks Kazar This option may not be suitable as the number of records are going to be quite high. Probably user name should be hashed and on that basis table name should be selected to store, seach data for better performance. I really appreciate your information, this is really usefull for small to medium scale operations. Regards Austin On Mon, Mar 7, 2011 at 4:15 AM, adept techlists - kazar <techlists@ade.pt> wrote: On 3/6/11 4:37 PM, Austin Einter wrote:
Thanks Kazar Just one quick question. All users, user profile data etc are stored in a single table in Database or per user one table is created. Is there any limit for maximum number of users.
There is a single "users" table As far as I know there is no limit (but I am far from expert at Drupal), other than hardware and memory settings that will need to be sufficient if you have many users logged in at once. kazar
On Sat, Mar 5, 2011 at 7:24 PM, adept techlists - kazar
<techlists@ade.pt <mailto:techlists@ade.pt>> wrote:
On 3/3/11 9:56 PM, Austin Einter wrote: > Hi All > I have a requirement, where I need to have a form and expected fields > are - > Name > Contact number > Email ID > Resume (File upload)
Why not just add fields to the user's account profile? This way the info can be retrieved and updated by them (or viewed/edited by site admin or other users depending on permissions)
If you upgrade to Drupal 7 you can add fields to the user profile
(see
"Administer User Profile" http://drupal.org/node/874026 ). This is part of the core install and requires no further modules.
For Drupal 6 there is the Profile module (see http://drupal.org/node/23710 )
-- [ Drupal support list | http://lists.drupal.org/ ] -- [ Drupal support list | http://lists.drupal.org/ ]
I've got a Drupal 7 site set up with an editor role with permission to do anything with nodes short of administering them. And a content type with an image field. The admin can freely add and remove and re-add an image. The editor though is only being allowed to create the node and add an image. Editor isn't being allowed to remove the image, even one they've created. Nothing shows up on the error log or the screen, the ajax widget runs briefly when remove is clicked, and so I don't know where to look next. Marty -- http://www.face2interface.com/ https://addons.mozilla.org/af/firefox/addon/181910/
participants (6)
-
adept techlists - kazar -
Austin Einter -
Kamal Palei -
Marty Landman -
Metzler, David -
Warren Vail