Moderator
|
Hi, Posting a question from Jonathan, under his permission:
|
Moderator
|
Hi Jonathan,
Thanks for contacting the Kexi community! Currently Kexi does not open SQLite files "in place", it needs some metadata added (once) so it can see the tables. This metadata is created by Kexi itself, so it's missing in sqlite files created elsewhere. So you of course have the SQLite 3 driver in Kexi. For the record, here is the SQLite file you have sent me (as you said elsewhere, it's public file): http://kexi-project.org/download/tests/ ... -31.sdb.xz (600KB compressed using xz). I am interested in this use case. Before Kexi handles it out of the box (ie. imports SQLite tables or files) I'd like to provide a workaround. Stay tuned. |
Moderator
|
Hello,
Just published a tutorial: Importing SQLite database into Kexi. Please do not hesitate to ask for clarifications or improvements. |
Registered Member
|
For what it's worth, I just posted a script that kinda-sorta does most of this, automatically: https://forum.kde.org/viewtopic.php?f=220&t=139243
Cheers Gary |
Registered users: Bing [Bot], gfielding, Google [Bot], markhm, sethaaaa, Sogou [Bot], Yahoo [Bot]