SQB-connect-sqlite

SQLite connection adapter for SQB.

Configuring

const sqlitedriver= require('sqb-connect-sqlite');
sqb.use(sqlitedriver);
 
const pool = sqb.pool({
  dialect: 'sqlite',
  database: 'dbfile.db',
  mode: sqlitedriver.OPEN_READONLY,
  busyTimeout: 30000
})

• database: Valid values are filenames, ":memory:" for an anonymous in-memory database and an empty string for an anonymous disk-based database. Anonymous databases are not persisted and when closing the database handle, their contents are lost.
• mode: (optional): One or more of OPEN_READONLY, OPEN_READWRITE and OPEN_CREATE. The default value is OPEN_READWRITE | OPEN_CREATE.
• busyTimeout: Provide an integer as a value. Sets the busy timeout

Compatibility

• node >= 6.x;
• sqb 3.x;

License

MIT