3

I'm designing an application based on RethinkDB, which involves storing images.

Each entity that I wish to store involves a number of fields of text, numeric data and an image of several hundred kilobytes.

Would it be best to store the images in files with a cross reference in the JSON records? Or can they be stored in the JSON record itself? Should I consider another database scheme altogether?

Warren Sergent
  • 2,542
  • 4
  • 36
  • 42
Lloyd R. Prentice
  • 4,329
  • 3
  • 21
  • 31

1 Answers1

2

It depends mostly of your load. The main things to consider is: - Storing everything in the same document make things faster to retrieve (no need to perform a join) - Storing everything in the same document means that for each update, the whole document has to be rewritten (this is because RethinkDB is schema-less).

So if you will often update your fields but not your file, you should probably store the images in different documents. If you are going to store once your document, and then just do reads, you are probably better saving everything in the same document.

Saving everything in the same document make also things easier from a developer point of view.

neumino
  • 4,342
  • 1
  • 18
  • 17