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

Using an ordinary client to access the database ... like the one you can download from www.sqlite.org The only "description" field is an attribute (column) with the moz_places table. There is no "description" in the moz_bookmarks table. This is Firefox 68.0.1. Perhaps two years ago there

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

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

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] Hidden data

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

[sqlite] Wrong return code usage for shell.c.in

Hi, I have a database with several selftests. One of those selftests fails. This is correctly reported in the textual output of the sqlite shell. Yet, the error code when running for example ``` sqlite3 -batch