Discussion, talk and tips
https://forum.puppylinux.com/
Hi.
I can use UEXTRACT to unpack/extract a .db file.
In my example use it unpacks a .sql file.
I want to edit this file manually.
After editing I want to pack it again into a .db file.
How do I do this?
Thanks
Many different programs create ".db" extension named files, (it's a common name but not a standard format) and these can take many different proprietary formats. For anyone to answer this, you would have to specify which program and version you are trying to modify .db files for, and then find information about what specific file format that is, then find an application that will write your .sql modified files back to that format.
If it's possible to edit directly in the .db file itself without conversion to .sql, that might actually be easier. That would be possible if the files are ASCII text files, and you understood the format requirements, or if there was a dedicated editor that could handle them. Answering this will all probably take some online research on your part, unless somebody here has experience with your program and its formats.
Hi, and thanks for the reply.
It is the .db file from FreetuxTV.
FreetuxTV has lots of TV and Radio stations that doesn't work anymore.
My intention was -at least- to sort out the not working German TV and Radio stations
and to remove them from the .sql file, which is editable in Geany for example.
After that I wanted to rebuild the .db file, so it will be accepted by FreetuxTV.
FreetuxTV has no option to delete single stations, only groups of stations can be removed. 
Again, thanks.
I see you marked this thread "Solved" so was there a solution?
Weird!
Looks like an unidentified moderator has interfered with the title -- this has happened to me as well, and it's extremely irritating!
Looks like an unidentified moderator has interfered with the title -- this has happened to me as well lately, and it's extremely irritating!
Something weird is going on duplicating my posts as well.
Not a duplication.
Apparently you tried to edit your post 4 minutes later but created a new post instead:
"Looks like an unidentified moderator has interfered with the title -- this has happened to me as well lately, and it's extremely irritating!"
Sorry if the double post was something I did inadvertently, this new laptop's touchpad is problematic and overly sensitive and I occasionally brush it causing unintended results.
But, this thread's title wording and the addition of the (Solved) to the title had nothing to do with me, and apparently the OP did not do that either.
I have also had other thread titles changed recently, without notice, and anonymously. I assumed it was a moderator's change. I'm a moderator on other fora and elsewhere, unless someone's post is in clear violation of a rule, we don't change a post in any way without first contacting them, giving a reason for a any non-rule desired change and allowing them to make any requested change themselves. This is respectful to contributors who are not breaking any rule.
If UExtract was able to "unpack" it, it was just an SQLite database.
To dump database to an SQL file:
Code: Select all
sqlite3 input.db .dump > output.sqlTo do the opposite and turn an SQL file back into database:
Code: Select all
sqlite3 output.db < input.sqlGreetings!
Hi.
@JakeSFR
Made a quick test:
Code: Select all
sqlite3 input.db .dump > output.sqlDoesn't work. Returns/extracts only this:
Code: Select all
SQLite version 3.22.0 2018-01-22 18:45:57
Enter ".help" for usage hints.
sqlite>
sqlite> When extracting with Uextract it returns a file with 1213 lines of XML code.
But this one works:
Code: Select all
sqlite3 output.db < input.sqlIt returns a .db file which seems to be loaded properly by FreeTuxTV, even though it is a bit smaller in Kb.
40 Kb compared to 104 Kb after re-packing with sqlite3.
Thanks! 
I think this is solved now for real.