Bug 125253 - Add support for alter table's design without losing data
Summary: Add support for alter table's design without losing data
Status: ASSIGNED
Alias: None
Product: KEXI
Classification: Applications
Component: Tables (show other bugs)
Version: unspecified
Platform: unspecified All
: NOR wishlist
Target Milestone: ---
Assignee: Jarosław Staniek
URL: https://invent.kde.org/office/kexi/-/...
Keywords: bounty
: 234191 305506 311783 379080 (view as bug list)
Depends on:
Blocks: 301262 304757
  Show dependency tree / graph
 
Reported: 2006-04-09 22:42 UTC by Bram Schoenmakers
Modified: 2023-04-14 16:59 UTC (History)
5 users (show)

See Also:
Latest Commit:
Version Fixed In:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Bram Schoenmakers 2006-04-09 22:42:19 UTC 
Version:           Kexi 1.0 (KOffice rc2) (using KDE KDE 3.4.3)
Installed from:    Gentoo Packages
Compiler:          gcc 3.4.5 
OS:                Linux

It should be possible to modify the table's design without losing all it's data.
Comment 1 Jarosław Staniek 2006-06-22 09:38:22 UTC 
FYI: The feature is in development now for 1.1.
Comment 2 Bram Schoenmakers 2006-11-19 22:08:20 UTC 
What is the status on this?
Comment 3 Jarosław Staniek 2006-11-19 23:24:43 UTC 
It's partially implemented, what means we cannot dare to enable this by default - many cases are not covered yet. It's already ported to KDE4 so will be a part of Kexi 2.0 or 2.1.
Comment 4 Jarosław Staniek 2006-11-19 23:25:56 UTC 
Hmm, let's keep it open.
Comment 5 Artur Czajka 2007-06-18 00:53:44 UTC 
I suppose, from what I've seen, that Kexi's problems with ALTER TABLE might've came from sqlite's problems. Maybe it would be a good idea to contribute in sqlite project itself, since code is public domain, so Kexi won't be the-only-one with ALTER support in sqlite-world.
Comment 6 Jarosław Staniek 2007-06-18 10:14:16 UTC 
@Artur: true, but this would force me to downgrade the toolset used to C from C++ and to  self-made facilities (of worse, to glib? aah) from Qt. I've already experienced this problem with mdbtools and I rather have no desire to manage another part created in similar technology. Manageable source (C++ with a good abstraction) is important.

The code could be reused at least in KDE and probably - apps that link to Qt libs (not necessary the GUI ones; the code is in KDE4 already), so the audience is not small. To work at sqlite's level, it would need a close collaboration on its 'kernel' level - a task for what I have no motivation, time and even money :)

That said, I have been really hoping to see someone working within sqlite on the stuff. Some people think sqlite would be became internally too complex after the adition.
Comment 7 Jarosław Staniek 2010-05-07 22:06:32 UTC 
*** Bug 234191 has been marked as a duplicate of this bug. ***
Comment 8 Jarosław Staniek 2012-08-20 23:59:14 UTC 
*** Bug 305506 has been marked as a duplicate of this bug. ***
Comment 9 Jarosław Staniek 2012-08-20 23:59:37 UTC 
I plan to have simple option: altering some physical properties would require immediate saving of the design but will not remove all the data. Other properties would be enabled for modification even without that. Hopefully for 2.6.
Comment 10 Carlos Cámara 2012-08-22 10:01:50 UTC 
Glad to hear that! Willing to have that feature for 2.6 so I will be able to migrate from Libreoffice Base to Kexi after all!
Comment 11 Jarosław Staniek 2012-12-16 18:00:33 UTC 
Delayed to 2.7 because of limited resources but the result shall be solid.
Comment 12 Jarosław Staniek 2012-12-16 18:04:41 UTC 
*** Bug 311783 has been marked as a duplicate of this bug. ***
Comment 13 Jarosław Staniek 2015-08-26 06:47:45 UTC 
Founding possible at https://github.com/staniek/kexi/issues/1 (click Post a bounty on it)
Comment 14 Jarosław Staniek 2018-12-30 13:07:58 UTC 
*** Bug 379080 has been marked as a duplicate of this bug. ***