How to organize relational storage of images?

Question

MySQL

Hello. How to implement the full relationality of storing pictures, so that they can be removed from the database. record and immediately deleted the associated pictures?

Answer 1

here in short such a thing ... there is such garbage .... OOP is called ... but what is OOP, there is cooler garbage, the FUNCTION is called. there is an opinion that if you create a function f that will take argument A where this argument will be the path to the picture and inside the function you will sequentially delete the picture from the database and on the disk, then everything will be top type, you can finally download

Answer 2

For example, store them in the database in the form of a blob

Answer 3

Of course, storing pictures in the database is not good. It is better to store the id of the picture, a link to the picture. When deleting an entry, also delete the associated file