better-sqlite3 with multiple-cipher encryption support. 

better-sqlite3 with multiple-cipher encryption support

m4heshd

better-sqlite3-multiple-ciphers

  "name": "better-sqlite3-multiple-ciphers",

  "description": "better-sqlite3 with multiple-cipher encryption support",

  "homepage": "https://github.com/m4heshd/better-sqlite3-multiple-ciphers",

  "author": "Mahesh Bandara Wijerathna (m4heshd) <m4heshd@gmail.com>",

    "url": "git://github.com/m4heshd/better-sqlite3-multiple-ciphers.git"

    "install": "prebuild-install || node-gyp rebuild --release",

    "build-release": "node-gyp rebuild --release",

    "build-debug": "node-gyp rebuild --debug",

    "rebuild-release": "npm run lzz && npm run build-release",

    "rebuild-debug": "npm run lzz && npm run build-debug",

    "test": "mocha --exit --slow=75 --timeout=30000",

    "test:container": "docker-compose up --detach --build",

    "download": "bash ./deps/download.sh",

    "setup": "powershell ./deps/setup.ps1",

    "lzz": "lzz -hx hpp -sx cpp -k BETTER_SQLITE3 -d -hl -sl -e ./src/better_sqlite3.lzz",

    "bump:patch": "npm --no-git-tag-version version patch",

    "bump:minor": "npm --no-git-tag-version version minor",

    "bump:major": "npm --no-git-tag-version version major",

    "bump:patch:beta": "npm --no-git-tag-version --preid=beta version prepatch",

    "bump:minor:beta": "npm --no-git-tag-version --preid=beta version preminor",

    "bump:major:beta": "npm --no-git-tag-version --preid=beta version premajor",

    "bump:prerelease:beta": "npm --no-git-tag-version --preid=beta version prerelease",

    "release:beta": "npm publish --tag beta"

[![NPM version](https://img.shields.io/npm/v/better-sqlite3-multiple-ciphers?logo=npm&color=cc3838&style=for-the-badge)](https://www.npmjs.com/package/better-sqlite3-multiple-ciphers)

[![Downloads](https://img.shields.io/npm/dt/better-sqlite3-multiple-ciphers?logo=DocuSign&logoColor=FFF&color=2757c4&style=for-the-badge)](https://www.npmjs.com/package/better-sqlite3-multiple-ciphers)

[![Build status](https://img.shields.io/github/actions/workflow/status/m4heshd/better-sqlite3-multiple-ciphers/test.yml?branch=master&label=Build%2FTest&logo=github&style=for-the-badge)](https://github.com/m4heshd/better-sqlite3-multiple-ciphers/actions/workflows/test.yml)

The fastest and simplest library for SQLite3 in Node.js. This particular fork supports multiple-cipher encryption using [SQLite3MultipleCiphers](https://github.com/utelle/SQLite3MultipleCiphers). Check [usage](#usage) to learn more.

- High performance, efficiency, and safety

- Easy-to-use synchronous API *(better concurrency than an asynchronous API... yes, you read that correctly)*

- Support for user-defined functions, aggregates, virtual tables, and extensions

- 64-bit integers *(invisible until you need them)*

- Worker thread support *(for large/slow queries)*

- Encryption support using multiple algorithms

  - **better-sqlite3-multiple-ciphers** - [`9.1.1`](https://github.com/m4heshd/better-sqlite3-multiple-ciphers/releases/tag/v9.1.1)

  - **better-sqlite3** - [`9.1.1`](https://github.com/JoshuaWise/better-sqlite3/releases/tag/v9.1.1)

  - **SQLite** - [`3.44.0`](https://www.sqlite.org/releaselog/3_44_0.html)

  - **SQLite3 Multiple Ciphers** - [`1.7.4`](https://github.com/utelle/SQLite3MultipleCiphers/releases/tag/v1.7.4)

  - **better-sqlite3-multiple-ciphers** - [`9.2.0`](https://github.com/m4heshd/better-sqlite3-multiple-ciphers/releases/tag/v9.2.0)

  - **better-sqlite3** - [`9.2.0`](https://github.com/JoshuaWise/better-sqlite3/releases/tag/v9.2.0)

  - **SQLite** - [`3.44.2`](https://www.sqlite.org/releaselog/3_44_2.html)

  - **SQLite3 Multiple Ciphers** - [`1.8.1`](https://github.com/utelle/SQLite3MultipleCiphers/releases/tag/v1.8.1)

  - **better-sqlite3-multiple-ciphers** - [`v9.1.2-beta.0`](https://github.com/m4heshd/better-sqlite3-multiple-ciphers/releases/tag/v9.1.2-beta.0)

  - **SQLite** - [`3.44.1`](https://www.sqlite.org/releaselog/3_44_1.html)

  - **SQLite3 Multiple Ciphers** - [`1.8.0`](https://github.com/utelle/SQLite3MultipleCiphers/releases/tag/v1.8.0)

## Help this project stay strong! &#128170;

`better-sqlite3` is used by thousands of developers and engineers on a daily basis. Long nights and weekends were spent keeping this project strong and dependable, with no ask for compensation or funding, until now. If your company uses `better-sqlite3`, ask your manager to consider supporting the project:

- [Become a GitHub sponsor](https://github.com/sponsors/JoshuaWise)

- [Become a backer on Patreon](https://www.patreon.com/joshuawise)

- [Make a one-time donation on PayPal](https://www.paypal.me/joshuathomaswise)

Also head over to [SQLite3MultipleCiphers](https://github.com/utelle/SQLite3MultipleCiphers) repo and give some support to the developer to keep this very useful extension alive.

You can also support me (the maintainer of this fork) by buying me a coffee. 😊

[![ko-fi](https://i.ibb.co/QmQknmc/ko-fi.png)](https://ko-fi.com/m4heshd)

> You can verify these results by [running the benchmark yourself](./docs/benchmark.md).

npm install better-sqlite3-multiple-ciphers

npm install better-sqlite3-multiple-ciphers@beta

> You must be using Node.js v14.21.1 or above. Prebuilt binaries are available for Node.js [LTS versions](https://nodejs.org/en/about/releases/) and Electron. If you have trouble installing, check the [troubleshooting guide](./docs/troubleshooting.md).

const db = require('better-sqlite3-multiple-ciphers')('foobar.db', options);

const row = db.prepare('SELECT * FROM users WHERE id = ?').get(userId);

console.log(row.firstName, row.lastName, row.email);

Though not required, [it is generally important to set the WAL pragma for performance reasons](https://github.com/WiseLibs/better-sqlite3/blob/master/docs/performance.md).

import Database from 'better-sqlite3-multiple-ciphers';

const db = new Database('foobar.db', options);

A database can be encrypted and decrypted simply using `key` and `rekey` `PRAGMA` statements.

**Running this will encrypt the database using the default cipher:**

**To read an encrypted database (assuming default cipher):**

**To read an encrypted database _(legacy SQLCipher)_ created by tools like [DB Browser for SQLite](https://github.com/sqlitebrowser/sqlitebrowser):**

		{
		"name": "better-sqlite3-multiple-ciphers",
		"version": "9.1.2-beta.0",
		"version": "9.2.0",
		"description": "better-sqlite3 with multiple-cipher encryption support",
		@@ -5,0 +5,0 @@ "homepage": "https://github.com/m4heshd/better-sqlite3-multiple-ciphers",

Fixed alerts

Improved metrics

		@@ -20,6 +20,6 @@ # better-sqlite3-multiple-ciphers
		- ### Stable
		- better-sqlite3-multiple-ciphers - [`9.1.1`](https://github.com/m4heshd/better-sqlite3-multiple-ciphers/releases/tag/v9.1.1)
		- better-sqlite3 - [`9.1.1`](https://github.com/JoshuaWise/better-sqlite3/releases/tag/v9.1.1)
		- SQLite - [`3.44.0`](https://www.sqlite.org/releaselog/3_44_0.html)
		- SQLite3 Multiple Ciphers - [`1.7.4`](https://github.com/utelle/SQLite3MultipleCiphers/releases/tag/v1.7.4)
		- better-sqlite3-multiple-ciphers - [`9.2.0`](https://github.com/m4heshd/better-sqlite3-multiple-ciphers/releases/tag/v9.2.0)
		- better-sqlite3 - [`9.2.0`](https://github.com/JoshuaWise/better-sqlite3/releases/tag/v9.2.0)
		- SQLite - [`3.44.2`](https://www.sqlite.org/releaselog/3_44_2.html)
		- SQLite3 Multiple Ciphers - [`1.8.1`](https://github.com/utelle/SQLite3MultipleCiphers/releases/tag/v1.8.1)

		@@ -26,0 +26,0 @@ - ### Beta