The Database
The database...nice part, if it was finished already. Unfortunately...
I am simply too slow. But don't worry. I will complete it.
Database? What database exactly
I use PostgreSQL.
PostgreSQL? Yuck, why not mySQL
Simply I am more experienced with PostgreSQL. But if you really like
mySQL better...Don't forget, ComicMaster is open source and GPL.
Start coding ;-)
No, really. It can be done. It is not that difficult to add mySQL support.
Maybe later....much later.
What are the capabilities of the database?
Erm, currently it is a write-only database. *blush*. This means you can
enter data, but ComicMaster is very VERY limited in its abilities
to present the data.
What exactly can I do with the database now?
You can:
- Enter comic title and 'attach' an arbitrary number of publishers
to it.
- You can enter the names of persons or groups and 'attach' an
arbitrary number of 'jobs' to it.
- Of course you can enter whatever job you like.
- You can add languages tags. Anyone collecting comics in different
languages?
- You can add predefined comments
- You can add image format information
- You can add publisher
- You can add quality information
- You can add series information and attach an arbitrary number of
titles to it, e.g. define a series 'Zero Hour' and attach all
titles which were part of it.
- And you can add page type informations
This is all information, which you can add in the 'Base' widget of the
database tab. See:Database base widget
But there also is a complex database tab. In this you can:
- Select a title and add a comic, which is identified by issue number,
version number, month, year, language, and the predefined comment
entered in the base widget. You can also attach a free description to
your comic, give some information where you stored it. And if you like
where you got it and who scanned it.
- Do you noticed that comics are rather boring? I think the interesting
stuff are the stories in it ;-)
So you can add an arbitrary number of stories to a comic. Each story
can have a series information and the number it has in the series.
*gasp* so I can see what belonged to 'Zero Hour' and see the reading
order? Yep, that is the idea. There is also space to enter a free
comment, the title of the story. And you can add the names from the
base widget. If this name happens to have the job 'writer' oder
'artist' attached.....I guess you know what this is good for.
Finally you can add as many predefined keywords to a story as you like.
If you want to search stories which contain 'Superman, Red Kryptonite.
Myxi..Myxy..Mxt..erm Lex Luthor. You can do it. See:
Complex database tab