How to store settings in database?

Question

Database design

I am writing my bot for VK, it works with a database in sqlite, there is a need for settings for each user.
Tell me, how best to write down these settings? And what is the best way to work with them?

Answer 1

A plate of 2 columns, user_id + properties, ideally if there is a native json field, if not, the line will do.
You can have a plate with 3 columns, user_id+key+value
You can have 2 plates, keys: id+key & properties: user_id+key_id+value