First of all, thank you Polerio for the work that you have put into
I just have some questions/suggestions.
Database design. Why did you decide to go with the design that you
are using. Especially the phpmylibraryentries table, Bib info. I
don't think that it is a very good design, using a table for each marc
tag. I think I can understand why, it makes it much easier to edit
marc info, but I don't think that is the way it should be stored in
the database. The marc format was designed for transfereing info
between machines, not for storing in a database. Also it doesn't
appear that you use any indexes, this probably isn't an issue when you
only have a small amount of data, but what if you had 500,000 marc
records, doing a sequential scan through that can take a couple
minutes. And one more thing, how do you handle all the marc tags that
Here are some links you might want to look at.
Also, I would suggest you take a look at postgresql, it is a much
more industrial db, supports foreign key constraints, transactions. I
learned sql with mysql, but then I moved on to postgres.
I would like to help out with the project if I can.