Dealing with collections without the Connect software?

[allovertheglobe]

Even though I have access to Windows, I seldom use it. With my Sony reader filling up with books, I appreciated the possibility of organizing them into "Collections", even if it is limited to the internal memory.

You have to use the Connect software to do so, afaik. You cannot do it on the device itself, and considering the glacial speed with which Sony releases any updates, I do not expect that to change anytime soon, not anymore than the inability to use collections on the memorycard.

The software I mostly use now, libprs500, does not (yet) support collections. Does any of the other alternatives out there? What do You do if you don't use the Connect software? Just skip collections altogether and flip pages upon pages in you booklist to find a particular title ? (Sony doesn't offer search or sort either...)

[kovidgoyal]

I tend to not keep many books on the reader. After all I'm not likely to be reading more than a handful of books in a given period of time. Just needs a little discipline to delete stuff from the reader every time you upload new books.

[pwalker8]

That's one of the reasons that Apple makes many different sized iPods. Some people like just a hand full of songs at a time while others like their whole collection available.

I personally use collections for a number of purposes. First I have one collection that has my "to read" books. Then I have collections that have books by specific authors or series (for example). Last I use collections to group books by subject matter. There are ways around all this, for example, create a rtf file that lists all my books listed by title, author, series and subject, but it's not nearly as natural as using collections. It sure would be nice if I could create collections on my mac or for that matter, if you could put books that are in the memory chip in collections.

[kovidgoyal]

What you're describing is basically a, pardon my saying so, rather hackish method of cataloging your collection. The reader simply isn't meant to do that and because the connect software is so closely tied to it, it doesn't do it well either. I maintain my catalog in a database on my computer, using a frontend I wrote specifically for that purpose.

[NatCh]

I'm sure your method is much more elegant than mine, kovidgoyal -- I just sort the files into folders by author's name (last, first) and then sub-folders for series (I pre-pend the position in the series to the title: i.e. "01 On Basilisk Station.RTF" would be in the "Honorverse" sub-folder of the "Weber, David" folder). It's kinda brute force, but it works well enough for me.

[kovidgoyal]

I used to do what you describe Natch, but then I found that it doesn't scale well. I started getting impatient with the amount of time it took to find a particular book. Now my database support tags and comments and a search function, so finding all the books in honorverse is as simple as tagging them on first import and then just typing in honorverse in the search bar. And it has a rating system so I never end up re-reading books I don't like ;-)

[NatCh]

Yup, a much more elegant solution. Does it run on windoze?

[HarryT]

I use an Access database to catalog all my eBooks. Perhaps slightly OTT, but since I'm a bit of a database "whizz" (databases are what I spend a large part of my day dealing with at work) I find that the power and flexibility of SQL queries lets me extract all sorts of information very easily.

[JSWolf]

Originally Posted by kovidgoyal

I tend to not keep many books on the reader. After all I'm not likely to be reading more than a handful of books in a given period of time. Just needs a little discipline to delete stuff from the reader every time you upload new books.

Because of the way the Reader's collections work, what I am doing is keeping the books loaded in the internal memory in collections and when I finish reading a book, I move it to my 2gig SD card for now. I know I have to come up with a better way to organize stuff. But for now this works.

[dhbailey]

I'm gradually coming up with an organization of all my e-books, which involves keeping a large number (280 or so) directly in the Reader's memory, but I have decided just this morning to do away with the memory card, since it does appear to use up some extra battery just being in the reader, and since I really don't need over 2500 books to choose from at any one time.

I'm thinking of creating two identical directory structures on my hard drive, one as it stands now, containing all my e-books (mostly PG e-texts) and one completely empty. I would move books gradually from the full directory structure to the reader and then once they're read, placing them into the empty one, so I can tell at a glance which books I haven't read and which ones I have.

But of course I'll have archived them all onto DVD for more permanent storage.

[kovidgoyal]

@Natch
Yeah its the libprs500 GUI. Even has an installer. The only platform where it's still iffy is OSX.

@HarryT
I use an sqlite database. What metadata do you maintain in your database?

[NatCh]

Oh, the way you talked about it, I guess I assumed it was something else -- I'm going to have to download that rascal yet.

[HarryT]

[QUOTE=kovidgoyal@HarryT
I use an sqlite database. What metadata do you maintain in your database?[/QUOTE]

Basically for each book I store:

- Author(s)
- Title
- Category(s)
- Series
- Series Position
- Format (s)
- Source
- Comments

It's a bit more complicated that that in that, for example, I have a "Book" table, an "Author" table, and a "Book/Author" link table; this lets me have a "many to many" relationship between books and authors. Similarly with category and format.

[kovidgoyal]

Hmm I assume you enter the metadata by hand for each book? Otherwise you're likely to have many entries for the same author in your authors table.

[HarryT]

The data's all properly "normalised". I don't store the actual NAME of the author for each book - just a "foreign key" into the author's table. I've created some nice GUI forms in Access for doing the data entry ans searching.