Comics database

Made with Baserow
1

I have started working on a comics database since i have a large collection of them. The books template doesn’t work for me since this is different from how comics work.

I made 4 tables
image

Comic = Comic
Uitgever = Publisher
Serie = Series (I think :grinning:)
Personages = Characters

Comic has the following structure

image
image1555×540 117 KB
I have text fields for year, a unique id and remarks. I have also added a file field for adding an image of the front cover.

Uitgeverij has the following structure

image
image1019×139 16.5 KB

Serie has the following structure

image
image1127×384 48.2 KB

Personages has the following structure

image
image1652×836 87.8 KB

The only formula i have used is this one
count(field(“Comic”))

It shows me in different tables, in how many comics the character appears, how many comics i have of a certain series, how many comics i have from a certain publisher.

When i am adding content it feels ok like i made it. Maybe some of you would have done it differently.

3 Likes
2

Hey @Peter! Nice, it seems that you have a large collection of comics :heart_eyes:
How many of them do you have in general?

It indeed works differently if you keep track of comics in comparison to books, so that’s right that you created your custom database. And thanks for sharing it here! We might have some comics enthusiasts in the community, and they can use your tables as references:)

2 Likes
3

I didn’t count them but i guess a couple of hundred at least. :grinning:

2 Likes
4

Whoa, that’s a lot! You can count them directly in Baserow using footer aggregations, for example:)

1 Like
5

You mean like this. Nice feature. Never used them until now.

image

image

3 Likes
6

Yeah, this feature is a bit hidden, we should make it more visible :sweat_smile:

2 Likes
7

Nice, Peter :raised_hands:

You’re right about book the book writing template being different from how you might archive/organize comics.

Gonna add this idea for future template releases. Thanks for the inspiration! :thought_balloon:

3 Likes
8

Hi guys,

I would like to include a database: ‘comics database’ in the Baserow. A curious question, where can I find this database: ‘comics database’ to import into Baserow? Can someone help me import this data: ‘comics database’ here? How to include a database: ‘comics database’ in baserow?

9

@anon59363363, comics database is a database that @Peter created it’s not a template. :slightly_smiling_face: