October 8, 2009

StepSqlite and the iPhone

Posted in iPhone development tagged , , , at 10:20 pm by tetontech

StepSqlite is a service provided my Metatranz, LLC.  It claims to be a compiler for PL/SQL code that you can compile to run against SQLite.  This compiled code is supposed to be able to run on an iPhone or linux with other platforms upcoming.

The way it works is that you submit your PL/SQL code via a browser to be compiled.  The compilation happens and then you are presented with links to download the C++ header file and a .so library file.

This sounds great but I have concerns.  I state these with the belief that those involved with the project are honest and upright people and that metatranz is an honorable company.  Never the less, there are a few things that might keep me from using the service if I were responsible for security at a bank or some other institution that would be tracking secure data.

  • How can I prove, for security requirements purposes not because I think that this service is malicious, that the code that was sent in is the code that is executing without added backdoors, viruses, outbound socket connections, etc?
  • How do I know that the code is compiled to run efficiently?

Given these concerns, it would be great if metatranz open sourced their compiler code under the BSD or other appropriate license so that it could be evaluated.  Also, that would allow for someone to verify the security of the .so produced without decompiling it.

I think PL/SQL on the iPhone would be great.

Advertisements

1 Comment »

  1. Jeff K said,

    Hi,

    Metatranz now lets you send files to your GMail account for a free Virus Scan by Google. The announcement is on their website.

    As for performance, I had similar concerns and so I contacted them using the feedback link on their website. The support guy responded with following thread showing impressive performance of StepSqlite:
    http://www.mail-archive.com/sqlite-users@sqlite.org/msg47077.html
    Also this from their website,
    http://www.metatranz.com/stepsqlite/benefits.html#b4

    I converted some big PL/SQL code using stepsqlite in minutes. Had to change code to fit its syntax but nothing major and have to admit, it saved a lot of time for me.
    -Jeff


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: