Category > Tech

How to build an efficient GeoIP SQL table

This here is a very handy little script I threw together to generate a geoip.sql table for quickly determining which country a IP is from. I already hear you saying “Just convert the IP to an INT and use BETWEEN, how hard can it be”. And you are right, that works. And it may even [...]

Continue reading

, ,

win7 system restore … aaarrrrgggh

Warning: this is mainly me just ranting about Microsoft stupidity and a warning for anyone using junctions.
About a month or two ago I built myself a new PC (old one was dying) and installed Win7 on it.  Since I was previously still on WinXP there were a few things to get used to, but all [...]

Continue reading

, , ,

How to add file versions/history to iFolder

I’ve been using iFolder for about a month now and am pretty satisfied with the performance and features, but there is one feature I dearly miss: having access to older versions of a file.  To work around this problem I simply created a SVN repository for every iFolder user.  This allows the users to “check in” [...]

Continue reading

, , ,

How to install ruby 1.9.2 on Ubuntu 10.04

The current LTS version of Ubuntu is 10.04 and the most current version of ruby it ships with is 1.9.1. Unfurtunately 1.9.1 wasn’t that great of a release and anyone using the 1.9 branch really should use the stable 1.9.2.
After doing a bit of researching I found some information on how the best approach to [...]

Continue reading

, , , ,

Using iFolder as an open source Dropbox alternative

I’ve had a few posting here in my blog over the years about trying to keep data synced over various computers. Nowadays it has gotten easier since it seems everyone is chruning out their own online storage. Classics like Dropbox or SugarSync, and then we have the big companies  Google, Microsoft and Ubuntu trying their [...]

Continue reading

, , , ,

prev posts