Here I have a table with fields in it [id, create_date, images, ...].

The idea is, I, that would not create another table, I will simply store pictures in the field of the images table, in the form of JSON {"1": "www.site.ru/img1.jpg", ...} .

The question is is this normal? Or nevertheless to make the separate table? Does it affect the speed and safety? Thank.

MySql + PhP

  • one
    And how will you delete the picture? And update? - u_mulder
  • You can go to postgress. there are similar things - normal. Moreover, they even have api for access to individual fields of the json-field. - KoVadim
  • Easily, when editing images, we load this JSON object from the server, and by editing the images in the panel, we will change this object, and when to save, we simply poison it in the database. - Man
  • So tell me - why are you inventing extra operations for yourself? Overtake from json, save to json. For what? - u_mulder
  • one
    мы загружаем с сервера этот JSON объект, и редактируя картинки в панели, мы будем изменять этот объект, а когда сохранять, то просто его отравляем в БД. - let's say you have a million pictures, or 10 million. How do you think how much will you load and parse this json?) And then also collect it back - Alexey Shimansky

2 answers 2

Well, if in Feng Shui, then of course you can't do that.

but, as a rule, even when absolutely impossible - sometimes you can still ... any rules can (and should) be broken sometimes, but this should be done consciously ... a conscious departure sent from the unconscious has a clear understanding of the positive and negative consequences.

I propose a small self-test, a set of questions that you should ask yourself before you implement the solution "through w ...":

  • I could (can I) do it in a normal way? I can do it, and I can do it with about the same effort as a non-normal one?
  • Does breaking the rules give me any benefit?
  • Seriously? except for laziness and the desire to be "not like everyone else" - are there any serious objective reasons to make a not-in-mind?
  • Does deviation from the rules create any problems / minuses?
  • I am sure that I am aware of ALL the possible negative consequences of deviation from the rules?
  • really sure?
  • and these advantages outweigh the minuses by at least an order of magnitude?

if all the questions were answered "yes" - then maybe it makes sense to deviate from the rules ... or maybe, all the same, and no ...

but if at least one question was answered at least "probably" - then see the very first sentence in my answer :)

Well, in your case, the key question is how many pictures (average table) will be on one site? And how many updates are expected (added / deleted / changed picture) per 100 readings?

If you have 100,500 sites there, but only 2 of them have 2 pictures each, and they will be half a time for 100,500 readings - yes, the flag is in your hands, at least JSON, even if you invent a binary format, except for the hatred of those who support it , other troubles you, most likely, will not have ...

Well, if the number of pictures is approximately equal to or more than the number of sites, one site is expected to dofig pictures, they will be updated regularly ... then do not invent problems for yourself and get a table.

    This not normal. In the literal and figurative sense ( normalization ). After a time, when there are a sufficient number of pictures, you will tear your hair out: "how to support it?"

    Your task is to make your task easier. These conversions are a potential place for bugs. With structured data initially it will be easier, and if you use ORM, then in general the question should disappear.