knex-alasql

An AlaSQL client for knex.js

Works only with knex.js >=0.11.4

Install

npm install knex-alasql

Usage

var knex = require('knex');
var client = require('knex-alasql');
 
var knexClient = knex({
 
    client: client,
 
    // Optional properties with default values
    name: 'knex_database',
    version: '1.0',
    displayName: 'knex_database', // inherited from 'name'
    estimatedSize: 5 * 1024 * 1024, // 5MB
 
    // AlaSQL specific options https://github.com/agershun/alasql/wiki/AlaSQL%20Options
    options: {
        mysql: true
    }
});

TODO

• !!! Tests !!!
• !!! Known issues !!!
• !!! ESLINT !!!

Acknowledgements

Thank you to @randomnerd for proposing AlaSQL as a dialect for knex as PR. As well great thanks to @tgriesser and all the other knex.js contributors for building such a great query builder.

Copyright and License

Copyright Kaarel Raspel, 2016

MIT Licence