Current Database Structure

Development discussion about the hostip.info codebase, libraries, and database

Moderator: Moderators

Current Database Structure

Postby jmbell on Sun Mar 26, 2006 6:58 pm

I recently downloaded the entire hostip database for use in a mapping scenario. The project calls for the querying of hundreds of addresses at a time and that's why I opted for the local database.

I was surprised to find that each class A is given its own table. Why is that? Why isn't there simply an ip4 table with all the entries in that table? Clarification on this would be appreciated.
jmbell
n00b
 
Posts: 1
Joined: Sun Mar 26, 2006 6:54 pm

Postby Mister on Mon Mar 27, 2006 3:52 am

I suggest you use rsync:

What this means: run the command below and keep the files around and just sync them for updates instead of deleting them all after each run...
rsync -avz --progress rsync://hostip.info/hostip ./


If your on windows can you use my little pack...
http://www.hostip.info/contrib/index.html
direct link
http://www.hostip.info/contrib/rsync_au ... script.rar

The new database is in there and is more effective (on the rsync server)
<?
echo "Creating GE-GEOIP";
echo "Using hostip.info db :-)";
?>
Mister
n00b
 
Posts: 14
Joined: Sun Mar 19, 2006 2:40 pm
Location: SE


Return to Hostip.info code/database devel

Who is online

Users browsing this forum: No registered users and 4 guests

cron