Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 12-19-2016, 05:42 AM   #1
AnselmD
Zealot
AnselmD began at the beginning.
 
Posts: 105
Karma: 10
Join Date: Oct 2013
Device: none
Where can i find the old ticket #2575?

Hi,

in this old thread an old Ticket #2575 is mentioned.

Calibre performance over the network - MobileRead Forums
https://www.mobileread.com/forums/showthread.php?t=48647

Can anyone give me a hint, where i can find it?
AnselmD is offline   Reply With Quote
Old 12-19-2016, 06:00 AM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,319
Karma: 27111242
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
If you want to put the db file ina location other than the library folder the way to do it is with an evironment variable, as described here: https://manual.calibre-ebook.com/cus...ment-variables
kovidgoyal is online now   Reply With Quote
Advert
Old 12-19-2016, 06:37 AM   #3
AnselmD
Zealot
AnselmD began at the beginning.
 
Posts: 105
Karma: 10
Join Date: Oct 2013
Device: none
Quote:
Originally Posted by kovidgoyal View Post
If you want to put the db file ina location other than the library folder the way to do it is with an evironment variable, as described here: https://manual.calibre-ebook.com/cus...ment-variables
Thank you very much.

I have two questions about CALIBRE_OVERRIDE_DATABASE_PATH.

1.
I would like to use it to copy books from one library to another.
Is there a placeholder variable for the name of the library available? Otherwise i can not address different libraries with it!?

2.
Does this path also address the journal file?
AnselmD is offline   Reply With Quote
Old 12-19-2016, 06:53 AM   #4
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,319
Karma: 27111242
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
You cannot use it to copy books, as it will apply both to the target and src library and yes it takes care of the journal file as well
kovidgoyal is online now   Reply With Quote
Old 12-19-2016, 07:36 AM   #5
AnselmD
Zealot
AnselmD began at the beginning.
 
Posts: 105
Karma: 10
Join Date: Oct 2013
Device: none
Quote:
Originally Posted by kovidgoyal View Post
You cannot use it to copy books, as it will apply both to the target and src library and yes it takes care of the journal file as well

A placeholder variable for the name of the library (or another useful identifier) which can be used in CALIBRE_OVERRIDE_DATABASE_PATH, would solve it and make it easier to deal with different libraries in general and also in parallel.

It is not only useful for network drives, it can also be useful to have the database at a ssd and the books at a slower hardrive.

Shall i make a feature request?
AnselmD is offline   Reply With Quote
Advert
Old 12-19-2016, 07:40 AM   #6
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,319
Karma: 27111242
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
I'm afraid I dont have any interest in implementing that.
kovidgoyal is online now   Reply With Quote
Old 12-19-2016, 07:57 AM   #7
AnselmD
Zealot
AnselmD began at the beginning.
 
Posts: 105
Karma: 10
Join Date: Oct 2013
Device: none
OK.
Currently i am using linux and add a symbolic link from the metadata.db in the calibre libray to my ssd for each library. This works fine, but i am not able to use it for the journal file, because it is recreated for each transaction and the database files are not in a separated directory. Do you or anyone else have spontaneously an idea for a workaround?
AnselmD is offline   Reply With Quote
Old 12-19-2016, 08:29 AM   #8
AnselmD
Zealot
AnselmD began at the beginning.
 
Posts: 105
Karma: 10
Join Date: Oct 2013
Device: none
It it possible to set the
PRAGMA schema.journal_mode =
from DELETE
to TRUNCATE

with configuration (without changing the code)?
AnselmD is offline   Reply With Quote
Old 12-19-2016, 09:03 AM   #9
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,319
Karma: 27111242
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
No allowing config file to execute arbitrary SQL would be a recipe for data loss.
kovidgoyal is online now   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ticket 9031 scissors Library Management 11 12-08-2011 05:04 AM
ticket for this issue already exists. Use the search function to find it. cybmole Calibre 11 01-27-2011 06:20 AM
Ticket# 5649 crutledge Calibre 5 06-29-2010 02:25 PM
Ticket #5649 crutledge Calibre 1 06-02-2010 12:45 PM
How do I open a ticket? AlexBell Calibre 2 07-16-2009 05:15 AM


All times are GMT -4. The time now is 12:32 PM.


MobileRead.com is a privately owned, operated and funded community.