Why not just a plain json file instead of a database?

  • 22
    Why not search in books instead of Google?
  • 20
    To avoid re-implementing things like I/O, storage optimization, compression, indexing, security, schemas, sharding, partitioning, audit, backup, et al. Not to mention queries.
  • 1
  • 21
    thats basically mongoDB with less steps
  • 3
  • 0
    You are free to do so, Everything at one place is never a good idea.
  • 5
    Why just not use an excel spreadsheet? #ukgovernment
  • 1
    @IntrusionCM "profound dumbness" is not a constructive term for someone who is clearly just learning and new to the field
  • 1
    @theabbie haha you can relate XD
  • 1
    @IntrusionCM Not nice... clearly he is asking an honest question, it has nothing to do with dumbness.
  • 1
    for table data please use csv instead of json
  • 1
    @pxeger I said "profound dumbness _detected_".

    I didn't say: The author is profound dumb.

    It has nothing to do with the author as you imply - which is shady in my opinion.

    It's more that it's obvious that the answer cannot be trivial and that - if A was possible - people wouldn't do B.

    Profound dumbness as the more you'll try to answer the question, the deeper you'll have to dig in all kinds of research and realize your own lack of knowledge.

    Which includes my own lack of knowledge. I was pretty shocked when I first read PostgreSQL FSync Gate... For several reasons ;)
  • 7
    It depends on the use-case. Sometimes a plan and simple JSON is a better choice than a DB. Other times a DB is a better option.

    It depends on the context.
  • 0
    short: it depends

    if you want to save 5 lines of config data, a json is perfectly okay. or if you want to send a small network object to a client application too.

    if you try to save a million users with a million config entries, a json becomes very impractical, it takes forever to read save or search, you have no query abilities, filters or access by more than one user at a time.
    in general, if you would need that file more than once a second, you are past the limit imo.

    You usually define your data structure before making it.
    if you have relations (eg a customer having orders) thats a pointer towards a relational database.
    if you have a local config file with a few lines, that you always load as a whole anyways on startup, thats the use case of a local file.
    it is probably good to note that json may not always be the best notation for each case either. by my experience its mostly used for data transmission in networking.
  • 1
    @yowhatthefuck oh, you remember, anything in public domain is not a good idea either.
  • 0
Add Comment