<div class="gmail_quote"><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"> Message: 1 Date: Wed, 5 Jan 2011 17:20:51 +0000 From: javadayaz <<a href="mailto:javadayaz@gmail.com">javadayaz@gmail.com</a>> To: British Ubuntu Talk <<a href="mailto:ubuntu-uk@lists.ubuntu.com">ubuntu-uk@lists.ubuntu.com</a>> Subject: [ubuntu-uk] Editing .db files Message-ID: <<a href="mailto:AANLkTimSk2TyEco2j-ihtAVupVTMg89tx3txDcDmtuzT@mail.gmail.com">AANLkTimSk2TyEco2j-ihtAVupVTMg89tx3txDcDmtuzT@mail.gmail.com</a>> 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 </blockquote><div> 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 </div></div>