Skip to main content

Posts

Showing posts from July, 2014

Why Baby Boomers are Rich - They Worked Hard for the Money

So you'd better treat them right . The reason I have so far avoided discussing the disproportionate wealth held by the Baby Boomer generation (1945 to 1964) with my parents is that I know how they will cut me down. "We worked hard for it." They'll sniff dismissively at me (Gen X, 1965 to 1984), further implying that I do not have 'it' because I have not worked. I could throw up many reasons for my generation's relative failure: relatively insecure employment, declining public benefits, the opportunity cost of education instead of early entry into the workforce. But they would seem like excuses to those who recall times when they could walk out the door of one employer straight into another. So what exactly is the wealth premium on a life of stoic employment?

Firefox History Statistics - Import places.sqlite extract into LibreOffice Calc

If you've followed the first part, you should have extracted from your places.sqlite copy a fairly large CSV file full of website visits. What are you waiting for? Double-click it, or File -> Open in LibreOffice Calc to launch the Text Import dialog. Importing Correctly You'll note from the last post that the export contains 5 columns: url,  host, rev_host, title, and timestamp. By default, columns are imported as 'standard' text. But it is critical that you import any timestamps as a date/time field, so right click the column and choose the appropriate format.

Firefox History Statistics - Extracting from Places.sqlite

If you want to take a look at Firefox surfing activity, the about:me add-on is a good start. However, it presents only one view of data and is thus limited in its ability to present more detailed statistics. We will view that data in a different program. So let's first extract it from the browsing history stored in the Places.sqlite file into a CSV file using a Firefox add-on. Step 1 - Locate and copy Places.sqlite to a working location On Windows machines, Places.sqlite is found in a directory similar to: C:\Users\User1\AppData\Roaming\Mozilla\Firefox\Profiles\ .default\places.sqlite Copy the file to another location. The database will be locked while using Firefox, and the SQLite plugin we will use to open it.