0.0.4-SNAPSHOT • Published 6 years ago
sqlite-sjs v0.0.4-SNAPSHOT
Sqlite-sjs Client for Node.js App
A wrapper library that adds SQL-based migrations and some additional methods to better-sqlite3 api documentations docs
Install
NPM project:
npm install sqlite-sjs
SBT project:
libraryDependencies += "me.peproll" %%% "sqlite-sjs" % "0.0.3"
Usage
From js code:
var Database = require('sqlite-sjs');
var db = new Database('foobar.db', options);
var row = db.prepare('SELECT * FROM users WHERE id=?').get(userId);
console.log(row.firstName, row.lastName, row.email);
From scala.js code:
@ScalaJSDefined
trait User extends js.Object {
def name: String = js.native
}
val db = Sqlite("foobar.db", new ConnectionOptions())
var row = db.prepare("SELECT * FROM users WHERE id=?").get[User](userId)
println(s"Username: ${row.name}")
Migrations
Some stuff
0.0.4-SNAPSHOT
6 years ago