Avatar for Username

সহায়তা খুঁজুন

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.

আরও জানুন

এই থ্রেডটি সংরক্ষিত ছিল। যদি আপনি সাহায্য চান তাহলে অনুগ্রহ করে একটি নতুন প্রশ্ন জিজ্ঞাসা করুন

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

  • 2 উত্তরসমূহ
  • 3 এই সমস্যাটি আছে
  • 1 দেখুন
  • শেষ জবাব দ্বারা 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?

NoahSUMO দ্বারা পরিমিত

All Replies (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