UK Amazon Kindle Forum discussion

Someone over on Amazon wanted to get their hands on their kindle vocabulary builder. It amused me for a couple of hours....


Here it is :



So, it is easy to get the vocabulary from your Kindle. Plug kindle in to PC. Open Kindle device in Windows explorer. Right click path bar and edit path to add \system
You can now see all the kindle hidden files
Your vocab is in a folder called vocabulary.
Copy the DB file to your PC.

That was the easy bit. This is an SQL database so you need something to read it with. If you don't know SQL or understand databases this could get a bit daunting from here on.
The tables in the .db are :
Words
Lookups
Book_info
Dict_info

There a re a couple of system tables too.

You need to write some SQL to get the information you need out.

If you still fancy tackling this then try SQLite (this database was built with it)
http://turbo.net/apps/sqlite-database...

So the table links turn out to be pretty simple :
For Words :
select * from words left outer join lookups
on lookups.word_key=words.id

For Book Info :
select * from book_info left outer join lookups
on lookups.book_key=book_info.id

For Dict Info
select * from dict_info left outer join lookups
on lookups.dict_key=dict_info.id

Or put it all together :
select
book_info.asin,book_info.lang, book_info.title,book_info.authors,words.word,words.lang,lookups.usage
from lookups
left outer join book_info
on lookups.book_key=book_info.id
left outer join dict_info
on lookups.dict_key=dict_info.id
left outer join words
on lookups.word_key=words.id
---

You've just given me a migraine.

I felt sure you would want to give it a go too :)

What is the vocabulary builder?

The latest Kindle Paperwhite (second generation) offers the Vocabulary Builder feature. With Vocabulary Builder, you can look up words with the dictionary and memorize their definitions.

By default, every word you look up in the dictionary is added to a list that you can access using Vocabulary Builder. From any book, tap Menu — Vocabulary Builder. The screen appears, listing the words you've looked up. Tap a word to see its definition. On the menu that appears, you can tap the Usage tab to see how the word was used in the book.

The Vocabulary Builder is handy but only when on kindle, of course. I have a Kobo plus paper books and a lot of journals and academic books so I found that I work best with the tandem of an A6 lined notepad ( with a cover imitating a ration book) and a cross-platform app The Farlex Dictionary. Hasn't let me down so far and I get to carry around my little book and scare non-geeks into semantic submission...

I bet you use a pencil too Hana.

My vocab builder is called a dictionary. That's a book containing the definitions of words...

Dave has been teaching his class how to use a thesaurus. They've now started referring to the class dictionaries as 'wordasauruses'

Patti (baconater) wrote: "Dave has been teaching his class how to use a thesaurus. They've now started referring to the class dictionaries as 'wordasauruses'"

http://oddlovescompany.com/wp-content...

A pen, Simon - only a blue one. Can't be a gel pen, either.

Way too many instructions. I stopped reading after "Right click path bar . . ." lol Lawyers and engineers do not follow instructions well. I am the former.