Last 5 comments
117 years ago
Rafael:  Thank you very much, I was having a huge headache to solve the very same problem!
123 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.
123 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.
123 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, 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...
124 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)

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.

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 ( 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:

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)

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.