Exporting list of authors from KoboReader.sqlite

[Semwize]

What's the easiest way to do this? I have ~ 2000 books on my device, would like to get a list of all authors.

[davidfor]

Open the database with an SQLite database management tool, and run the following SQL statement:

SELECT DISTINCT Attribution FROM content

This doesn't split up the multiple authors for book.

Whatever tool you use, should have a way to export the result.

[Semwize]

Originally Posted by davidfor

This doesn't split up the multiple authors for book.

Yeah, and it also adds authors that I don't have in the books I put to my device...

Edit:
Found several books with mix up author's first and last name, as well as books with extra spaces in dc:creator.

Thank you, David.

[davidfor]

As well as errors in the names, it will also include recommendations and previews. The query calibre uses is roughly:

SELECT DISTINCT Attribution 
FROM content  
WHERE BookID IS NULL  
AND IsDownloaded in ('true', 1 )
AND Accessibility IN (-1, 1, 2, 8, 9)

[Semwize]

Originally Posted by davidfor

SELECT DISTINCT Attribution 
FROM content  
WHERE BookID IS NULL  
AND IsDownloaded in ('true', 1 )
AND Accessibility IN (-1, 1, 2, 8, 9)

'Rakuten Kobo Inc.' added to the list

I got what wanted - a list of authors, looked in which books had author name errors, and fixed them. Thanks again, for some reason I was looking in the wrong place initially.