How to store dictionary in sqllite3 db?

G

guit242021-12-01 12:46:53

Database design

guit24, 2021-12-01 12:46:53

How to store dictionary in sqllite3 db? so that later, it would be possible to take this data, sort it out and display it to the user through a chat bot? not suitable in text format.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

Sergey Gornostaev, 2021-12-01
@guit24

Look at the dictionary. If the structure is rigid, then it is logical to have a table with a column for each key. If different records can have a different set of keys, then look towards EAV. And there is another option to compile SQLite with the JSON extension and store the dictionary as a field with json.