AniDB

Nah, MySQL's lack of transaction support doesn't break the tables themselves. The worst thing that could happen is that a foreign key becomes meaningless (i.e. an entry for a file is deleted but the references to that file aren't removed from everyone's mylists). However, that is a problem that can ...

Forgive my nosiness, but what database do you have running in the backend? Thinking about some of the tables, the number of rows and the sizes of the table indexes gave me a real headache, and I'm wondering if MySQL or Postgres can still handle that or if something big (read: expensive) is required...