Many applications store their data in a SQLite3 database file. However Kexi requires the file to be created with Kexi. Moreover it does not accept importing the 3rd-party SQLite files.
An import option is a minimum what's needed.
Being able to import any SQLite3 file, Kexi can be used to further analyzing, editing and processing the data.
Example apps that use SQLite: Digikam, Kanboard. More at http://www.sqlite.org/famous.html.
Many programming languages have access to creation SQLite database files: Python, Ruby, Perl... not counting C/C++.
Requirements:
- Standard Kexi Migration plugin should be created, so schema and/or data is imported
- Data types should be preserved as much as possible. If unsure, fallback to long text.
Development plan:
- Research, design the architecture and functionality
- Test cases generation
- Implementation
- Verification using test cases
KDE bug: https://bugs.kde.org/show_bug.cgi?id=125843
This wish has 21 votes there during the last 8 years.
---
Want to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/3560958-add-support-for-importing-native-sqlite-3-databases?utm_campaign=plugin&utm_content=tracker%2F3324917&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F3324917&utm_medium=issues&utm_source=github).