An SQLite3 back-end module for RESTBase conforming to the RESTBase storage specification.
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.
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