AniDB

My typical problem is this: - I have unwatched episodes in few animes - I want to watch something - Preferably something good Therefore, the filtering answers first problem (eliminates watched animes), but sorting mylist entries also would make the selection tad bit easier.. and it's frustrating tha...

It is tedious to first check which episodes I've seen and THEN locate them using the known files (as it lacks search) - as it is, it's faster to use Windows file search to look for the episode. (some 300G-ish of assorted anime on DVDs and 4 different HDs - ironically enough I have original DVDs for ...

My copy has also started to repeatedly contact anidb every 2 minutes and not doing anything useful. I don't know why, it worked well enough week ago or so. Log snippet: [13.2.2004 22:16:22] - Trying to connect to AniDB... [13.2.2004 22:16:23] - Connected to AniDB. [13.2.2004 22:16:23] - Executing ne...

if one could use files' location in filesystem as indicator of watched/unwatched status. Like, using some arbitrary sample SQL schema as example, statement like this would be available: update anidb_mylist set col_Viewed=1 where col_id in (select am.col_id from anidb_file af,anidb_mylist am,local_ha...

Actually, following function call sequences are identical:

sqlitepager_set_safety_level(p, 1);
sqlitepager_set_cachesize(p, 123);


versus

sqlitepager_set_cachesize(p, -123);

(Benefit from using set_safety_level is that you can use whatever cachesize it was using in the first place ;->)

-F

Have you experimented with EXPLAIN to see if it really uses indexes in those joins? It's not an issue anymore, AOM now only uses very simple queries. I'll try it out in some queries that run abnormally slow though. At least in my experience SQLite is one of faster free SQL databases when used corre...

Beg for AoM to get more features+speed (especially speed being possibly difficult if there are architectural issues Yeah, the reason AOM is slow is because of sqlite, it's horribly slow for anything beyond the most basic... :( I'm currently looking at solutions to completelly replace sqlite, the fa...

No SDK is provided, only an API specification (html). And there are LOTS of requirements in that API spec and a client can do quite some harm to the server by not following the specs closely. (i.e. server load/availability, bulk creqs, bulk adds, spamming, ...) I'd guess you could just have the ser...

Ok, I'll bite on the cons to provoke discussion: - If you provide SDK that uses the API, the existing clients themselves are also erroneous if they can cause harm to database using it (and if it's just due to users using clients wrongly, then it can be also done with current clients). As long as the...

Ironically enough, I'm feeling slightly tempted to make anidb clone because the API is NOT public. Luckily I'm too lazy :) Reason? I can get the actual database in various ways. That is not a problem[1]. But I CANNOT choose client to use and at least currently the AOM is promising albeit about 10x s...