I am very new into the database and thinking to desin a database which can have image, video and long description and all. Can any body suggest me how to start and what backend technology shall i used to fetch the data. Is restApi is worth.

My skil is javascript and Java. Which database shall i use for this requirment and how to achive this in frontend. There multiple logic to fetch which I want to handle in backend.

Thanks for suggestions.

  • Advice: do not attempt to store video in a relational database, not even as a blob; store the path to the video file Aug 6 '19 at 11:44

Firstly, I have a feeleing, that your language preference should not influence the choice of db much. However, you haven't specified other criteria, so I will follow the points about the java-prefernece and the multimedia-idea.

You did not mention the purpose od your app, but you mention you would store multimedia. I have therefore a feeling that your question can be split in two fields: the architecture for storing multimedia is one part, db backend is the other part.

  1. The db choice according to the info you provided would be best related to your experience and your java preference.
  2. The multimedia store could be separate from the db (images and videos, and all other binary data) in files named by some tag, and metadata including descriptions in the database.

Separating multimedia from the database makes sense; why using the db as a filesystem? When there is much data to store (that is not bound to much other objects or structure), fielsystem is better suited. The db puts "more wight" on data relations, so keeping just metadata would be more efficient, whereas the storage-function can be outsourced to the filesystem.

Really not enough info to deliberate on the type od database. I also am not sure of how to fit restFul Api in it at this point. What I suggested is definitely ment for a learner, experimenting geek, but probably is not a full answer for building up a youtube replacement.

  • 1
    Thank you Patryk for the aswer. In this case shall I use sql database, and then question arise how to store multimedia in database. Well restAPi i was saying I want to fetch the data and display on UI.
    – David
    Aug 6 '19 at 10:10
  • 1
    Advice: do not attempt to store video in a relational database, not even as a blob; store the path to the video file Aug 6 '19 at 11:45
  • So I use sql database and for multimedia I should store in folder and call that path in db.
    – David
    Aug 7 '19 at 4:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.