search

lazierthanthou / sqlite-manager

Manage all your sqlite databases using this lightweight extension for firefox, thunderbird, seamonkey, komodo etc.
http://lazierthanthou.github.io/sqlite-manager/
325 stars 133 forks source link

can this safely edit seamonkey profile files? How? #95

Open dhdurgee opened 5 years ago

dhdurgee commented 5 years ago

I have used this seamonkey extension for some time to view SQL files. I now have a reason to want to use it to modify one of seamonkey's own SQLite files. How can this be done, given that seamonkey is open to start the extension and will also be using the SQLite file?

The one in question I need to work on is signons.sqlite, which contains the remembered logins. One of my remembered sites made major changes and seamonkey can't remember the login on the new page. I am hoping to duplicate the old entry and then edit the URL to match the new page and have it work.

I see that this extension can also be run via xulrunner. I also see from the xulrunner page that this is supposed to work from firefox on the command line. Inspecting seamonkey I see the -app argument noted as well. Could I close seamonkey and then use it from the command line to start the xulrunner version? That would avoid the possible interactions.

justinclift commented 5 years ago

Hmmm, the "more guarantee to work" approach would be to update the .sqlite file using some different editor (eg the CLI, or maybe DB Browser for SQLite, etc).

But if you make a backup of your seamonkey profile directory, it should be safe for you to experiment and try things out with your existing SQLite Manager version anyway. After all, if it goes badly wrong, you can restore it from the backup. :smile: