Re: [sqlite] Hidden data

On Sun, Aug 4, 2019 at 9:40 AM Simon Slavin wrote: > On 4 Aug 2019, at 5:33pm, bitwyse wrote: > > > Could it be hidden in a Blob? > > What program (command?) would diplay it and allow deleting it? > > (VACUUMing doesn't remove it.) > > There's only one program guaranteed to get at every element

Re: [sqlite] Hidden data

Thank you, Adrian, that's really helpful. 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

Re: [sqlite] Hidden data

On 5/8/19 12:33 AM, bitwyse wrote: > There is a field "bookmarkProperties/description" in the > "moz_anno_attributes" table but I can't find the corresponding data. I suspect that's the key right there. I don't have any descriptions stored in my places.sqlite, but this may surface something for

Re: [sqlite] Hidden data

Keith Medcalf a écrit : > > The only "description" field is an attribute (column) with the moz_places > table. There is no "description" in the moz_bookmarks table. There is NO description column in the moz_places table in my "places.sqlite" sqlite> .schema --indent CREATE TABLE moz_places(

Re: [sqlite] Hidden data

f Of bitwyse >Sent: Sunday, 4 August, 2019 12:55 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] Hidden data > >Keith Medcalf a écrit : >> >> You mistakenly assumed that the page description is an attribute of >the bookmark rather than of the page ...

Re: [sqlite] Hidden data

Keith Medcalf a écrit : > > 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

Re: [sqlite] Hidden data

ists.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

Re: [sqlite] Hidden data

Thanks to Simon and Thomas for their suggestions - I'll work on it! 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

Re: [sqlite] Hidden data

Have you tried dumping the database ("sqlite3 places.sqlite .dump") and then searching for some known data in the resulting SQL file? - Original Message - From: bitwyse To: sqlite-users@mailinglists.sqlite.org Sent: Sunday, August 4, 2019, 18:33:29 Subject: [sqlite] H

Re: [sqlite] Hidden data

On 4 Aug 2019, at 5:33pm, bitwyse wrote: > Could it be hidden in a Blob? > What program (command?) would diplay it and allow deleting it? > (VACUUMing doesn't remove it.) There's only one program guaranteed to get at every element of a SQLite database file: the sqlite3 shell tool written and

[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