Archive for category visual77
MySQL dump of every country and state in the world
As part of a recent project, I needed to compile a list of every country and first level administrative subdivision in the world. I started with the ISO 3166-2 list, but later cleaned up certain countries that had inaccurate data. I also needed timezones for every state, so I put all of those in as well.
This zip file contains a single SQL dump for two tables – region and subregion.
Region contains 248 entries, with the following data for each country: ISO code, 3 digit ISO code, fips code, country name, continent, currency code, currency name, phone prefix, postal code regex, languages and geonameid. Subregions contains region ID, name and timezone. The timezone format is “America/Los_Angeles”, “Europe/Madrid”, etc. Unfortunately, some states have multiple timezones and this is not taken into account.
There might still be some issues with some countries not having an accurate state list, but this list is more comprehensive than anything I was able to find online.
Download the list: region.sql
Upcoming Work
It’s now been over a month since I’ve written any articles. I’ve been busy lately with a number of activities, plus my regular job, and just haven’t had time to write much. I do have a few article ideas that I’ll be doing shortly, though, so this site isn’t quite dead yet.
I’ll be writing an article on best practices for creating new classes in PHP and ideal naming conventions for functions and variables. In both situations, I have the bulk of the writing already completed and just need to polish it up and get it into a blog article.
What makes a user want to buy digital content?
Posted by visual77 in gaming, programming, visual77 on January 21st, 2010
As you can learn from a cursory glance at this site, I am a professional computer programmer. I also have side projects that I would like to one day monetize. One such side project is my planned Android app remind@home. On the other hand, I am a content consumer in the digital age, using the internet to acquire new content, sometimes in ways the content creator might not find appealing. Sometimes I pay for content (such as my recent Steam purchase of Dragon Age: Origins) and sometimes I do not pay for content (such as all apps I’ve installed on my Droid, except my podcast app BeyondPod).
Do I acquire content for free because I am cheap? Absolutely not. I buy when the content creator has provided sufficient incentives to buying. As a content creator, I strive to understand those reasons, both within myself and within others. For this reason, I have begun asking friends what a content creator can do to encourage a purchase. I am not concerned with preventing unauthorized downloads or free software that is asking for donations. I am only concerned with finding out what a content creator can do to encourage users to pay for their content. After my discussions with other techies, here are some of the ways a content creator can encourage users to pay:
Release a sample
Release a free sample that can be easily upgraded to the full version. This allows me to find out if I like your content before I commit money. iTunes and Amazon MP3 Store are examples of this from a music perspective, and game demos accomplish the same thing for game developers. If I am unsure of the quality of your product, I am unlikely to blindly commit money. Through Amazon MP3, I can sample every song on an album before I decide to buy. If you do not provide an easy to locate sample, I will still find a free way to sample the content. The alternative is an unauthorized acquisition of your content, and in that scenario I am unlikely to pay if I like the content. After all, why pay for what I already have? By placing barriers to sampling, you aren’t hindering my ability to sample, you are just putting yourself in a bad place if I like what I’ve sampled.
For PC game developers, this is even more critical. Unlike console games, PC games are not always playable on every PC. A demo not only lets me find out if I like the game, but it lets me find out if I can even run the game. There is nothing worse than paying $50 to find out my video card can’t handle your game. Just like in the music sampling example above, instead I can just acquire the game through other channels. If it doesn’t work, I still have my $50. If it does work, where does that leave you?
Continuously update your content
This rule applies more to software than any other form of content, but it is an important rule nonetheless. If I purchase software that is constantly updated, and only authorized copies can be updated directly from the developer, I have an incentive to pay. Fear not, all of the updates will be leaked through unauthorized channels, but the convenience of a built in updater cannot be understated. Imagine downloading a program to manage a database of clients and receiving a weekly update with bug fixes and occasional new features. These updates can come through two channels – an authorized update system that came with the purchase of the software, or a weekly hunt through P2P networks for the newest version. The convenience of a built in updater is easily worth the $50, assuming the updates are worthwhile. Releasing your software and then abandoning it gives me no incentive to purchase a copy. That just guarantees that the version available on a P2P network is the same as a legitimate copy, permanently.
Be easy to acquire
I’ve purchased over a dozen games from Steam simply because it is easy to pay for and acquire my game. The user interface for acquiring your content needs to be easy to use. If I am having trouble locating your content digitally through authorized channels, I’ll simply start looking through unauthorized channels. Make it easy enough that I never consider looking for alternate methods to get your content. Sometimes the issue isn’t how much your content costs, but how much of a hassle it is to locate and acquire.
As a content provider, make use of services like Amazon MP3 store, Audible and Steam. You don’t have to create your own system of distribution, but use a reliable distribution system. Users want convenience above all else when it comes to acquiring new content. The more convenient your distribution system is, the less likely a person is to seek alternate methods. There will always be those that simply don’t want to pay. There is almost nothing you can do about that crowd. Instead, focus on the crowd that is willing to pay. Find out what barriers are in their way and remove those barriers.
Offer your content digitally
This should go without saying. If you want people to pay you for your digital content, then offer that digital content. Rather than offer an explanation, I will just provide one of the conversations I had about this subject:
Steve: How often do you acquire unauthorized digital content?
Anonymous: Maybe twice a month, it really depends if theres an HBO or Showtime show I want to watch.
Steve: What could a content creator do to encourage you to buy?
Anonymous: Offer a place to buy it online. Just make it possible. Do it the day after not months later. I mean, I pay to torrent now, since I use usegroups. It’s access thats the issue, not price.
Steve: So the only reason HBO and Showtime aren’t getting your money is because they aren’t giving you a way to give it to them? Someone is getting the money, and if HBO or Showtime set up a good system, they’d have it. But, they are making it impossible for you to get, through them, what you can certainly get elsewhere.
Anonymous: Yeah.
This week on twitter – 2010-01-17
- Brewing my stout again today. Try number three. #
- I like the new WoW armory. The model viewer and activity feed are both really cool. I think I'll add my char's activity feed onto my site. #
- Khourys, my beer store, just got more awesome. They were playing The Decemberists on the speakers. #
- I had been hearing reports of an earthquake in Haiti all day, but I just now read an article on it. I had no idea it was this bad… #
- I've been having a number of blue screen problems lately… If this persists, I might go get Windows 7. #
- I just bought Speaker for the Dead #
Powered by Twitter Tools
This week on twitter – 2010-01-10
- By the way, that last comment about car stereos was not about my car. I heard a car last night where the bass sounded like a clutch grinding #
- When your car stereo can be mistaken for engine trouble, turn it down or upgrade it. #
Powered by Twitter Tools
This week on twitter – 2010-01-03
- I've got a few Google voice invites if anyone wants one. #
Powered by Twitter Tools
This week on twitter – 2009-12-27
- I got my verizon rebate in today. All went well, which is pretty unusual for a rebate. #
- For the first time, I hit endgame in an MMO. My shaman is now 80. #
- Good to see that Wells Fargo improved their mobile site to make it usable on the Droid. #
- I miss sleep. I think it has been about 2 weeks since I slept more than 3 hours a night. I just lay there now. #
- I hate Death Knights. 99% of them are completely incompetent. The kind of people drawn to that class have no idea how to do their job. #
Powered by Twitter Tools
The Netflix prize – Someone won $1m for this suggestion?
After ignoring this section of Netflix for a bit too long, I finally gave the suggestion system a try. I entered movie suggestions for 15 or so minutes (skipping a lot of movies that I never saw or hadn’t seen recently enough to accurately judge), and this is my result:
Have you ever wondered what you get when you mix David Attenborough’s fantastic biopic of Gandhi with Larry David’s awkwardly hilarious Curb Your Enthusiasm (season 3, in particular)? I know I haven’t. Netflix has the answer! The answer is Life in the Undergrowth, a documentary by David Attenborough and the life and habits of invertebrates.
Thanks Netflix!
This week on twitter – 2009-12-20
- I've been seeing a lot of American Apparel ads lately. I may not be the most fashionable out there, but holy shit is that horrible fashion. #
- After a few days away from the problem that was hurting my soul for 2 weeks, I'm back on it. Hopefully I can finish this thing soon. #
- I got an email from Verizon about my $100 Droid rebate. Looks like all is well and they should be sending me the rebate soon. #
Powered by Twitter Tools
Congratulatons Google Reader! You are the one app that is better on my phone than the computer!
I really need to find a new RSS reader. Google Reader, for all it’s strengths, is really starting to annoy me. I have 352 unread items with no manageable way to filter that list down. If I choose expanded view, they automatically mark as read upon scrolling past (good), but sometimes I have to scroll past 20 pages of images (mostly game screens, bad). If I choose list view, I can see just titles (good) but anytime I scroll down, more items pop up (bad). I cannot find a way to just view 30 or so item titles, and then click mark all as read and view the next 30… except on my Droid.
This is the one website that is more usable on my phone than on the site. All I want is an easy way to chew through these 352 items. Let me mark a chunk as read by title alone. Don’t force me to change my RSS reader over this.
If anyone knows a way to stop the list view from auto loading items on the bottom, I will kill one person of your choosing. Deal?
