Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Download Sqlite Manager
11 views
Skip to first unread message
Tanesha Jankoff
Jan 3, 2024, 12:52:09 AM1/3/24
to
My old firefox not responding quite often, so i uninstaled it, and deleted preferences lalala. But i backup my profile. And then i instal new firefox (firefox 26.)But after i copy-paste places.sqlite, i don't get my browsing history back, i only get my bookmarks backSo yeah, any idea?
download sqlite manager
Download File https://t.co/2eqQPJQ2df
After copy-paste the places.sqlite, i executed places maintenance with that addons. But then places.sqlite back to 10MB, while my old places.sqlite is 80MbAnd about sqlite manager, yeah i checked it, and there are my history there, but not in firefox.But thanks anyway
First, i had to rename AddressBook-v22.abcddb to end with a .db suffix before i could get my sqlite DB browser (Version 3.8.0) to recognize it as a SQLite database, even though sqlite3 could open it from the command line.
Note that while I'm able to get existing Contacts data in these tables, I haven't found anyway to have Contacts take up any subsequent edits to the sqlite database. bmike suggests using vCard import/export, and that is certainly a workaround.
The sqlite-web project consists of a pip-installable Flask application and a console_script for running it easily from wherever it is installed. You point it at a database file, which will be created if it does not exist, and are presented with a web interface for navigating and performing common management tasks.
For Firefox, Windows user, the data is in C:\Users\[your username]\AppData\Roaming\Mozilla\Firefox\Profiles\[your firefox profile]\storage\default\moz-extension+++f0d6891d-57d6-4341-a27c-8bffc1001bb6^userContextId=4294967295\idb. And the file is 3647222921wleabcEoxlt-eengsairo.sqlite
Open with Sqlite editor such as Sqlite browser, SQLiteStudio
It is in table: object_data, key: 0ofwfsEpnbjot, and the never list is in data column but as blob (hex). If anyone can help us about how to edit this thing then please describe.
This follows the functionality found in the documentation (where connections must be explicitly closed, as per the statement "Note The context manager neither implicitly opens a new transaction nor closes the connection.". While it does follow the documentation, it might be less obvious when using context managers across different objects that do involve an implicit close. Would it make sense to enable an implicit connection close when using sqlite3.connect()'s in context managers to decrease the chance of surprising behavior and developer challenges?
For example, and somewhat related given the pattern of file-based object handling, the input and output documentation covering reading and writing files offers a familiar example that uses implicit file object closes with context managers.
Is there a way to save database changes, or does that happen automatically? When creating a new table in your bookstore example DB, it looks like it automatically saved it, without any kind of user ack. I suppose this is operating like the sqlite cli...there's no prompt to save before exiting. For a gui, though, a save db changes message might be expected.
Run the DB Browser app, and click the "Open Database" button on the toolbar. Navigate to your profile folder (see Part 0), and look for files like cookies.sqlite and places.sqlite. Use the "Database Structure" and "Browse Data" tabs to view the contents of each table stored in these files. Explore the other databases using this same process. Answer #1 and #2 in your worksheet.
Sometimes you will need to query two or more tables that have columns with the same name (e.g., id). You need to use the table name in that case so that SQL can tell which column you want. For example, in places.sqlite:
Today we'll use sqlite3 in two ways: the command line interface, and the FirefoxSQLite3 plugin. The Firefox plugin, with its graphical interface, isoptional. Everything can be done at the command line, if not as pretty.
Functions: instr() is a function that returns thelocation of a string within a larger string, or 0 if not found.Functions are specific to the database. The functions available forSQLite are documented here.Watch out - not all of them exist on my version of sqlite3. instr existsin Firefox but not my default Mac sqlite3.
You can stick the whole .sqlite file in your git repository, but youwon't see meaningful differences. You can also dump your database into aseries of commands that can reconstruct it from nothing, in any sqlitedatabase.
35fe9a5643
download sqlite manager
Download File https://t.co/2eqQPJQ2df
After copy-paste the places.sqlite, i executed places maintenance with that addons. But then places.sqlite back to 10MB, while my old places.sqlite is 80MbAnd about sqlite manager, yeah i checked it, and there are my history there, but not in firefox.But thanks anyway
First, i had to rename AddressBook-v22.abcddb to end with a .db suffix before i could get my sqlite DB browser (Version 3.8.0) to recognize it as a SQLite database, even though sqlite3 could open it from the command line.
Note that while I'm able to get existing Contacts data in these tables, I haven't found anyway to have Contacts take up any subsequent edits to the sqlite database. bmike suggests using vCard import/export, and that is certainly a workaround.
The sqlite-web project consists of a pip-installable Flask application and a console_script for running it easily from wherever it is installed. You point it at a database file, which will be created if it does not exist, and are presented with a web interface for navigating and performing common management tasks.
For Firefox, Windows user, the data is in C:\Users\[your username]\AppData\Roaming\Mozilla\Firefox\Profiles\[your firefox profile]\storage\default\moz-extension+++f0d6891d-57d6-4341-a27c-8bffc1001bb6^userContextId=4294967295\idb. And the file is 3647222921wleabcEoxlt-eengsairo.sqlite
Open with Sqlite editor such as Sqlite browser, SQLiteStudio
It is in table: object_data, key: 0ofwfsEpnbjot, and the never list is in data column but as blob (hex). If anyone can help us about how to edit this thing then please describe.
This follows the functionality found in the documentation (where connections must be explicitly closed, as per the statement "Note The context manager neither implicitly opens a new transaction nor closes the connection.". While it does follow the documentation, it might be less obvious when using context managers across different objects that do involve an implicit close. Would it make sense to enable an implicit connection close when using sqlite3.connect()'s in context managers to decrease the chance of surprising behavior and developer challenges?
For example, and somewhat related given the pattern of file-based object handling, the input and output documentation covering reading and writing files offers a familiar example that uses implicit file object closes with context managers.
Is there a way to save database changes, or does that happen automatically? When creating a new table in your bookstore example DB, it looks like it automatically saved it, without any kind of user ack. I suppose this is operating like the sqlite cli...there's no prompt to save before exiting. For a gui, though, a save db changes message might be expected.
Run the DB Browser app, and click the "Open Database" button on the toolbar. Navigate to your profile folder (see Part 0), and look for files like cookies.sqlite and places.sqlite. Use the "Database Structure" and "Browse Data" tabs to view the contents of each table stored in these files. Explore the other databases using this same process. Answer #1 and #2 in your worksheet.
Sometimes you will need to query two or more tables that have columns with the same name (e.g., id). You need to use the table name in that case so that SQL can tell which column you want. For example, in places.sqlite:
Today we'll use sqlite3 in two ways: the command line interface, and the FirefoxSQLite3 plugin. The Firefox plugin, with its graphical interface, isoptional. Everything can be done at the command line, if not as pretty.
Functions: instr() is a function that returns thelocation of a string within a larger string, or 0 if not found.Functions are specific to the database. The functions available forSQLite are documented here.Watch out - not all of them exist on my version of sqlite3. instr existsin Firefox but not my default Mac sqlite3.
You can stick the whole .sqlite file in your git repository, but youwon't see meaningful differences. You can also dump your database into aseries of commands that can reconstruct it from nothing, in any sqlitedatabase.
35fe9a5643
0 new messages