better-sqlite3-multiple-ciphers
Advanced tools
Comparing version 9.0.0 to 9.1.1
{ | ||
"name": "better-sqlite3-multiple-ciphers", | ||
"version": "9.0.0", | ||
"version": "9.1.1", | ||
"description": "better-sqlite3 with multiple-cipher encryption support", | ||
@@ -5,0 +5,0 @@ "homepage": "https://github.com/m4heshd/better-sqlite3-multiple-ciphers", |
@@ -20,6 +20,6 @@ # better-sqlite3-multiple-ciphers | ||
- ### Stable | ||
- **better-sqlite3-multiple-ciphers** - [`9.0.0`](https://github.com/m4heshd/better-sqlite3-multiple-ciphers/releases/tag/v9.0.0) | ||
- **better-sqlite3** - [`9.0.0`](https://github.com/JoshuaWise/better-sqlite3/releases/tag/v9.0.0) | ||
- **SQLite** - [`3.43.2`](https://www.sqlite.org/releaselog/3_43_2.html) | ||
- **SQLite3 Multiple Ciphers** - [`1.7.2`](https://github.com/utelle/SQLite3MultipleCiphers/releases/tag/v1.7.2) | ||
- **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) | ||
@@ -103,3 +103,3 @@ - ### Beta | ||
db.pragma("rekey='secret-key'"); | ||
db.pragma(`rekey='secret-key'`); | ||
db.close(); | ||
@@ -113,4 +113,4 @@ ``` | ||
db.pragma("key='secret-key'"); | ||
const row = db.prepare("SELECT * FROM users WHERE id = ?").get(userId); | ||
db.pragma(`key='secret-key'`); | ||
const row = db.prepare('SELECT * FROM users WHERE id = ?').get(userId); | ||
console.log(row.firstName, row.lastName, row.email); | ||
@@ -126,4 +126,4 @@ ``` | ||
db.pragma(`legacy=4`) | ||
db.pragma("key='secret-key'"); | ||
const row = db.prepare("SELECT * FROM users WHERE id = ?").get(userId); | ||
db.pragma(`key='secret-key'`); | ||
const row = db.prepare('SELECT * FROM users WHERE id = ?').get(userId); | ||
console.log(row.firstName, row.lastName, row.email); | ||
@@ -135,2 +135,13 @@ ``` | ||
**GUI database editors:** | ||
Even though `better-sqlite3-multiple-ciphers` supports opening databases created | ||
using [DB Browser for SQLite](https://github.com/sqlitebrowser/sqlitebrowser), it only supports creating/editing legacy | ||
SQLCipher databases which means, it's highly likely that you won't be able to open a database created | ||
using `better-sqlite3-multiple-ciphers` in DB Browser for SQLite. | ||
To visually edit databases created using `better-sqlite3-multiple-ciphers` regardless of the cipher configuration, it's | ||
recommended to use a tool like [SQLiteStudio](https://github.com/pawelsalawa/sqlitestudio) because it also | ||
uses [SQLite3MultipleCiphers](https://github.com/utelle/SQLite3MultipleCiphers) under the hood. | ||
### Read more about encryption at [SQLite3MultipleCiphers documentation](https://utelle.github.io/SQLite3MultipleCiphers/). | ||
@@ -137,0 +148,0 @@ |
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
Sorry, the diff of this file is not supported yet
12167659
175