[GH-ISSUE #951] Better parameters management #813

New issue

Closed

opened 2026-02-27 11:13:40 +03:00 by kerem · 0 comments

kerem commented

2026-02-27 11:13:40 +03:00

Owner

Originally created by @tonioo on GitHub (Oct 23, 2016).
Original GitHub issue: https://github.com/modoboa/modoboa/issues/951

The current way to store parameters in the SQL database is wrong (EAV tables) and not performant.

The easiet way to improve this would be to use a JSON field but there is no simple way to create a model compatible with all supported database engines.

Another solution, less performant but better than the current implementation, would be to manually encode/decode data using JSON and store it into a text field.

Originally created by @tonioo on GitHub (Oct 23, 2016). Original GitHub issue: https://github.com/modoboa/modoboa/issues/951 The current way to store parameters in the SQL database is wrong ([EAV](https://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model) tables) and not performant. The easiet way to improve this would be to use a JSON field but there is no simple way to create a model compatible with all supported database engines. Another solution, less performant but better than the current implementation, would be to manually encode/decode data using JSON and store it into a text field.