Adding the ability to include a password on opening a kexi database would be great. Many times we share our systems but only want a limited amount of people to have access to our databases. Thanks for the hard work Reproducible: Always
There is also related wish https://bugs.kde.org/show_bug.cgi?id=300625 "Add password protecting to individual objects in Kexi ".
I meant https://bugs.kde.org/show_bug.cgi?id=300626.
dips on that :) looks like fun :)
Yep, fun. We need to take some time to design this and consider security. And tools to use for encrypting. Looking at how people do that with SQLite 3 is welcome (ideally: at record level, incrementally). And, I just extended the area of discussion, since as soon as we take the user's goals, we observe that it *may be* not about password protecting: https://forum.kde.org/viewtopic.php?f=221&t=102232&p=320343#p320343 That said, password protecting is a valid task.
Maybe look at how LibreOffice does it - not sure about your license but if it's compatible might not need to redesign from scratch :-D
@jmadero Good hint. Always good to look around. There are differences: LibreOffice does not use "standard" file, it's compressed Java-based HyperSQL, instead of "standard" SQLite. We want to combine password-protecting with encrypting I think? Then we'll also look at full encrypting of SQLite.
Design page would be at: https://community.kde.org/Kexi/Security/Add_password_protecting_to_Kexi_database_files
@Wojciech Now that you're busy with porting I propose to leave this development as unassigned again.