> > Message: 1 > Date: Wed, 5 Jan 2011 17:20:51 +0000 > From: javadayaz <javada...@gmail.com> > To: British Ubuntu Talk <ubuntu-uk@lists.ubuntu.com> > Subject: [ubuntu-uk] Editing .db files > Message-ID: > <aanlktimsk2tyeco2j-ihtavupvtmg89tx3txdcdmt...@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
-- ubuntu-uk@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-uk https://wiki.ubuntu.com/UKTeam/
