sqlite3-offline
TypeScript icon, indicating that this package has built-in type declarations

4.3.1 • Public • Published

SQLite3 for offline

Build Status npm version MIT licensed

Standard - JavaScript Style Guide

Bundled library for SQLite3 for offline deployments.

Zero dependencies, zero external HTTP downloads.

Install

$ npm install --save sqlite3-offline

Quickstart

const sqlite3 = require('sqlite3-offline').verbose()
var db = new sqlite3.Database(':memory:')
 
db.serialize(function() {
  db.run("CREATE TABLE lorem (info TEXT)")
 
  var stmt = db.prepare("INSERT INTO lorem VALUES (?)")
  for (var i = 0; i < 10; i++) {
    stmt.run("Ipsum " + i)
  }
  stmt.finalize()
 
  db.each("SELECT rowid AS id, info FROM lorem", function(err, row) {
    console.log(row.id + "" + row.info)
  })
})
 
db.close()

Supported Platforms

  • Windows x64 & ia32
  • MacOSX x64
  • Linux x64
  • Electron
    • v1.5
    • v1.6
    • v1.7
    • v8.2

Supported NodeJS Release

  • Node.js v13 (79)
  • Node.js v12 (72)
  • Node.js v11 (69)
  • Node.js v10 (64)
  • Node.js v9 (59)
  • Node.js v8
  • Node.js v7
  • Node.js v6
  • Node.js v5
  • Node.js v4

Related

License

BSD © Mapbox

Package Sidebar

Install

npm i sqlite3-offline

Weekly Downloads

107

Version

4.3.1

License

MIT

Unpacked Size

135 MB

Total Files

90

Last publish

Collaborators

  • deniscarriere