0

If I have data that I will only need to update very rarely (once a month), would it be a good idea to use a JSON file instead of a database table with only 1 row?

2
  • With a database approach you can relate that line with the others in the database. With the file you'll need to read it and initialize a CLOB to process it. Question is: the rest of the database needs to process or relate (join) in any point with that specific line?
    – linuxunil
    Dec 14, 2016 at 17:35
  • @linuxunil good question. No, this table will never relate to any other tables, nor will it contain data to be analyzed.
    – Goose
    Dec 14, 2016 at 17:43

1 Answer 1

2

With a database approach you can relate that line with the others in the database. With the file you'll need to read it and initialize a CLOB to process it.

In other words, the data will exist for the database.

Other thing to consider is that with a database comes more things that just storage of data. You get logging, transactions, permissions...

Analyze other aspects of your application to be sure that you really don't need those.

1
  • Also, if you're already using a database, then using it for the OPs record means one fewer additional component/library/etc to deal with. Dec 15, 2016 at 3:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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