1

I have used Calibre but I would like get more freedom in exporting it elsewhere for edits. I would like to do quality assurance of my books, papers and literature. Calibre does not communicate with database systems like MySQL, PostgeSQL and Oracle, discussed here. I would like to bind Calibre to PostgreSQL to do the data verification of each document in database. I think the best way would be to export Calibre´s library.

How can you export Calibre's library?

Improve this question
4
  • What sort of edits?
    – mmmmmm
    Jul 15, 2015 at 12:37
  • @Mark I added better description. I would like to do the quality assurance of the documents. However, there is no database connection to the software which is causing big problems. The only way to do it is export the library elsewhere.
    – Léo Léopold Hertz 준영
    Jul 15, 2015 at 13:03
  • I am still confused - calibre is based on SQLite for the library - the documents are in the file system and what do you mean by QA?
    – mmmmmm
    Jul 15, 2015 at 13:08
  • @Mark QA about the search capability, for instance. To built external tables to support the library. To test search characteristics of documents systematically with the library.
    – Léo Léopold Hertz 준영
    Jul 15, 2015 at 14:16

1 Answer 1

Reset to default
1

Calibre is based around a SQLite database so you can do SQL work including adding tables on it directly - I think calibre only creates extra tables with books_ or custom_ as a prefix so your own tables would not be affected by it.

Extra fields can be added which appear in the GUI to be extra fields in the Book table but are actually each in tables with a 1-1 mapping to the Books table

To extract data any sql tool can be used including the command line sqlite which Apple includes in OS X .

There are plugins like Multi Column search that allow more complex searches to be done.

Improve this answer
4
  • Is there anyone here who is doing such an QA here? This should be a part of any research work regularly/daily.
    – Léo Léopold Hertz 준영
    Jul 15, 2015 at 16:26
  • What do you mean by QA?
    – mmmmmm
    Jul 15, 2015 at 16:33
  • QA is Quality Assurance. I want to check the OCR of the file. Test how fast it is with specific test searches. See if I need to integrate Search capability to it afterwards with an external layer; again test it. Further, extension possibilities too.
    – Léo Léopold Hertz 준영
    Jul 15, 2015 at 16:34
  • 1
    So add fields to the calibre schema using the preferences
    – mmmmmm
    Jul 15, 2015 at 16:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .