How to use sqlite .dot commands within Enyo?

edited September 2012 in Enyo 1.0
I am thinking of using Sqlite .commands on my sqlite database app, but do not know how to. Basically an onclick function to implement the .command.

for example a .import to import into my database. Any example or pointers appreciated.

Comments

  • Someone else with more information may correct me, but I don't think you can do that unless you've got something like a service acting as a middle-man that can drive the SQLite interactive shell.

    And then that service would be responsible for issuing the command and returning the data to your JavaScript.
  • Yeah, WebSQL (the access to SQLite in WebKit) doesn't support dot commands. Things may be different for PhoneGap apps using SQLite as an external plugin.
  • Thanks sugardave and unwiredben. for your responses.

    Basically I was trying to find a way of importing and/or exporting into my pure Sqlite database.

    I seem not to be able to locate my database on the internal media drive like I can for the other apps i.e the ones like 0000000000xx.db for copying to backup. My app also does not appear among the lists in the .app-storage.

    Could this be because I have not submitted the my app? and just developing on my PC?.

    Is there an alternative way of backing up/restoring my pure Sqlite database in enyo?

    help or pointers as usual very much appreciated.
  • This looks more like a webOS question than an Enyo question... you should use the webOS development forums for this.
  • Thanks unwiredben. Shall try and post over there , probably in enyo programming section of webos development forum.
  • Well, this isn't a Enyo question, it's a basic WebKit question -- Enyo doesn't have database code, you're directly calling methods that are implemented by the browser.

    However, I can give you a hint... if anyone responds over there, they won't have a good import solution. It's a question that's been asked on webOS over and over, and the best answers are just versions of "do a lot of transactions at once and figure out a data format that's parsed efficiently".
  • Thanks unwiredben for your feedback and hint. Much appreciated.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!