You mistakenly assumed that the page description is an attribute of the bookmark rather than of the page ... The list of all pages ever visited is stored in the moz_places table and one of the attributes (columns) in that table is the description of the page ...
-- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of bitwyse >Sent: Sunday, 4 August, 2019 10:33 >To: sqlite-users@mailinglists.sqlite.org >Subject: [sqlite] Hidden data > >Hello > >Many of you may already know that FireFox (and other Mozilla family >navigators like SeaMonkey) store their bookmarks in an Sqlite file >("places.sqlite"). >Bookmarks may include > - the name of the page > - the URL > - chosen labels > - keywords > - the description > >The last 2 are extracted from the page header. > >You _can_ edit the description - some programmers just use the title >and >others the first line(s) of the text (I've even seen about half of >the >page!) - but it's not much use - you can't search in it. >So I don't regret that it is no longer visible nor editable in the >latest versions of the bookmark manager. However the data REMAINS in >the >file, although it isn't displayed in a basic viewer (the FireFox >Sqlite >manager extension or DB sqlite viewer). >There is a field "bookmarkProperties/description" in the >"moz_anno_attributes" table but I can't find the corresponding data. > >Could it be hidden in a Blob? >What program (command?) would diplay it and allow deleting it? >(VACUUMing doesn't remove it.) > >(I have got rid of it by exporting the bookmarks to an HTML file, >deleting all the <dd> tag lines and then re-importing it - but that's >laborious and I would like to be able to do it in one operation.) > >Regards >Christophe > >-- >bitwyse [PGP KeyID 0x18EB38C4] >Les conseils - c'est ce qu'on demande >quand on connaît déjà la réponse >mais aurait préféré ne pas la savoir. > >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
