Tag Archives: mysql table

Recommended Mysql-table

MySQL DIY – How to Apply IP Geo-Location Using MySQL!

Here’s a great resource for IP geo-location, there’s a guy who’s made a MySQL table for it, so all you need to do is check the IP address against the database.  I have personally been thinking of making such a site and this is going to help me do that, awesome!  I hope it helps you too.

The IP addresses are listed in table ip_group_city. The data is not in the 1.1.1.1 format since it would need to be stored as text and we dont want that for obvious reasons. Let say for ip A.B.C.D, the formula is ip = (A*256

Click Here to Read Full Article

Leave a comment

Data Browser allows you to manipulate MySQL database in a Snap!

Here’s a desktop based data browser that allows you to manipulate MySQL database in a snap.  The most amazing part is how quickly you can bring in any RSS feeds from blogs/social network sites as a database table, almost as fast as my finger snapping.

Watch as David, the CTO of the company, explains how it works.

video://www.youtube.com/watch?v=LiQ9qksn5gc

As you can see in the video interview, Kirix Strata lets users view, organize, and manipulate data tables with desktop speeds and ease.

Although you could make a similar webapp, it wouldn’t perform as

Click Here to Read Full Article

Leave a comment