This is the real deal now.

Since user agent lookup is non critical, I moved it to a console command to be run asynchronously in the background.

I also created an apache2 access log importer to kickstart the database.