SQL Database Question - BLOB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Publisher Bucks
    Confirmed User
    • Oct 2018
    • 1330

    #1

    Tech SQL Database Question - BLOB

    Is there any reason that I shouldnt just set all fields in a table as 'BLOB' in terms of server usage, security, etc?
    Extreme Link List - v1.0
  • Colmike9
    (>^_^)b
    • Dec 2011
    • 7230

    #2
    It could use up a lot of data and might mess up your backups depending on how you have them set up, tho.
    Join the BEST cam affiliate program on the internet!
    I've referred over $1.7mil in spending this past year, you should join in.
    I make a lot more money in the medical field in a lab now, fuck you guys. Don't ask me to come back, but do join Chaturbate in my sig, it still makes bank without me touching shit for years..

    Comment

    • Colmike9
      (>^_^)b
      • Dec 2011
      • 7230

      #3
      Originally posted by Colmike9
      It could use up a lot of data and might mess up your backups depending on how you have them set up, tho.
      ...I might be thinking about people who have done this before, but were storing files in the DB when they shouldn't be in there lol.
      Join the BEST cam affiliate program on the internet!
      I've referred over $1.7mil in spending this past year, you should join in.
      I make a lot more money in the medical field in a lab now, fuck you guys. Don't ask me to come back, but do join Chaturbate in my sig, it still makes bank without me touching shit for years..

      Comment

      • Publisher Bucks
        Confirmed User
        • Oct 2018
        • 1330

        #4
        Originally posted by Colmike9
        It could use up a lot of data and might mess up your backups depending on how you have them set up, tho.
        This is just for text based content, from what I've been reading, theres a camp that says it doesnt really matter, and another that says it may do what you said, but nobody has actually been able to provide evidence that it effects backups that have that train of thought, other than with images.

        I'm just honestly annoyed that I keep having to change these settings anytime I throw a new table together and cant just copy and paste in the info to create them lol
        Extreme Link List - v1.0

        Comment

        • Klen
          • Aug 2006
          • 32235

          #5
          Yes i think i read somewhere how it's bad to use it so i never used it so cant really tell . But i am used anyway to limitation of characters and type of input so no need for it anyway. That is handy to prevent "surprise" injections.

          Comment

          • k0nr4d
            Confirmed User
            • Aug 2006
            • 9231

            #6
            It's useful if you want to store like any type of character set in a field, or if you want to store a file in the database. It's useful sometimes.

            It does sometimes cause issues with backups/mysqldump etc, though
            Mechanical Bunny Media
            Mechbunny Tube Script | Mechbunny Webcam Aggregator Script | Custom Web Development

            Comment

            Working...