[prd0]

Originally Posted by sirbruce

But the whole point of the database is you use CALIBRE to find that book, not searching yourself on the disk. Just load up Calibre and type in the book you're looking for, boom, it's there. If you want to see the actual files on disk, select the entry in Calibre and hit 'o' to open the containing folder.

But calibre can't search the book the way I want. All my books are numbered according to series, and chapter. 1 chapter could consists 6 books. Like double helix got 6 books, and 6 authors, and 6 titles, spans from TNG #51 to TNG #56. Infection is first book in Double Helix, TNG number #51, author is John Gregory. Vector is second book, TNG ##52, authors are Dean W. Smith & Kristine K. Rusch.
For example, just now, a few moments ago, I am looking for the first book of progenitor. The progenitor is book two, and I want to find the book one, but I don't know the title, but all I know is it is Stargazer that I am looking for is number #1 as Progenitor is #2 of Stargazer series, a prequel to TNG series. When I typed stargazer, calibre shows only stargazer, the one at TNG series. There are 2 stargazers, the Stargazer from TNG series, and stargazer as series. Calibre did find stargazer, but only Stargazer from TNG series, not all stargazer series. At my folder, I can just open Stargazer folder, and find a file named 1 - xxxxxxx listed before 2 - Progenitor.
I don't mind using calibre as search database, if it is capable of one. But it is proven as does not, and I still have to find one myself.

It's hard to know what you did wrong since you were presumably trying to reorganize the files on disk. Again, as I said, change the authors as you want, and then do SAVE TO DISK and save a copy elsewhere, or SEND TO DEVICE if you want to have the book on your ereader. You may also CONVERT the files to a different format. All of these will contain the updated metadata except in certain cases.

No, I don't want to reorganize the files. I had them organized, and merely wanted to read them, convert to my phone, and if possible, catalog them by metadata that obviously are not read by windows explorer, but I don't want anything to mess with my folders.
The good library program I had in mind, is just like foobar's library.

The rearrangement and duplication of your books is so Calibre still has the data to work with no matter how you mangle your copies.

It has SqlLite, doesn't it? What does my file got anything to do? If it still needs to work with copies of my files, what does it use the SqlLite for?

Can't really help you there; someone else who has used Calibre with iphone will have to chime in. You might try posting a new thread specifically with that problem.

I already got stanza desktop to overcome this problem. But the way calibre rearrange my files made it hard for me to open the file on stanza desktop.

If you run into an error, you should report what that is; it's probably file-specific and you won't be able to convert that file. 1 hour doesn't necessarily mean it's taking too long, though; some books do take that long.

No.. it is converted, but only when I do it manually.

If you only want Calibre to convert, then I suggest that you drag the LIT book into Calibre, edit the metadta, do the convert to EPUB, wait for the conversion to finish, do a "Save to Disk" of the EPUB file somewhere else on your drive where you want it, and then hit the delete key to remove that book's entry from Calibre. Then Calibre will no longer serve as a database for your books nor will it retain a copy.

I'll try this one.. It seems it is the best solution.