Places.sqlite is used in Firefox 3 instead of the older bookmarks.html and history.dat files (the older files are left in the profile folder for backward compatibility).

I opened a places.sqlite file with SQLite. Note: Firefox must be closed when you try opening the file or you will get the error message "Error: database is locked".

C:\Users\Administrator\Downloads>sqlite3 C:\Users\Administrator\AppData\Roaming\
Mozilla\Firefox\Profiles\q3wdrb9w.default\places.sqlite
SQLite version 3.6.23
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>

I then used .tables to see what tables were in it.

sqlite> .tables
moz_anno_attributes  moz_favicons         moz_keywords
moz_annos            moz_historyvisits    moz_places
moz_bookmarks        moz_inputhistory
moz_bookmarks_roots  moz_items_annos

The places.sqlite file contains the following tables:

• moz_anno_attributes - Annotation Attributes
• moz_annos - Annotations
• moz_bookmarks - Bookmarks
• moz_bookmarks_roots - Bookmark roots i.e. places, menu, toolbar, tags, unfiled
• moz_favicons - Favourite icons - including URL of icon
• moz_historyvisits - A history of the number of times a site has been visited
• moz_inputhistory - A history of URLS typed by the user
• moz_items_annos - Item annotations
• moz_keywords - Keywords
• moz_places - Places/Sites visited - referenced by moz_historyvisits

You can see what the columns are in a table using the .schema command, so I can use .schema moz_bookmarks for further information about the "bookmarks" table.

sqlite> .schema moz_bookmarks
CREATE TABLE moz_bookmarks (  id INTEGER PRIMARY KEY, type INTEGER, fk INTEGER D
EFAULT NULL, parent INTEGER, position INTEGER, title LONGVARCHAR, keyword_id INT
EGER, folder_type TEXT, dateAdded INTEGER, lastModified INTEGER);
CREATE INDEX moz_bookmarks_itemindex ON moz_bookmarks (fk, type);
CREATE INDEX moz_bookmarks_itemlastmodifiedindex ON moz_bookmarks (fk, lastModif
ied);
CREATE INDEX moz_bookmarks_parentindex ON moz_bookmarks (parent, position);
CREATE TRIGGER moz_bookmarks_beforedelete_v1_trigger BEFORE DELETE ON moz_bookma
rks FOR EACH ROW WHEN OLD.keyword_id NOT NULL BEGIN DELETE FROM moz_keywords WHE
RE id = OLD.keyword_id AND NOT EXISTS ( SELECT id FROM moz_bookmarks WHERE keywo
rd_id = OLD.keyword_id AND id <> OLD.id LIMIT 1 );END;

A diagram of the layout of the tables provides further information as does the The Places database.

I can see that there is a column named "title". So I can view the value for "title" for all entries in the table with select title from moz_bookmarks. Note: you may see a lot of what may appear to be extraneous bookmarks, i.e. webpages not bookmarked by the user. That's because you also see what you would see if you clicked on Bookmarks, Bookmarks Toolbar, Latest Headlines.

You can exit from sqlite with .exit, .quit, or Ctrl-C.

If you prefer a GUI to browse SQLite databases, you can use SQLite Database Browser, which can provide a graphical interface for browsing the databases on a Windows system.

To install the program, just unzip the files in the .zip file, once you've downloaded it, to the directory you want to use for it.

References:

1. SQLite
2. Locked or damaged places.sqlite
   MozillaZine Knowledge Base
3. Places.sqlite
   MozillaZine Knowledge Base
4. The Places database
   Mozilla Developer Center
5. SQLite Database Browser
   SourceForge
6. Improving Iceweasel Performance
   April 3, 2009
   Zenwalk Support

[/network/web/browser/firefox] permanent link

1. Click on the Start button.
2. Select All Programs.
3. Select Accessories.
4. Select Remote Desktop Connection.
5. When the Remote Desktop Connection window opens, click on Options.
6. Click on the Local Resources tab.

   

7. Click on the More button.
8. Click on Drives to share all drives. If yo only want to share some local drives, click on the "+" to the left of drives and select only the drives you want to share.

   

9. Click on OK.
10. Click on Connect.

If you go to My Computer on the remote system or use Windows Explorer, you should see the drives on the local system from which you connected listed among the drives visible on the remote system.

References:

1. Transfer files via the Remote Desktop
   Setup32.com

[/os/windows/software/remote-control/rdp] permanent link