Menu
have anyone used this before, i need free country, city, IP database for sqlserver
276
Most cloud providers such as Amazon and Google offer limited free SQL engines for the open DBMSs such as MySQL and PostgreSQL. From Amazon, you can use Amazon SimpleDB with a free tier for 12 months or you can also use Amazon RDS Free Tier. Google also offers Google Cloud SQL for both MySQL and PostgreSQL.
SQL Server 2019 Express is a free edition of SQL Server, ideal for development and production for desktop, web, and small server applications.
There are 4079 cities in the table. We use the built-in COUNT() function to find out the number of rows.
DBeaver. DBeaver is a free and open-source option for an SQL editor. DBeaver is an open-source database management tool, which has a pretty neat SQL editor. It is free, cross-platforms, and also provides an Eclipse plugin if you use the Eclipse IDE for development.
I have used http://www.maxmind.com/app/geolitecity . It is a less exact version of their paid database. The free database claims to be "over 99.5% on a country level and 79% on a city level for the US within a 25 mile radius". You can see their accuracy detailed at http://www.maxmind.com/app/geolite_city_accuracy.
The data is presented as a CSV file containing the starting IP block, ending IP block, and the location. It is easy enough to load into sqlserver.
APIs in C, C#, PHP, Java, Perl and the free version, GeoLite, has an IPv6 version in addition to the downloadable CSV Format.
194
ipinfodb provide free geolocation data for MySQL. With a simple database translator, you can put it into different database, since the table structure is simple. They also provide data in CSV format, that will be easier to imported to different database engine.
The data is based on free version of MaxMind, and it's updated every month. They also provide free API, if you don't want to store the data in your server. The accuracy is decent and enough for normal website usage.
25
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
