Since I’m developing the iPhoneNotes application i worked alot with the iPhone Notes database. This database is the data-source for my app. But it has a terrible layout:
CREATE TABLE Note (creation_date INTEGER, title TEXT, summary TEXT)
CREATE TABLE note_bodies (note_id INTEGER, data, UNIQUE(note_id))
- column
note_id is assigned to the rowid from the Note table (don’t like that but it works)
- In the Note database is the
title of the note stored. And in the summary column is the content of the note store if it isn’t too big (absolutely don’t understand why?!?!)
- the
data column from the note_bodies database contains the content of the note always. But in a really strange pseudo HTML format. Every line is in a div element and sometimes it has a br element at the end of the line. The problem is that these div tags are not every time closed correct. So it is impossible to parse it with an XML parser.(I hate things like that)
- Because the content of the note is stored twice it has a terrible data redundancy! I don’t understand why that is needed.
So Apple please update the notes application in version 2.0. The actual note’s db is not how things should be done!
V1ru8 on March 21st 2008 in iPhone
Last week Apple introduced the new MacBook Air the world’s thinnest notebook. The world’s thinnest means 4 mm in the front to 19 mm in the back. I think thats just awesome! That’s so thin it’s unimaginable. But this size has its costs. The MacBook Air has no FireWire (400 nor 800), no Ethernet and no Audio-In. It has just one USB 2.0 Port, a micro-DVI Port and a headphone jacket. Now how can you connect it to the internet? The product name told it already. You connect it over the Air with 802.11n.
Based on the size it hasn’t a CD/DVD-ROM drive built in. You can just plug in (on that single USB port you have) an external one. I think thats a good solution in combination with that “Remote Disc” feature. Because last time I used the CD/DVD-ROM drive of my MacBook Pro was when i installed Mac OS 10.5.
Finally the price: The standard Core 2 Duo 1.6 GHz model with 80GB 1.8″ HDD and 2GB RAM costs $1799. The 1.8GHz C2D costs $300 extra. For a SSD you will pay $999 extra. That makes it a really expensive notebook.
Conclusion
If you have the money for it and it’s not your only computer its a glorious ultra portable mac!
Rating: 








(-1 for the price and -1 for the missing ports)
Now watch the ad below or have a look at apple’s homepage
V1ru8 on January 21st 2008 in Stuff
Today I can release a new version of vCardExporter with a few bug-fixes.
- Re-import into Address Book works now (no “No importable cards were found.” message will appear)
- New application icon added
- Window title and opacity adjusted
I hope this version will do it’s job better then the old.
Download: vCardExporter 1.1
Application description
V1ru8 on January 13th 2008 in Stuff
After I got some problems with anySIM during the update from 1.1.1 to 1.1.2 (be sure to be in airplane mode during unlocking with anySIM and installing iWorld from the Installer to get SMS and Phone working) it is now finally working.
The main fixes for me in this version are:
- Localized - keyboards and auto correction*
- Receiving SMS’s from the mailbox
- EDGE settings are now stored properly*
- TIFF exploit fixed (now I’m sleeping better) *
However that’s all it’s not really more. Or have I forgotten something? I don’t think so. In the daily usage it’s not a big change, maybe it is a bit faster and more stable but that’s all.The problems I get during the update (missed up that airplane mode thing) were it not worth. So I would not do it again!
* workaround for 1.1.1 is also available
V1ru8 on January 3rd 2008 in iPhone
V1ru8 on January 3rd 2008 in Regards
Last autumn I was sad about the Apple Address Book’s vCard export function. If you d’ like to export more then one vCard, Address Book puts them all together in one file. But i d’ like to have them in separate files. So I took a bit of time and wrote this tiny application.
vCard Exporter
V1ru8 on January 3rd 2008 in Stuff