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, 08:57 AM   #1
Angelo.Mascaro
Junior Member
Angelo.Mascaro began at the beginning.
 
Angelo.Mascaro's Avatar
 
Posts: 6
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, 08: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: 44,144
Karma: 22670164
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
lots of series require series number like 1.5
kovidgoyal is offline   Reply With Quote
Advert
Old 10-16-2019, 09: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: 30,100
Karma: 57259780
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
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 offline   Reply With Quote
Old 10-16-2019, 09: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: 24,905
Karma: 47303822
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 offline   Reply With Quote
Old 10-16-2019, 10: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: 30,100
Karma: 57259780
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
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 offline   Reply With Quote
Advert
Old 10-16-2019, 10: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: 6,308
Karma: 12116851
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, 11:01 AM   #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: 24,905
Karma: 47303822
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 offline   Reply With Quote
Old 10-16-2019, 11:30 AM   #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: 44,144
Karma: 22670164
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, 11:44 AM   #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: 75,043
Karma: 131375774
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
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, 03: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: 30,100
Karma: 57259780
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
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 offline   Reply With Quote
Old 10-17-2019, 04:54 AM   #11
Angelo.Mascaro
Junior Member
Angelo.Mascaro began at the beginning.
 
Angelo.Mascaro's Avatar
 
Posts: 6
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, 06: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 10:54 AM
Plugboard, template series_index first? Truthowl Library Management 6 09-13-2014 12:34 PM
series_index manipulation kcz Library Management 15 10-15-2013 09:26 AM
Customize series_index value luoman Calibre 3 08-23-2013 04:11 AM
randomness in series_index prefixed to title thecyberdeaf Library Management 4 04-03-2012 09:57 AM


All times are GMT -4. The time now is 08:04 AM.


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