Jump to content

Kexi/Plugins/Tables/Simple alter table

From KDE Community Wiki
Revision as of 23:26, 1 September 2012 by Jstaniek (talk | contribs) (Created page with "Design page for task: '''Simple approach to fulfill "Add support for alter table's design without losing data" wish'''. *Started: Jstaniek ([[User talk:Jsta...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Design page for task: Simple approach to fulfill "Add support for alter table's design without losing data" wish.

Rationale

Approach when modification to table schema is saved directly after user performed it is much easier than full alter table tired in Kexi 1.x and never delivered.

Analysis

  • Altering some physical properties would require immediate saving of the design but will not remove all the data.
  • Other properties (for which KexiDB::isExtendedTableFieldProperty() return true) can be modified without altering any data.

Requirements

  • Full data safety
    • It's better to warn and request data removal than claiming it is not necessary and then doing that