Restore Edge Collections with SQLite Browser

This title was summarized by AI from the post below.

Tip of the day - Edge Collections - gone but hopefully not forgotten if like me you used this useful feature to organise research and made the mistake of relying on it this might help but the answer is technical I'm afraid .. 1. Scan your user folder under windows for collectionsSQLite. 2. if its there get SQLLite browser (https://sqlitebrowser.org/) 3. run this sql view SELECT   c.title AS collection_name,   i.title AS item_title,   i.text_content AS item_description,   json_extract(i.source, '$.websiteName') AS website_name,   json_extract(i.source, '$.url') AS url FROM collections c JOIN collections_items_relationship cir   ON cir.parent_id = c.id JOIN items i   ON i.id = cir.item_id ORDER BY c.title, i.date_created; 4. copy paste or whatever - I put mine into OneNote table which hopefully will be around longer than me. thanks for reading

To view or add a comment, sign in

Explore content categories