hftlclub / node-iltis

Node.js backend for ILTIS
MIT License
1 stars 0 forks source link

Info table as key/value store #35

Closed fmalcher closed 6 years ago

fmalcher commented 6 years ago

The info table is set up as a horizontal table with one row at the moment. We should invert this to a vertical table like a key/value store.

key (varchar(255)) PK value (varchar(255))

This also leads to more readable SQL queries: SELECT value FROM info WHERE key = "devMode"