# sqlite3-offline

> Bundled SQLite3 library for offline environments

Latest version **4.3.1** (published 2020-05-17) · MIT license · 0 weekly downloads

## Install

```sh
npm install sqlite3-offline
pnpm add sqlite3-offline
yarn add sqlite3-offline
bun add sqlite3-offline
```

## Health

**Score 25/100 (F)** — status: abandoned.

Positive: has types; no vulnerabilities; high quality score.

Warnings: low downloads; no esm support; large bundle.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 4.3.1 |
| Published | 2020-05-17 |
| First published | 2016-12-20 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | bundled |
| Module format | CommonJS |
| Dependencies | 0 |
| Unpacked size | 128.8 MB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| Author | Denis Carriere |
| Maintainers | deniscarriere |
| Keywords | sqlite3, offline, mac, linux, windows, electron |

## Links

- npm: https://www.npmjs.com/package/sqlite3-offline
- npm.io page: https://npm.io/package/sqlite3-offline

## Alternatives

- [@opentelemetry/exporter-zipkin](https://npm.io/package/@opentelemetry/exporter-zipkin.md) — 14.8M weekly downloads
- [pusher-js](https://npm.io/package/pusher-js.md) — 2.0M weekly downloads
- [browserify](https://npm.io/package/browserify.md) — 1.7M weekly downloads
- [sqs-consumer](https://npm.io/package/sqs-consumer.md) — 1.7M weekly downloads
- [@sanity/eventsource](https://npm.io/package/@sanity/eventsource.md) — 930.8K weekly downloads

## Recent versions

- 4.3.1 (latest) — 2020-05-17
- 4.3.0 — 2020-03-24
- 4.2.0 — 2020-03-10
- 4.0.6 — 2019-02-04
- 3.2.0 — 2017-10-24
- 3.1.8-5 — 2017-08-29
- 3.1.8-4 — 2017-08-29
- 3.1.8-3 — 2017-08-29
- 3.1.8-2 — 2017-07-05
- 3.1.8-1 — 2017-06-28
- 3.1.8-0 — 2017-06-28
- 3.1.18 — 2017-02-17
- 3.1.17 — 2017-02-17
- 3.1.16 — 2017-02-17
- 3.1.15 — 2017-02-17
- … 10 more at https://npm.io/package/sqlite3-offline/versions

## README

# SQLite3 for offline

[![Build Status](https://travis-ci.org/DenisCarriere/sqlite3-offline.svg?branch=master)](https://travis-ci.org/DenisCarriere/sqlite3-offline)
[![npm version](https://badge.fury.io/js/sqlite3-offline.svg)](https://badge.fury.io/js/sqlite3-offline)
[![MIT licensed](https://img.shields.io/badge/license-MIT-blue.svg)](https://raw.githubusercontent.com/DenisCarriere/sqlite3-offline/master/LICENSE)

<!-- Line Break -->
[![Standard - JavaScript Style Guide](https://cdn.rawgit.com/feross/standard/master/badge.svg)](https://github.com/feross/standard)

> Bundled library for [SQLite3](https://github.com/mapbox/node-sqlite3) for offline deployments.
>
> Zero dependencies, zero external HTTP downloads.

## Install

```bash
$ npm install --save sqlite3-offline
```

## Quickstart

```javascript
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

- [mbtiles-offline](https://github.com/DenisCarriere/mbtiles-offline)

## License

BSD © [Mapbox](https://github.com/mapbox/node-sqlite3)

---
_Source: https://npm.io/package/sqlite3-offline · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._