Last 5 comments
31 years ago
Rafael:  Thank you very much, I was having a huge headache to solve the very same problem!
37 years ago
Ray:  Having the same problem. Very frustrating. Luckily, for some reason my released version worked on the iPad itself, but now I can't get it to run in the simulator. Getting no such table, which I'm guessing is an initialization error. Will continue to investigate.
38 years ago
Jeremy:  FYI, I've just tried it with the SQLite 3.7.0 preview and the same problem occurs.
Also, I'm not using any extra third-party libraries with my SQLite, so the problem isn't your Unicode extension.
38 years ago
Jeremy:  I'm having the same problem with compiling SQLite against iOS 4 for the iPad simulator, but in my case it works fine running on an actual iPad (also works in the iPhone simulator and on an iPod Touch).
Same problem with 3.6.23.1, 3.6.23, and at least back to 3.6.21. Compiling against iOS 3.2 makes it work, though that's not really an option for iPhone (as opposed to iPad) apps.
I have no idea what to do about it or how big a problem it really is...
38 years ago
Pascal:  The problem seems to have deep roots, however there is a solution, see the updated post. :)
The archive
March 2011  (1)
July 2010  (1)
July 2009  (1)
March 2009  (1)
July 2008  (3)
June 2008  (1)
May 2008  (3)
March 2008  (1)
July 2007  (1)
June 2007  (3)
May 2007  (1)
April 2007  (1)
July 2006  (2)
June 2006  (6)

MedCalc 1.0 for iPhone available

Sunday, December 7th 2008 - 13:47, 1 update Wednesday, December 10th 2008 - 10:17
medcalc.pngAnother software release just became reality - today Mathias Tschopp and I submitted MedCalc for iPhone to the iTunes store, it should be available for download within a week or two (hopefully).
0 comments

Fernsehen 2.0 is available today!

Monday, October 20th 2008 - 14:04
Icon.png I am very proud to finally announce the release of Fernsehen 2.0! It is a major rewrite of the popular 1.8 Version of our TV widget, get it for free now from the Widgetschmiede Website.

I'd like to thank TVStar for the opportunity to use their data as data source, this is a very generous gesture and we greatly appreciate this!

The new version sports an enhanced user interface with tons of improvements, is faster thanks to CoreData and has a much better channel management. When channel definitions change these changes will be offered to download right from the widget without the need to update the whole widget.
Also really improved is the detail view of a show, especially feature films. Try it yourself, I hope you like it!
2 comments

Use the additional 66 LaTeX colors

Wednesday, August 20th 2008 - 16:40
I didn't find a good LaTeX color reference while googling, so I made my own short color overview.

By default there are 6 colors available within LaTeX: red, green, blue, cyan, yellow and magenta (as well as the "non-colors" black and white).
By using the colors package, another 66 colors become available. You can then use these colors to colorize some pieces of text or - more practically - change the colors of the links generated by the hyperref package.
0 comments

Cocoa Framework For MySQL - Build MCPKit As Universal Binary

Monday, July 28th 2008 - 15:21
Using the MCPKit is one way to use MySQL from your Cocoa Application, and I decided to do just that. But there is that one problem since the project seems not to be all that alive - the compiled version is PPC only, no Universal Binary. Well, I thought, download the source and build the Framework on your own. I finally succeeded, but not without running into some troubles first.
6 comments

Eponyms on the iPhone/iPod touch

Saturday, July 19th 2008 - 12:57, 1 update Monday, August 4th 2008 - 11:04
WebIcon.pngIt's done, I just finished uploading my first iPhone application to the iTunes Store named Eponyms. It still is under review, but it's finally up there and scheduled for release July 20 (if it's accepdet by then). The app is an application to look up medical eponyms and is based on the eponym database created by Andrew J. Yee (www.eponyms.net/) featuring more than 1'600 eponyms. It's released under the Apache 2.0 License and therefore Open Source, you can checkout a working copy at the project site:

code.google.com/p/eponyms-touch/


I sell the app for 2 US Dollars but offer the same app as a free download for students. There will be no check if anyone indeed is a student, let's see how honest people are. :)

I hope you like it!

You can't download the app on your own because distributing iPhone applications is done exclusively through iTunes, here the links:
Eponyms Eponyms (for students)
4 comments

SQLite Bulk Insert on the iPhone

Tuesday, July 15th 2008 - 20:30, 1 update Monday, October 19th 2009 - 17:51
I'm currently working on an application for the iPhone/iPod touch and decided to use SQLite as storage for the data. The app will display medical eponyms and must fill the database on first launch and when new eponym data is available from an XML file. It parses the XML file and fills the SQLite database, which currently results in 27 entries to a categories table, 1'623 entries to the eponyms table and 3'281 entries to a linker table (4'931 entries in total). The whole database weighs only 394 KB.

Read the full article to see how I sped up the import process by a magnitude of more than 10.
2 comments

Doom The Movie - utter crap

Saturday, June 28th 2008 - 20:20
So, I decided to finally watch the Doom Movie. And since I really loved the games (Doom and Doom II) I expected the movie to be cool in some way. At least a bit. Turns out I was absolutely wrong.

I mean, in the beginning it's like in every stupid action movie, too dim narrow hallways, insane creatures coming from above or below, flashlights failing in the wrong moment; as usual. I can watch those movies. But about halfway through the movie, when the action is in full progress, soldiers are in groups of two searching the area, one dude seriously needs to - shit. He needs to shit! Holy crap! He abandons his colleague and goes to the toilet. Seriously, to the fucking toilet! Now how stupid is this?? I'm sorry, but this is just plain stupid and utter ridiculous.

I actually stopped watching the movie in the middle just to write this down. And it gets not a tiny bit better: Easily one of the worst movies ever. Don't bother watching.
1 comment

Official: iPhone comes to Switzerland through Swisscom

Wednesday, May 14th 2008 - 09:44, 1 update Thursday, May 29th 2008 - 11:17
A year later than everyone expected it's now official - Swisscom will launch the iPhone in Switzerland later this year.

This fits very well to the current rumors of a new iPhone being unveiled at the WWDC (World Wide Developers Conference), to be held from June 9th to June 13th in San Francisco, California.
0 comments

A Copyright Cop for every Zune

Thursday, May 8th 2008 - 10:33, 1 update Thursday, May 8th 2008 - 10:45
Oh well, that's almost hilarious. You might remember that last summer, NBC pulled its TV shows from the iTunes store after Apple denied them the rights of more flexible prices, bundling content and building harsher DRM into the iPods. Basically, NBC wanted Apple to become more evil and controlling its iTunes users further. It wanted iTunes to bundle popular shows with less popular shows so those would sell more. There's no other point behind bundling, is it?

Apple denied this (hey, there's still good in them!) and consecutively NBC pulled the shows from the iTunes store.

Since yesterday, those NBC shows are available from the Zune store (the Zune is Microsofts iPod counterpart). And guess what - with the upcoming software update to the Zune, there will be a Copyright Cop in every Zune. Mr. Perrette, NBCs president of digital distribution, said that they create “filtering technology that allows for playback of legitimately purchased content versus non-legitimately purchased content.” Great, now that is great! Thank you, Microsoft, thank you, NBC. For the sake of having those shows available and making money out of them, you're ready to fuck your customers once again. Great!
0 comments

iPhone SDK install fails

Wednesday, May 7th 2008 - 10:57, 1 update Thursday, May 29th 2008 - 11:14
I am really wondering: Today I installed the 5th beta (login required) of the iPhone SDK, so this was the fifth time I installed a beta of this SDK. And for the fifth time, I received the following error:

"The following install step failed: run preupgrade script for CHUD. Contact the software manufacturer for assistance."
iphone_sdk_install_error.png

I have no problem running the SDK, everything seems to run fine, but I wonder why googling for this error returns zero results. Not even a suggestion to search for something similiar, just zero results.

Does nobody else have this problem? Or am I violating some non-disclosure-agreement by posting this?

Edit: I filed a bug report, in case anyone wants to take a look at it, Bug ID is 5916392

Update: As of iPhone SDK beta 6 this issue seems to have been fixed, at least for me. Good.
0 comments

49'557

Thursday, March 6th 2008 - 11:09, 1 update Wednesday, May 7th 2008 - 11:00
Wow. Three weeks ago, I was stunned to see that my main Gmail account now receives slightly more than a thousand Spammails a day (~33'000 per month), but luckily only 1 to 2 make it to the inbox. Today, I checked again to see how many spammails I received in the last 30 days:

49'557


Great, thank you all who contributed.
1 comment

Honest Homeopaths

Wednesday, February 20th 2008 - 10:01
I don't really belief in the power of homeopathy myself, and to date there are approximately zero studies which were able to proof that homeopathy works better than simple placebo medications.

Now it looks like homeopaths themselves doubt the power of their medications: The FairDeal Homeopathy website states that homeopathy works through the placebo effect, that it requires belief in order to work and on the question to "What conditions can homeopathy treat?", they state that "treat" in no way implies "cure".

Good to see some honesty there. I can live with that. :)
0 comments

A History Of Evil

Tuesday, February 19th 2008 - 19:40
Just stumbled upon this on Sebastians Blog, worthy to share:
0 comments

HD-DVD is dead

Tuesday, February 19th 2008 - 09:47
That's it, folks, the HD format war is over, Toshiba today officially announced to bury HD-DVD. That makes Blu-Ray the de-facto standard for the rising HD movies market.
2 comments

MySQL speed for different SELECT approaches

Friday, January 11th 2008 - 10:16
While working on a script (in Perl), I discovered that MySQL performs very differently depending on the method used to retrieve a data row. What I need to do is walk through a set of 5000+ rows of a table with 110 columns. I have tried four different versions, and instead of elaborating and discussing, I will simply write down the method used and the execution time
1 comment

MacBook Pro keyboard response issue and Apple locking threads on their forums

Thursday, January third 2008 - 12:09, 1 update Wednesday, February 20th 2008 - 08:45
So Apple keeps shutting down consumers complaining on their forums. What a shame!

Update: After a second Firmware Update, this seems to finally be fixed!
0 comments