Most Web Framework SQLite Adapter


Keywords
web, mvc, most, most-web, framework, model, view, controller, data, sqlite, sqlite3
License
BSD-1-Clause
Install
npm install most-data-sqlite@0.1.16

Documentation

most-data-sqlite

MOST Web Framework SQLite Adapter

##Install

$ npm install most-data-sqlite

##Usage

Register SQLite adapter on app.json as follows:

"adapterTypes": [
    ...
      { "name":"SQLite Data Adapter", "invariantName": "sqlite", "type":"most-data-sqlite" }
    ...
    ],
adapters: [
    ...
    { 
        "name":"local-db", "invariantName":"sqlite", "default":true,
        "options": {
            database:"db/local.db"
        }
    }
    ...
]

}

If you are intended to use SQLite adapter as the default database adapter set the property "default" to true.

####Post Installation Note: SQLite Data Adapter comes with a regular expression extension for SQLite (regexp.c). You have to compile this extension as follows:

#####Using GCC/MinGW on Windows and Linux gcc -shared -fPIC -Isqlite3 -o regexp.0.dylib regexp.c

#####Using GCC on Mac OSX gcc -dynamiclib -fPIC -Isqlite3 -o regexp.0.dylib regexp.c

#####Microsoft Tools on Windows cl /Gd regexp.c /I sqlite3 /DDLL /LD /link /export:sqlite3_extension_init /out:regexp.0.dylib