Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Development

Notices

Reply
 
Thread Tools Search this Thread
Old 10-16-2019, 09:57 AM   #1
Angelo.Mascaro
Junior Member
Angelo.Mascaro began at the beginning.
 
Angelo.Mascaro's Avatar
 
Posts: 2
Karma: 10
Join Date: Oct 2019
Location: Karlsruhe
Device: Kindle
Why series_index is double and not int?

Does a special reason for series_index to be double exist?
What does it happen if I use "DB browser for SQlite" and I change the type of series_index?

thanks, Angelo
Angelo.Mascaro is offline   Reply With Quote
Old 10-16-2019, 09:58 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: 35,450
Karma: 12734961
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
lots of series require series number like 1.5
kovidgoyal is offline   Reply With Quote
Old 10-16-2019, 10:22 AM   #3
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 23,991
Karma: 27923385
Join Date: Aug 2009
Location: The Central Coast of California
Device: K4NT, Galaxy Tab A, Kobo Aura2
And lots of us fake a range for Omnibus/boxed sets. [01.04] 1-4
(it gets muddy in places: [09.10] 9-10. 01.50 could be either a interval release or 1-5 )
theducks is online now   Reply With Quote
Old 10-16-2019, 10:48 AM   #4
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 17,700
Karma: 26732820
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
If the data type was being changed, it should be to something that allows some of those distinctions. The series index isn't a number in the same way as a software version number isn't.
davidfor is online now   Reply With Quote
Old 10-16-2019, 11:04 AM   #5
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 23,991
Karma: 27923385
Join Date: Aug 2009
Location: The Central Coast of California
Device: K4NT, Galaxy Tab A, Kobo Aura2
Quote:
Originally Posted by davidfor View Post
If the data type was being changed, it should be to something that allows some of those distinctions. The series index isn't a number in the same way as a software version number isn't.
I think the reasoning behind leaving it as is: the current method allows Numeric sorting. Alpha sorting requires uniform data entry. :WormsBigCan:
theducks is online now   Reply With Quote
Old 10-16-2019, 11:39 AM   #6
Terisa de morgan
Grand Sorcerer
Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.Terisa de morgan ought to be getting tired of karma fortunes by now.
 
Terisa de morgan's Avatar
 
Posts: 5,333
Karma: 5754618
Join Date: Jun 2009
Location: Madrid, Spain
Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2
Quote:
Originally Posted by theducks View Post
I think the reasoning behind leaving it as is: the current method allows Numeric sorting. Alpha sorting requires uniform data entry. :WormsBigCan:
You don't want to go near that at all.....
Terisa de morgan is offline   Reply With Quote
Old 10-16-2019, 12:01 PM   #7
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 17,700
Karma: 26732820
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by theducks View Post
I think the reasoning behind leaving it as is: the current method allows Numeric sorting. Alpha sorting requires uniform data entry. :WormsBigCan:
I'm pretty sure the reason for leaving at it is is to not break backwards compatibility without a really good replacement.

But the sorting is at least part of the point of what I said. For example, if it was treated as dot separated numbers (think version numbers), it isn't hard to sort. That isn't going to help other places such as on a device that doesn't understand this, but, it is closer to what is needed.

Honestly, I don't have a good solution. I know that the current method is far from perfect, but, it is better than it if was an integer.
davidfor is online now   Reply With Quote
Old 10-16-2019, 12:30 PM   #8
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: 35,450
Karma: 12734961
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
it can easily be changed to be a more sophisticated datatype in calibre itself. But then there is no support for it in any ebook format and it would become totally calibre private metadata. At least now EPUB 3 has some notion of series that works with a float and many EPUB software have added support for the calibre series metadata extension in EPUB 2 as well.
kovidgoyal is offline   Reply With Quote
Old 10-16-2019, 12:44 PM   #9
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 53,992
Karma: 50774064
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Aura H2O, Sony PRS-650, Sony PRS-T1, nook STR, iPad 4, iPhone 5
Quote:
Originally Posted by theducks View Post
I think the reasoning behind leaving it as is: the current method allows Numeric sorting. Alpha sorting requires uniform data entry. :WormsBigCan:
Here you go.
JSWolf is offline   Reply With Quote
Old 10-16-2019, 04:31 PM   #10
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 23,991
Karma: 27923385
Join Date: Aug 2009
Location: The Central Coast of California
Device: K4NT, Galaxy Tab A, Kobo Aura2
Quote:
Originally Posted by JSWolf View Post
Here you go.
Hmmm! I gave up fishing worms when I found out I don't like fish.
theducks is online now   Reply With Quote
Old 10-17-2019, 05:54 AM   #11
Angelo.Mascaro
Junior Member
Angelo.Mascaro began at the beginning.
 
Angelo.Mascaro's Avatar
 
Posts: 2
Karma: 10
Join Date: Oct 2019
Location: Karlsruhe
Device: Kindle
OK to everybody
You (everybody) convinced me :-)
I don't touch it!
Angelo.Mascaro is offline   Reply With Quote
Old 10-22-2019, 07:00 AM   #12
mariushm
Junior Member
mariushm began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Oct 2019
Device: none
I guess it could be changed to
series major
series minor

but would be minor benefits to it, as it would use about the same space in the database.

Also noticed there's anthologies or volumes/collections (books 1-2 or books 1-3 of a 20+ series) .. for example see Argeneau series (scroll to bottom): https://www.goodreads.com/series/40687-argeneau

And there's also short stories ... some label it as SS1, SS2 (Short Story 1 etc), others use series 1.0a , 1.0b ... a, b, c ... for short story.

Some use the decimals for short stories or a mix (ex .1 for short story, .5 for small novel) , for example Psy-Changeling series by Nalini Singh : https://www.goodreads.com/series/41454-psy-changeling
mariushm is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Series_Index search Sami Library Management 7 09-25-2015 11:54 AM
Plugboard, template series_index first? Truthowl Library Management 6 09-13-2014 01:34 PM
series_index manipulation kcz Library Management 15 10-15-2013 10:26 AM
Customize series_index value luoman Calibre 3 08-23-2013 05:11 AM
randomness in series_index prefixed to title thecyberdeaf Library Management 4 04-03-2012 10:57 AM


All times are GMT -4. The time now is 06:53 PM.


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