Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    19

    Unanswered: Column Type for Shell Script

    Hello,
    I have a need to store a shell script or two in each database records. What is the best way to store the shell script data in the database? I guess I wanted to know if it makes more sense to just store the text of the script or store it as a file in a blob? Oh yea, the data will only be accessed via web services.

    Thanks!

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Quote Originally Posted by sunfire
    What is the best way to store the shell script data in the database?
    I can't see any advantage to using a blob so I'd say use a character field. Whether you use a large varchar or a text field depends on the size of your scripts. Saying that it may be better to just keep your shell programs in the file system and then just store the name of the script and the params it takes in your database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •