Avatar for Username

Zoeken in Support

Vermijd ondersteuningsscams. We zullen u nooit vragen een telefoonnummer te bellen, er een sms naar te sturen of persoonlijke gegevens te delen. Meld verdachte activiteit met de optie ‘Misbruik melden’.

Meer info

Deze conversatie is gearchiveerd. Stel een nieuwe vraag als u hulp nodig hebt.

In places.sqlite which bookmarks are "live bookmarks"?

  • 2 antwoorden
  • 3 hebben dit probleem
  • 1 weergave
  • Laatste antwoord van cor-el

THUFIR
THUFIR
more options

I'm interested in querying places.sqlite for all the live bookmarks, however, I'm not familiar with this database. I exported the moz_places table, and ran grep on the insert statements:

INSERT INTO "moz_places" VALUES(25010,'https://www.google.com/search?client=ubuntu&channel=fs&q=rss+cnn&ie=utf-8&oe=utf-8',NULL,'moc.elgoog.www.',1,1,0,NULL,100,1413097582782753,'f0M0e2nfq_VJ'); INSERT INTO "moz_places" VALUES(25011,'https://www.google.ca/search?client=ubuntu&channel=fs&q=rss+cnn&ie=utf-8&oe=utf-8&gfe_rd=cr&ei=bCg6VJ3VG4aV8Qf3l4GIBQ','rss cnn - Google Search','ac.elgoog.www.',1,0,0,29,100,1413097582971572,'wSZXfXwlnA1D'); INSERT INTO "moz_places" VALUES(25012,'http://www.google.ca/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CB8QFjAA&url=http%3A%2F%2Fwww.cnn.com%2Fservices%2Frss%2F&ei=bCg6VKnXI6T2iwKU6IDwCA&usg=AFQjCNHn-O_p5INKrhV93aMu0ixmtAJ98w&sig2=b9tUj8pmaxx8zm0RGU3yCw&bvm=bv.77161500,d.cGE&cad=rjt',NULL,'ac.elgoog.www.',1,0,0,22,100,1413097587642068,'HRefGS2PSAEM'); INSERT INTO "moz_places" VALUES(25013,'http://www.cnn.com/services/rss/','RSS (Really Simple Syndication) - CNN.com','moc.nnc.www.',1,0,0,1344,100,1413097588038096,'p9dKse4VE4U1'); INSERT INTO "moz_places" VALUES(25014,'http://rss.cnn.com/rss/cnn_topstories.rss','CNN.com - Top Stories','moc.nnc.ssr.',1,0,0,NULL,100,1413097596372991,'qq77Qsma7m5p'); thufir@dur:~/rss$ thufir@dur:~/rss$ cat moz_places.sql | grep "cnn"


so, those look like they're from the CNN feed -- good.

How would I do a proper query of the database for any and all such "live" bookmarks?

I'm interested in querying places.sqlite for all the live bookmarks, however, I'm not familiar with this database. I exported the moz_places table, and ran grep on the insert statements: INSERT INTO "moz_places" VALUES(25010,'https://www.google.com/search?client=ubuntu&channel=fs&q=rss+cnn&ie=utf-8&oe=utf-8',NULL,'moc.elgoog.www.',1,1,0,NULL,100,1413097582782753,'f0M0e2nfq_VJ'); INSERT INTO "moz_places" VALUES(25011,'https://www.google.ca/search?client=ubuntu&channel=fs&q=rss+cnn&ie=utf-8&oe=utf-8&gfe_rd=cr&ei=bCg6VJ3VG4aV8Qf3l4GIBQ','rss cnn - Google Search','ac.elgoog.www.',1,0,0,29,100,1413097582971572,'wSZXfXwlnA1D'); INSERT INTO "moz_places" VALUES(25012,'http://www.google.ca/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CB8QFjAA&url=http%3A%2F%2Fwww.cnn.com%2Fservices%2Frss%2F&ei=bCg6VKnXI6T2iwKU6IDwCA&usg=AFQjCNHn-O_p5INKrhV93aMu0ixmtAJ98w&sig2=b9tUj8pmaxx8zm0RGU3yCw&bvm=bv.77161500,d.cGE&cad=rjt',NULL,'ac.elgoog.www.',1,0,0,22,100,1413097587642068,'HRefGS2PSAEM'); INSERT INTO "moz_places" VALUES(25013,'http://www.cnn.com/services/rss/','RSS (Really Simple Syndication) - CNN.com','moc.nnc.www.',1,0,0,1344,100,1413097588038096,'p9dKse4VE4U1'); INSERT INTO "moz_places" VALUES(25014,'http://rss.cnn.com/rss/cnn_topstories.rss','CNN.com - Top Stories','moc.nnc.ssr.',1,0,0,NULL,100,1413097596372991,'qq77Qsma7m5p'); thufir@dur:~/rss$ thufir@dur:~/rss$ cat moz_places.sql | grep "cnn" so, those look like they're from the CNN feed -- good. How would I do a proper query of the database for any and all such "live" bookmarks?

Bewerkt door NoahSUMO op

Alle antwoorden (2)

guigs
guigs
more options

This might be better question on stackoverflow.com, but would a search for "rss" in the url string column be good?

http://stackoverflow.com/questions/13.../fastest-way-to-search-through-strings-stored-in-sqlite-database

cor-el
cor-el
  • Moderator
  • Top 10 Contributor
more options

You can use the SQLite Manager extension to generate a list.

  1. Open Profile Directory -> places.sqlite -> Go
  2. Hit the "Execute SQL" tab
  3. Use a SELECT like this: 
SELECT moz_bookmarks.id, moz_bookmarks.title, moz_items_annos.content
FROM moz_bookmarks, moz_items_annos, moz_anno_attributes
WHERE (moz_bookmarks.id = moz_items_annos.item_id) AND (moz_items_annos.anno_attribute_id = moz_anno_attributes.id) AND (moz_anno_attributes.name LIKE 'livemark/feedURI')
ORDER BY moz_bookmarks.id ASC