How to store large amounts of settings in the database?

Hi all. How to store settings, a bunch of settings that vary from each other. In the future, there was a problem finding the data for settings, etc., etc.
July 2nd 19 at 14:02
2 answers
July 2nd 19 at 14:04
And what is the problem exactly? From your description follows the table settings which has 4 fields:
id
key
value
parent_id
well, on the server implement logic changes in child settings as you need..
Yes it is clear. But very much, about 50 keys settings. 1 key can come about 5 values (settings). How is it all done competently. Can patterns is Because right now, search on these parameters is not very convenient, but some requests are generally not feasible. - stephany3 commented on July 2nd 19 at 14:07
I personally with such problems are not encountered, although I assume that they are. 5 values for a key in a JSON store or something like that.. Can you give an example in which my inconvenient? I for example always lacked a key-value, but especially for your event added to the parent category.. - Odell commented on July 2nd 19 at 14:10
well in value, get a serialized array of settings. I did - Kris_Schoen commented on July 2nd 19 at 14:13
July 2nd 19 at 14:06
And You need just the database? I storage settings use consul (https://www.consul.io/).
Previously stored settings in the database, it was not as convenient as consul. Plus for the Consul there is no web interface.

Find more questions by tags Patterns of designingDatabases