Ce site disposera de fonctionnalités limitées pendant que nous effectuons des opérations de maintenance en vue de vous proposer un meilleur service. Si un article ne règle pas votre problème et que vous souhaitez poser une question, notre communauté d’assistance est prête à vous répondre via @FirefoxSupport sur Twitter, et /r/firefox sur Reddit.

Avatar for Username

Rechercher dans l’assistance

Évitez les escroqueries à l’assistance. Nous ne vous demanderons jamais d’appeler ou d’envoyer un SMS à un numéro de téléphone ou de partager des informations personnelles. Veuillez signaler toute activité suspecte en utilisant l’option « Signaler un abus ».

En savoir plus

Ce sujet de discussion a été archivé. Veuillez poser une nouvelle question si vous avez besoin d’aide.

Extract JSON from IndexedDB files

  • 2 réponses
  • 1 a ce problème
  • 16 vues
  • Dernière réponse par cool_man2k3

cool_man2k3
cool_man2k3
more options

Hello! I'm using Tab Session Manager to save opened tabs. It uses IndexedDB to store tab data as a JSON. Small JSONs are stored directly in SQLite DB, bigger ones - as a files with integer numbers as names. It's IndexedDB functionality, it's transparent for addons. As far as I understand after the last update to v74 something went wrong with this addon DB. Addon showed "IndexedDB Error". I saved DB files, reinstalled the addon and it works fine again. So now I want to restore my old sessions. SQLite file opens normally using DB Browser, for ex. Separate JSON files seems to be OK also. The problem is that both separate JSON files and JSON data in SQLite DB are not plain text JSON, but kind of binary data containing JSON. How could I extract if from there?

Hello! I'm using Tab Session Manager to save opened tabs. It uses IndexedDB to store tab data as a JSON. Small JSONs are stored directly in SQLite DB, bigger ones - as a files with integer numbers as names. It's IndexedDB functionality, it's transparent for addons. As far as I understand after the last update to v74 something went wrong with this addon DB. Addon showed "IndexedDB Error". I saved DB files, reinstalled the addon and it works fine again. So now I want to restore my old sessions. SQLite file opens normally using DB Browser, for ex. Separate JSON files seems to be OK also. The problem is that both separate JSON files and JSON data in SQLite DB are not plain text JSON, but kind of binary data containing JSON. How could I extract if from there?
Captures d’écran jointes

Toutes les réponses (2)

cor-el
cor-el
  • Moderator
  • Top 10 Contributor
more options

Do you mean that you see BLOB data (hex code) ?

If you use a SQLite browser/viewer to inspect the file and export this data to a file, doesn't that give you the actual data?

cool_man2k3
cool_man2k3 Auteur de la question
more options

cor-el said

Do you mean that you see BLOB data (hex code)? If you use a SQLite browser/viewer to inspect the file and export this data to a file, doesn't that give you the actual data?

I attached a screenshot. Same data in BLOBs in DB and in DB files. Small JSONs stored right in DB as BLOBs, large ones as separate files. Both have same non-plain text format. Seems like IndexedDB stores these JSONs in it's own binary format, that's why it's not plain-text. I'm asking about a way to extract plain text JSON from this binary (hex) BLOBs and files.

There are DB BLOB contents. Same format as a file that I showed above.

Modifié le par cool_man2k3