KDb/TODOs/User data
Design page for task: Support for user data storage.
Rationale
Among others, this feature is needed by the Remember table column widths feature.
Requirements
- Backward compatibility
- Older Kexi versions should just ignore the data
- Per user-separation
- How: based on user name, this implies that updates are needed when user name changes
- How: in separate table kexi__userdata
- Backend independence - should work with the SQLite driver as well the server backends (any table-based backends)
- How: achieved using standard db table, related to objects
- Portability to Predicate and 100% schema-compatible with Predicate
- How: API will change but table schema will stay the same