Anime Characters Database Logo News

Removing all Subdomains Oct 28, 2011 | Rei
Ah the down sides of using a wild card for your domain....

Google and Bing have been amounting to a constant DDoS Attack indexing a near infinity of subdomains.

Everything from

jp.animecharactersdatabase.com to ipod.animecharactersdatabase.com to silly ones like http.wwww.animecharactersdatabase.com ...

As of now, all of these will redirect to www.animecharactersdatabase.com

Some other domains are available, such as:


Domains with special effects:


Creating a READ ONLY Database Sep 27, 2011 | Rei
Possibly the biggest challenge for me right now is creating a practical read only database to run along side of the main database.

Master/Slave replication is ruled out.

Thus far, I know how to compile, install, configure, run, and initialize a read only database that would run along side the master.

The problems that keep this from being practical branch alone two paths.

1. staying in sync

once i make the full backup of the master, that's it. from that moment in time onward, the RODB will be out of sync

solutions involve manually creating binary log files with FLUSH MASTER LOGS and replaying those all part of a cron script at some hour

2. CREATE TABLE and ALTER TABLE commands break software

i suppose if i were to do an ALTER TABLE, i would have to immediately apply it to the RODB if the statement would break SELECT queries

any CREATE TABLE statements for new features would be completely broken on the RODB. these statements would need to be applied to the RODB prior to committing the software updates

it's been a long time analyzing why some SELECT queries end up getting slowed down an average of 6 to 8 seconds.

answer is, UPDATEs and INSERTs on the character table can LOCK SELECTs for roughly that amount of time.

i'm also looking at making use of HASH indexes where they would be ultimately superior to binary trees

of course, all of this discussion involves playing by the rules of MySQL. as i write my own replace for MySQLD, i write my own rules.
news time! Sep 22, 2011 | Rei
This week's been focused a bit on fighting back against spammers.

Admin's Level 5 and higher can and will now ban every account posting spam.

I launched an issue tracker early this week. All members are welcome to use it to report site bugs, and request new features. This is mainly for my benefit. Having everyone contact me directly with their ideas was getting a bit overwhelming. I was spending more time considering ideas than actually doing them. The issue tracker isn't finished yet either. It's not easy writing a thousand line application in one shot... I'll take some time, then finish it off.

Also bought back the rating feature. Every load bring up a random character you can assign 1 to 10 points to.

We'll compile the data and make some use of it later on.

I've been clearing out ACDBv1 content pretty fast since yesterday. Frankly, I view it all as security vulnerabilities. My coding skills from 2007 to 2009 just wern't anywhere near as awesome as they are now.

Even rewriting rate.php, I found countless blocks of code I was able to easily replace with a single line of code.

Goals for now look like:

1) push out new content
2) fix existing content
3) expand existing content

or read another way ...

1) create
2) repair
3) expand

30848 character, wow. Getting close to 31,000 already. AND next season of anime is rolling out soon. Hope to have the seasons editor tool online for that event.

Please know that cookies are required to operate and enhance our services as well as for advertising purposes. We value your privacy. If you are not comfortable with us using this information, please review your settings before continuing your visit. [close]

Anime Characters Database Logo Who's This Character Board | New Thread

04:29 am
Who is this ?
02:01 am
Who is this ?
Yesterday 11:58 pm
Who is this ?

New Thread

All images are copyright of their respective owners.
Rendered in 10.3 ms. R-8-W-0-M-2178.77 KB Modified: Mon, 11 Nov 2019 14:39:59 -0500 Copyright © 2007-2020 Goral Software