integers vs comma seperated text, like tags custom columns

Amalthia · 09-17-2022, 07:01 PM

Hello,

I'm making a chapter custom column and I'm not sure which option to select. Are there downsides to use "comma separated text, like tags, shown in the tag browser" compared to using just integers?

I assumed the stuff showing up in the tag browser would use more database resources?

Thanks,
Amalthia

ownedbycats · 09-17-2022, 09:24 PM

Personally, I used integers for my #chaptercount column.

They take up the same amount of database resources.

Integer column is for numbers. If you think you may want to use arithmetic on the numbers in the future, use Integer.

You can put numbers in a text column, but there it'll be more treated like a string of characters. The main disadvantage is that it may not sort the way you expect.

Amalthia · 09-18-2022, 02:59 AM

Quote:

Originally Posted by ownedbycats

Personally, I used integers for my #chaptercount column.

They take up the same amount of database resources.

Integer column is for numbers. If you think you may want to use arithmetic on the numbers in the future, use Integer.

You can put numbers in a text column, but there it'll be more treated like a string of characters. The main disadvantage is that it may not sort the way you expect.

Thanks for the input. I decided to go with integers.

09-17-2022, 07:01 PM	#1
Amalthia Wizard Posts: 1,190 Karma: 32370 Join Date: Jan 2007 Location: Anchorage, AK Device: Sony Reader PRS-505, PRS-650, PRS-T3, Pocketbook HD2	integers vs comma seperated text, like tags custom columns Hello, I'm making a chapter custom column and I'm not sure which option to select. Are there downsides to use "comma separated text, like tags, shown in the tag browser" compared to using just integers? I assumed the stuff showing up in the tag browser would use more database resources? Thanks, Amalthia

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Template: sum of multiple integers from other columns	Quuzuu	Library Management	4	01-17-2021 05:35 PM
Can I print a list of tags and custom columns created in Calibre?	KimbreLee	Calibre	7	03-15-2019 05:07 PM
Custom column - Comma separated text	MerlinMama	Library Management	4	09-17-2015 03:34 PM
custom columns from only certain tags	areyou	Library Management	2	12-15-2012 06:33 AM
Custom columns vs tags	Artha	Calibre	3	11-22-2011 10:25 AM

09-17-2022, 09:24 PM	#2
ownedbycats Custom User Title Posts: 11,365 Karma: 79528341 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Personally, I used integers for my #chaptercount column. They take up the same amount of database resources. Integer column is for numbers. If you think you may want to use arithmetic on the numbers in the future, use Integer. You can put numbers in a text column, but there it'll be more treated like a string of characters. The main disadvantage is that it may not sort the way you expect.

Advert