Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 07-23-2016, 07:47 PM   #1
pweasel
Member
pweasel began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Jun 2011
Device: Ipad v1
Lightbulb SQLite DB and books on different drives

Hi there,
How can I use the SQLite db of my collection on my D drive (an ssd) while storing my books on the X drive (NAS)?
thx,
PW
pweasel is offline   Reply With Quote
Old 07-23-2016, 07:51 PM   #2
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,729
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by pweasel View Post
Hi there,
How can I use the SQLite db of my collection on my D drive (an ssd) while storing my books on the X drive (NAS)?
thx,
PW
@pweasel see --> Environment variables -- CALIBRE_OVERRIDE_DATABASE_PATH Ψ²

Added : and you need to read this ==>> I am getting errors with my calibre library on a networked drive/NAS?

BR

Last edited by BetterRed; 07-23-2016 at 07:57 PM.
BetterRed is offline   Reply With Quote
Advert
Old 07-23-2016, 10:36 PM   #3
pweasel
Member
pweasel began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Jun 2011
Device: Ipad v1
mmmm, i guess i'm moving the DB to the SSD and the books to the main hdd.
pweasel is offline   Reply With Quote
Old 07-23-2016, 10:47 PM   #4
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,729
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by pweasel View Post
mmmm, i guess i'm moving the DB to the SSD and the books to the main hdd.
You may not get much performance improvement from putting the database on an ssd. As I understand it, when calibre starts it loads the db into memory, writes are done as needed, reads are from memory. Use the NAS as a backup for your library.

There's a new multi-user read/write calibre server in the works (version 3), some of it is accessible today if you download the source. I think it will address the difficulties of having the library on a network device.

Some people do have their calibre libraries on a NAS, but sometimes they have ran into problems and have had to revert, others have failed to get it to work. If you don't have it running on a NAS already, I suggest you keep it local for now and wait for version 3.

BR

Last edited by BetterRed; 07-23-2016 at 10:54 PM.
BetterRed is offline   Reply With Quote
Old 07-24-2016, 12:19 AM   #5
pweasel
Member
pweasel began at the beginning.
 
Posts: 12
Karma: 10
Join Date: Jun 2011
Device: Ipad v1
Quote:
Originally Posted by BetterRed View Post
You may not get much performance improvement from putting the database on an ssd. As I understand it, when calibre starts it loads the db into memory, writes are done as needed, reads are from memory. Use the NAS as a backup for your library.

There's a new multi-user read/write calibre server in the works (version 3), some of it is accessible today if you download the source. I think it will address the difficulties of having the library on a network device.

Some people do have their calibre libraries on a NAS, but sometimes they have ran into problems and have had to revert, others have failed to get it to work. If you don't have it running on a NAS already, I suggest you keep it local for now and wait for version 3.

BR
It's been working on the NAS since 2011, but the searches via the network page were a DRAGGGG (11500 books). I've been lucky to not be plagued by NAS problems it seems
pweasel is offline   Reply With Quote
Advert
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Scan hard drives for books not yet in catalog. birkmaggs Library Management 4 02-18-2016 02:00 PM
My k3 drives me crazy. pacraf Kindle Developer's Corner 16 01-18-2014 06:03 PM
SQLite Meeky Kindle Developer's Corner 2 01-01-2013 11:02 AM
Question about the 'preloaded books' sqlite file. cmm Kobo Reader 3 08-06-2010 04:22 PM


All times are GMT -4. The time now is 08:52 PM.


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