How to report on your (Chrome) web history

For reasons not entirely related to 'just curiosity'. Here's how to do a report on your web history in Chrome.
Chrome is really nice, in that it uses a 'database format' for the various file. SQLite can be used to query it.

So here's how to do it (mostly for my reference):

1: Download SQLite shell from here: http://www.sqlite.org/download.html

2: Run a command prompt

3: Change to your 'chrome' history directory:
On XP – C:\Documents and Settings\name\Local Settings\Application Data\Google\Chrome\User Data
On Vista - C:\Users\name\AppData\Local\Google\Chrome\User Data


4: (Assuming you put the SQLite shell in D:\Tools - amend accordingly)
D:\Tools\sqlite3.exe History "select datetime(last_visit_time/1000000-11644473600,'unixepoch'),url from urls order by last_visit_time desc" > History.txt

This will extract the complete history - at least, assuming you haven't cleared it ever.

5: Open Excel, and import 'History.txt'. Use 'text to columns' (location varies depending on Excel version) and use delimiters of 'space' or '|' (other).

6: Add a couple of columns to your spreadsheet (I used C and D).
Title C as 'Find/' and D as 'Site'.
Populate C2 with: =FIND("/",E2,9)
Populate D2 with: =LEFT(E2,C2-1)

Paste the formula down the full list.

7: Add another column, at the end (Column F?) and put in it '=A1' and paste down. (Yes, that does mean Column F is a copy of Column A. There is method in my madness. )

8: Make a pivot table of your results. Set 'row' to 'Site', and 'values' to 'Count of URLs'.

9: Add a vlookup to your pivot table - if you've done the above, and happen to be on exactly the same versions of everything as me, Column C should be empty. Fill it in with: =VLOOKUP(A5,Sheet1!D:G,3,0) (The 'third column in the range D:G will be 'Column F' so this _should_ populate Column C with the last accessed date of that site)

10: Scroll down the list, and be shocked and awed at how many times you've visited Facebook.Com.

Energy Storage, micro generation, and the grid

So, one of the things I've been pondering. Actually, it's more along the lines of something that I think would be really cool - One Day (tm).

A Zero Net Energy house. It's what's got me pondering about renewables, micro generation, and energy storage.
I mean, I think you can do a _lot_ to improve on the current design of houses, to improve their overall efficiency. But in addition, supplement it with your own sources of power. Not necessarily electrical either - I mean, lets face it, most of the power used in a house is thermal. Refrigerators, ovens, central heating.

Which has me pondering. I mean, in practice, solar and wind power are fine, but sporadic. The time of year of the highest energy demand is a calm, clear winter night.

You have the option of 'grid storage' of your energy - in which, you basically just 'feed back' the power you generate to the national grid, and 'buy it back' when you actually need it. All well and good, but that _also_ suffers the same problems - the best form of bulk power storage is to not use it in the first place, and leave the coal (oil, gas, uranium) un-burned.

So anyway. Any form of energy state transformation is inherently inefficient - every time you go from heat, to mechanical, to electrical to potential, you end up 'wasting' something in the transfer. You also waste in distribution. Would it surprise you to find that most power stations aren't even 50% efficient, at generating electricity?
It's why heating your house electrically is a horrible idea - they burn the coal, heat water, drive a turbine, make electricity (wasting 50% of the energy) and then you turn it back into heat, wasting even more of it.

That's why I've been thinking about energy storage - electricity in batteries is the obvious one, but ... actually, electricity probably isn't your most useful energy form. If you've ever been camping, you'll know that running a kettle or a heater of a generator or batteries is a bad idea.

I like the idea of microgeneration. I like the idea of using a combined approach of wind, water and solar power, in some degree. And I like the idea of being able to 'buffer' (If not long term store) energy generated, so those cold still winter's nights don't end up with you becoming an icecube. (Actually, I don't think 'going off grid' is a good idea anyway, so there'll always be a plan B).

So far I'm thinking in terms of 'heat storage and efficient circulation' to keep a house a stable temperature.
Energy storage via water pumping to a reservoir, to use any 'slack' capacity. And potentially (if I can find a suitable location) a water wheel, that runs off a river, and can also be driven via the 'stored' energy.

But it's still a bit of a pipe dream. New technologies pop up all the time - you can do 'ground source' heating. Flywheels might be a possibility - it's more or less what a water wheel is, after all.

It all also sort of involves starting with a low energy house in the first place.
(Oh and for bonus points - materials used that don't have an overhead in terms of non-renewable materials)