I'm using sqlalchemy to store objects in a database. The kind of object I'm creating is unknown until run time. I could be storing something as simple as a string. I could be storing a jpg. I might create my own file format and store that. The point is it's flexible.
The table I envision contains at least two columns. One describes the file type (.jpg, .txt, .py, etc), and the other is a blob with the file data. What I want to know is whether I need to define the blob size when I create the table. Is it possible to let mysql dynamically set the size of blob? This would simplify my design nicely.
I'm aware there are other ways to do it, but I have good reasons to do it this way. I don't mind going down this path and doubling back later if it turns into a dead end.