Avatar for Username

Søg i Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Læs mere

Denne tråd blev arkiveret. Stil et nyt spørgsmål, hvis du har brug for hjælp.

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

  • 2 svar
  • 3 har dette problem
  • 1 visning
  • Seneste svar af 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?

Ændret af NoahSUMO den

Alle svar (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