[ubuntu-uk] Editing .db files

[Patrick Bulteel]

>
> Message: 1
> Date: Wed, 5 Jan 2011 17:20:51 +0000
> From: javadayaz <javadayaz at gmail.com>
> To: British Ubuntu Talk <ubuntu-uk at lists.ubuntu.com>
> Subject: [ubuntu-uk] Editing .db files
> Message-ID:
>        <AANLkTimSk2TyEco2j-ihtAVupVTMg89tx3txDcDmtuzT at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi,
>
> My podcast app on my android phone- Google Listen, saves any user data,
> playlists etc as a .db file.
>
> Is there anything i can use to open this file and edit the contents? Also
> if
> no options are available in the ubuntu universe i will also look at windows
> tools for this job.
>
> --
>
> Regards
>
> Javad
>

I wouldn't doubt that it's a sqlite3 database.

sqlite3  your.db

once you're at the sqlite> prompt you can use .help (note it's dot help) to
find out what else you can do.

Then a little sql magic will get you what you need.

--
Patrick
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-uk/attachments/20110105/7677cc50/attachment.html>