Re: [RCU] Shell script to modify user preferences

Cor Bosman wrote:

...

No, that can easily be done with plain SQL.

The reason to create this script was the fact that user settings are stored as PHP-serialized string in the database and thus cannot be changed using SQL commands directly.

Has there ever been a thought to change that into a key/value pair instead? Or would that create too much of a conversion hassle and maybe load on the db?

The values of user prefs itself can be complex structures instead of simple values. This makes it quite difficult to map them into SQL tables. Furthermore I prefer one read of one record instead of complex joins over multiple tables and iteration over hundreds of rows.

~Thomas