Books and Series question

victic · 11-03-2014, 03:36 PM

Hello,

I am making an html interface to be able to reach my Calibre books over the internet.

One peculiarity I stumbled upon is relationship between books and series.

At first I thought that it was a classic many-to-many, since there is a "books_series_link" table in the database. But there is no way to include a book in more than one series in GUI, and I found the series_index field in "books" table.

So, my question is: is there ever gonna be a many-to-many relationship implemented between books and series?

I'm not asking just out of pure curiosity - there are, for example, some books by Michael Connely that belong to both "Harry Bosch" and "Mickey Haller" series, according to author himself: http://www.michaelconnelly.com/extras/series/

chaley · 11-03-2014, 04:37 PM

A book can have one series and one series index. A series can have many books. This will not change in the foreseeable future.

kovidgoyal · 11-03-2014, 09:53 PM

Go to Preferences->Add your own column and add another series column.

victic · 11-04-2014, 12:04 PM

Quote:

Originally Posted by kovidgoyal

Go to Preferences->Add your own column and add another series column.

Thank you!

11-03-2014, 03:36 PM	#1
victic Junior Member Posts: 2 Karma: 10 Join Date: Nov 2014 Device: Kindle Paperwhite	Books and Series question Hello, I am making an html interface to be able to reach my Calibre books over the internet. One peculiarity I stumbled upon is relationship between books and series. At first I thought that it was a classic many-to-many, since there is a "books_series_link" table in the database. But there is no way to include a book in more than one series in GUI, and I found the series_index field in "books" table. So, my question is: is there ever gonna be a many-to-many relationship implemented between books and series? I'm not asking just out of pure curiosity - there are, for example, some books by Michael Connely that belong to both "Harry Bosch" and "Mickey Haller" series, according to author himself: http://www.michaelconnelly.com/extras/series/

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Another Series question	Hampshire Nanny	Library Management	4	05-17-2014 05:54 PM
It’s Start a New Series Month! 30% Off First Books In A Series!	UntreedReads	Self-Promotions by Authors and Publishers	0	02-02-2012 05:46 PM
Different export filenames for series / non-series books?	HarryT	Calibre	3	08-18-2010 12:30 PM
Author, Series, Series #, Books	diokdin	Calibre	19	05-14-2010 05:36 AM
Pet peeve: series authors who introduce things in non-series books!	ficbot	Reading Recommendations	12	02-06-2010 02:14 AM

11-03-2014, 04:37 PM	#2
chaley Grand Sorcerer Posts: 12,440 Karma: 8012886 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	A book can have one series and one series index. A series can have many books. This will not change in the foreseeable future.

11-03-2014, 09:53 PM	#3
kovidgoyal creator of calibre Posts: 45,339 Karma: 27182818 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Go to Preferences->Add your own column and add another series column.

Advert