Tech SQL Database Question - BLOB - GoFuckYourself.com

Publisher Bucks · 12-13-2021, 01:09 PM

Is there any reason that I shouldnt just set all fields in a table as 'BLOB' in terms of server usage, security, etc?

Colmike9 · 12-13-2021, 01:21 PM

It could use up a lot of data and might mess up your backups depending on how you have them set up, tho.

Colmike9 · 12-13-2021, 01:28 PM

Quote:

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.

Publisher Bucks · 12-13-2021, 02:17 PM

Quote:

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

Klen · 12-13-2021, 02:45 PM

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.

k0nr4d · 12-14-2021, 06:22 AM

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

12-13-2021, 01:09 PM	#1
Publisher Bucks Confirmed User Industry Role: Join Date: Oct 2018 Location: New Orleans, Louisiana. / Newcastle, England. Posts: 1,131	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? __________________ SOMETHING EXTREME IS COMING SOON!

12-13-2021, 01:21 PM	#2
Colmike9 (>^_^)b Industry Role: Join Date: Dec 2011 Posts: 7,223	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..

12-14-2021, 06:22 AM	#6
k0nr4d Confirmed User Industry Role: Join Date: Aug 2006 Location: Poland Posts: 9,228	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

12-13-2021, 02:45 PM	#5
Klen Industry Role: Join Date: Aug 2006 Location: Little Vienna Posts: 32,235	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.