1300438 - The Places database documentation is outdated, or at least inaccurate on some platforms

Status: RESOLVED WONTFIX

(Developer Documentation Graveyard :: Mozilla Platform, defect, P5)

Description

[ajarara]

:: Developer Documentation Request

      Request Type: Correction
     Gecko Version: unspecified
 Technical Contact: 

:: Details

On Linux 48.0.1, there is no moz_bookmarks_roots table in my places.sqlite file. Full schema dump is here: 

https://gist.github.com/alphor/a25168f49971bf31f4399295211d58f2

Further, the Bookmarks Service Design link is broken. I can't find it elsewhere, unfortunately. The only other broken link points to an MXR source link, labelled under nsNavHistoryExpire. I could not find that term anywhere in the DXR representation, otherwise I'd hand it over.
 
If this information is better serviced in the Bookmarks Service Design, or is already in it, then disregard the following:

There is no info about what certain fields mean. type, for example, makes me think that if type is 2 then it's a folder. but this is not the case. Tags are also type 2. Type 1 doesn't solely consist of bookmarks, though, there are entries that have no title and only refer to the tags entry and to the entry in moz_places. I don't know what these do, nor do I know how to safely ignore them (besides checking if their titles are null, which seems dicey)

It would be nice if the docs also included specifics. For example:

in moz_bookmarks there are several ids that are special:

select id, guid from moz_bookmarks where id <= 5;

1|root________
2|menu________
3|toolbar_____
4|tags________
5|unfiled_____

all the rest are descendants of these.

thank you!

Comment 1

[BMO Automation]

MDN Web Docs' bug reporting has now moved to GitHub. From now on, please file content bugs at https://github.com/mdn/sprints/issues/ and platform bugs at https://github.com/mdn/kuma/issues/.