Bookmarks intelligence in Firefox

Firefox Development
3

Proof Of Concept 2

1. sample Bookmarks.csv in Firefox

"checksum","roots__bookmark_bar__children__children__date_added","roots__bookmark_bar__children__children__guid","roots__bookmark_bar__children__children__id","roots__bookmark_bar__children__children__name","roots__bookmark_bar__children__children__type","roots__bookmark_bar__children__children__url"
"5f768309166a824ee3c429310f5f2801","12283833653791385","d8d908c7-ae9d-4af0-9bf7-e90b49eeaaab","1","","url","google.com"

2. sample Bookmarks.md in Firefox

|checksum|roots__bookmark_bar__children__children__date_added|roots__bookmark_bar__children__children__guid|roots__bookmark_bar__children__children__id  |roots__bookmark_bar__children__children__name|roots__bookmark_bar__children__children__type|roots__bookmark_bar__children__children__url|
|--------|---------------------------------------------------|---------------------------------------------|---------------------------------------------|---------------------------------------------|---------------------------------------------|--------------------------------------------|
|5f768309166a824ee3c429310f5f2801|12283833653791385                                  |d8d908c7-ae9d-4af0-9bf7-e90b49eeaaab         |1                                            |                                             |url                                          |google.com                                  |

3. sample Bookmarks.json in Firefox

{
   "checksum": "5f768309166a824ee3c429310f5f2801",
   "roots": {
      "bookmark_bar": {
         "children": [ {
            "children": [ {
               "date_added": "12283833653791385",
               "guid": "d8d908c7-ae9d-4af0-9bf7-e90b49eeaaab",
               "id": "1",
               "name": "",
               "type": "url",
               "url": "google.com"
            }, {
               "date_added": "13282226653791385",
               "guid": "e8d908c7-ae9d-4af0-9bf7-e90b49eeaaab",
               "id": "2",
               "name": "",
               "type": "url",
               "url": "gorazy.com"
            },
         ],
         "date_added": "53283836064181830",
         "date_modified": "53286318399102380",
         "guid": "0dc5e13g-2hia-5j74-951f-3k233fe6c908",
         "id": "1",
         "name": "Bookmarks",
         "type": "folder"
      },
      "other": {
         "children": [  ],
         "date_added": "11282816063181841",
         "date_modified": "0",
         "guid": "82b081ec-3ee3-529c-8475-ab6c344590dd",
         "id": "2",
         "name": "Other bookmarks",
         "type": "folder"
      },
   },
   "version": 1
}

4. sample Bookmarks.sql in Firefox

CREATE TABLE mytable(
   checksum                                        VARCHAR(32) NOT NULL PRIMARY KEY
  ,roots_bookmark_bar_children_children_date_added VARCHAR(17) NOT NULL
  ,roots_bookmark_bar_children_children_guid       VARCHAR(36) NOT NULL
  ,roots_bookmark_bar_children_children_id         BIT  NOT NULL
  ,roots_bookmark_bar_children_children_name       VARCHAR(30)
  ,roots_bookmark_bar_children_children_type       VARCHAR(3) NOT NULL
  ,roots_bookmark_bar_children_children_url        VARCHAR(10) NOT NULL
);
INSERT INTO mytable(checksum,roots_bookmark_bar_children_children_date_added,roots_bookmark_bar_children_children_guid,roots_bookmark_bar_children_children_id,roots_bookmark_bar_children_children_name,roots_bookmark_bar_children_children_type,roots_bookmark_bar_children_children_url) VALUES ('5f768309166a824ee3c429310f5f2801','12283833653791385','d8d908c7-ae9d-4af0-9bf7-e90b49eeaaab',1,NULL,'url','google.com');

5. sample Bookmarks.bibtext in Firefox

% NETSCAPE-Bookmark-file-1
% This is an automatically generated file. It will be read and overwritten. Do Not Edit! 
@DOCTYPE{title="Bookmarks", h1="Bookmarks"}
@DT{item1, HREF="www.linux.org" ADD_DATE="1441686100" LAST_VISIT="1341286100" LAST_MODIFIED="0941286100" TITLE="linux" ICON=""} 
@DT{item2, HREF="www.ytb.com" ADD_DATE="1441686100" LAST_VISIT="1341286100" LAST_MODIFIED="0941286100" TITLE="ytb" ICON="ZBvaw=="} 
@DT{item3, HREF="opensource.org" ADD_DATE="1441686100" LAST_VISIT="1341286100" LAST_MODIFIED="0941286100" TITLE="src" ICON="Za2w=="}