Natty Precise Maverick

    restbase-mod-table-sqlite

    1.2.1 • Public • Published

    restbase-mod-table-sqlite Build Status

    An SQLite3 back-end module for RESTBase conforming to the RESTBase storage specification.

    Installation

    Firstly, install RESTBase. The SQLite back-end module should be pulled in automatically as a dependency. If you cannot find restbase-mod-table-sqlite in RESTBase's node_modules/ directory, install it using:

    npm install restbase-mod-table-sqlite
    

    Note: in order to successfully install the module, you are going to need the SQLite3 development headers.

    Configuration

    RESTBase comes pre-configured to use Cassandra as its back-end storage. In order to select SQLite, RESTBase's table module in the configuration file needs to be instructed to use this module; simply replace restbase-mod-table-cassandra with restbase-mod-table-sqlite. The table that follows lists the configuration options accepted by this module.

    Option Default Description
    dbname restbase The path to the database file
    pool_idle_timeout 10000 The amount of milliseconds a connection to the database is kept open during idle periods
    retry_delay 100 The amount of time (in ms) to wait before retrying queries when the database is locked
    retry_limit 5 The maximum number of times a query is retried
    show_sql false Whether to log queries being executed; for debugging purposes only

    All of the configuration directives are optional. Here's an example of the table module using the SQLite back-end module:

    /{module:table}:
      x-modules:
        name: restbase-mod-table-sqlite
          version: 1.0.0
          type: npm
          options:
            conf:
              dbname: /var/lib/restbase/db.sqlite3
              pool_idle_timeout: 20000
              retry_delay: 250
              retry_limit: 10
              show_sql: false

    Install

    npm i restbase-mod-table-sqlite

    DownloadsWeekly Downloads

    28

    Version

    1.2.1

    License

    Apache-2.0

    Unpacked Size

    56.2 kB

    Total Files

    13

    Last publish

    Collaborators

    • doorman
    • eevans
    • gwicke
    • pchelolo