waterline-sqlite3

Waterline SQLite3 Adapter

A Waterline adapter for SQLite3. Waterline is the ORM layer used by Sails and Treeline.

Features

• Fully compatible with SQLite3
• Supports Waterline Associations
• Uses knex.js for query building
• Written in ES6

Compatibility

• Waterline v0.10 and newer
• Works with Trails v1.0 and newer

Install

$ npm install waterline-sqlite3 --save

Configuration

config/connections.js

module.exports.connections = {
  sqlitedb: {
    /**
     * Database instance type. Specify whether to store the database on disk
     * or in memory.
     */
    adapter: 'waterline-sqlite3', // or 'memory'

    /**
     * Location of file if type='disk'
     */
    filename: './tmp/db.sqlite',

    /**
     * Set to true to output SQL queries
     */
    debug: false
  }
}

License

MIT

Maintained By