Speeding up SQLite insert operations

November 8th, 2011

We’ve started a blog at work where we will be writing about all kinds of technology we use at VG.no and its network of services. I will try to be a little more active with my blogging from now on and will make sure to post a link to any interesting articles both on this blog and on twitter.

I wrote up a blog post there about how to speed up SQLite insert operations.
Check it out over at VG Tech.

MorseMyIp.com is online

April 13th, 2011

Last night I read up on morse code and wanted to use what I learned to do something fun.

I decided to create a “What is my IP-address” service (I know, there are plenty) and have it give you the IP in morse code as well as in plain text, here’s the result.

It took a little longer than I thought it would to create a wav-file through PHP with all the dits and dahs, wav-headers and whatnot – but I got there in the end.
Didn’t expect it to be so hard to get it to play on a website either; I am now using three layers:

  • HTML5 audio for browsers that support it
  • <bgsound> for IE5, 6, 7
  • Flash, for others

Unfortunately, I have not managed to get it to play on my Android phone yet – I hear Gingerbread has support for HTML5 audio though.

Not at all satisfied with the look of the site, I just threw something together in a hurry – so it will be prettier at some point. Have a look at http://morsemyip.com/ :-)

Getting the Samsung Galaxy S to work on Linux

March 14th, 2011

I was developing a quick prototype for an Android application today, and was having some trouble getting my Samsung Galaxy S working on Linux. Running “adb devices” only revealed it as “????????” – so I was not able to launch my application on the device.

The fix was pretty simple, and would be easy to find if you’re smart enough to poke around the documentation a little – but I ended up Googling for it, so maybe someone else will do the same. Here’s how I made it work on Ubuntu 10.10:

  • Create a file /etc/udev/rules.d/51-android.rules as root.
  • Open up your favourite editor and put the following line in the file:
    SUBSYSTEM=="usb", SYSFS{idVendor}=="04e8", MODE="0666"
  • Make it executable: chmod a+r /etc/udev/rules.d/51-android.rules

That’s all it took. The above should work for all Samsung devices, the Android documentation has a reference to other vendor IDs that you might use if you don’t have a Samsung device.