blog.V1ru8.net

As to the fact that iPhone OS 3.0 supports now notes synchronization itself. I removed iPhoneNotes from my homepage and from MacUpdate.
bye bye iPhoneNotes
If you still want iPhoneNotes you can download it here: iPhoneNotes 0.8

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!

Since apple is building and updating the iPhone software they’ve forgotten to deal with the Notes on your iPhone. They’ve just backed up them and thats not enough for me. So today I release an application to manage the iPhone Notes on your Mac.
Currently implemented features:

• Download notes from your iPhone
• View the notes
• Edit (change,add and remove)
• Save them back to your iPhone

All that is currently just possible with a jailbroken iphone and installed OpneSSH over WiFi. But I’m trying to support a cable based notes transfer which should work with every iPhone.

Known issues:

• Works just with 1.1.3 or higher
• Only over WiFi with a jailbroken iPhone
• Sometimes nothing sows up. Just try to download the notes again and have a look at the log window

Download here: iPhoneNotes 0.1.1

This software is totally free and comes with absolutely no warranty

Update:
Version 0.1.1 added with fixed resizing problem.