YoJimbo - Free Viewer for the Web?

Discussion in 'Mac Programming' started by daze, Jan 13, 2008.

  1. daze macrumors 6502

    daze

    Joined:
    Mar 11, 2006
    Location:
    San Jose, California
    #1
    Hi guys,

    I am thinking about decoding the YoJimbo database schema as best as I can. My objective is to make a free PHP/SQLITE product/tool that can be used to display your various stored items in YoJimbo. I am aware of a similar program that looks very nice, although it requires you to pay for it.

    My objective is simple, and not very fancy. Of course, YoJimbo can always update their database, rendering any viewer unusable. Anyhow, I thought I'd see if there was an interest in the community in having something like this?

    Thanks,

    Daze
     
  2. plumbingandtech macrumors 68000

    Joined:
    Jun 20, 2007
    #2
    Honestly, if I were a hard core yojimbo user, and I wanted to post stuff to the web, I would buy that app you spoke of:

    http://www.versiontracker.com/dyn/moreinfo/macosx/32891

    It's $29 bucks. And yah. It is paid for, I don't mind at all seeing as how this greatly increases the chances that when as you say, barebones makes a change to the db, that the developer will be around and fix it.

    Unlike someone doing an open source version that will get posted once to sourceforge and prob. forgotten after the first major yojimbo update since they did not bother to charge and may not want to invest any more time in it leaving me up the creek without a paddle.
     
  3. hhas macrumors regular

    Joined:
    Oct 15, 2007
    #3
    Yojimbo provides an official scripting interface, so if you really want to create your own solution from scratch, I'd suggest using that rather than trying to hack its database directly. e.g. Here's a project that uses Ruby on Rails and rb-appscript to access OmniFocus via web UI:

    http://rubyforge.org/projects/omnifocus-ui/

    One problem if you're using PHP is that there isn't a good Apple event bridge for it (PHP seems to be actively hostile to third-party C extensions these days), so unless you'd prefer to use Python or Ruby I suspect you're probably stuck with running AppleScript snippets via shell calls to 'osascript' (crude, slow), or perhaps using something like Telekinesis which I think provides slightly better AppleScript integration:

    http://code.google.com/p/telekinesis/

    HTH
     
  4. daze thread starter macrumors 6502

    daze

    Joined:
    Mar 11, 2006
    Location:
    San Jose, California
    #4
    That does help, thanks for taking the time to post. I suppose, I'll try to decode the database anyway, and use it for my own personal purposes. If someone has a use for it, they are welcome to download, use, and extend it. After all, that's the purpose of free open source software.
     
  5. SC68Cal macrumors 68000

    Joined:
    Feb 23, 2006
    #5
    Yojimbo uses SQLite, with the path ~/Library/Application Support/Yojimbo/

    Code:
    sqlite3 <path_to_database_file>
    
    The command ".schema" will dump the DDL.
     

Share This Page