Database-js driver for JSON files
npm install database-js-jsonshell
npm install database-js-json
`
Basic Usage
`javascript
var Connection = require( 'database-js2' ).Connection;
(async () => {
const connection = new Database( 'json:///test.json' );
try {
let statement = await connection.prepareStatement("SELECT * WHERE user_name = ?");
let rows = await statement.query('not_so_secret_user');
console.log(rows);
} catch (error) {
console.log(error);
} finally {
await connection.close();
}
} )();
`
Basic Options
Options can be passed as arguments to the database connection string, in URL-format.
- charset: defines the charset (encoding) used to handle the JSON file
- Defaults to utf-8
- Example: const connection = new Database( 'json:///test.json?charset=utf-16' );
- Available in database-js-json version 1.0.0 or later
- checkOnConnect: whether it should check if the file exists when connecting to it
- Defaults to true
- Example: const connection = new Database( 'json:///test.json?checkOnConnect=false' );
- Accepts false, no or 0 as false
- Available in database-js-json version 1.1.0 or later
Additional Options
Options from jl-sql-api can also be passed as arguments to the database connection.
Example: { tmpDir: "/path/to/dir" }
`javascript
const connection = new Database( 'json:///test.json?tmpDir=path/to/dir' );
`
When an option that belongs to a group is informed, it must have a dot.
Example: { tmpDir: "/path/to/dir", sortOptions: { inMemoryBufferSize: 32000 } }
`javascript
const connection = new Database( 'json:///test.json?tmpDir=path/to/dir&sortOptions.inMemoryBufferSize=32000' );
``