better-sqlite3 - npm Package Compare versions

Comparing version 2.3.0 to 2.3.1

benchmark/index.js

@@ -52,3 +52,3 @@ 'use strict';
 	function customPragma(str) {
-		return str.indexOf('cache_size') === -1;
+		return str.indexOf('cache_size') === -1 && str.indexOf('synchronous') === -1;
 	}
@@ -55,0 +55,0 @@ }

benchmark/trials.js

@@ -7,7 +7,7 @@ 'use strict';
 	{type: 'select-each', table: 'allSmall', columns: ['integer', 'real', 'text', 'nul']},
-	{type: 'insert', table: 'allSmall', columns: ['integer', 'real', 'text', 'nul'], pragma: ['journal_mode = WAL']},
-	{type: 'insert', table: 'allSmall', columns: ['integer', 'real', 'text', 'nul'], pragma: ['journal_mode = DELETE']},
+	{type: 'insert', table: 'allSmall', columns: ['integer', 'real', 'text', 'nul'], pragma: ['journal_mode = WAL', 'synchronous = 1']},
+	{type: 'insert', table: 'allSmall', columns: ['integer', 'real', 'text', 'nul'], pragma: ['journal_mode = DELETE', 'synchronous = 2']},
 	{type: 'transaction', table: 'allSmall', columns: ['integer', 'real', 'text', 'nul']},
-	{type: 'real-world', table: 'allSmall', columns: ['integer', 'real', 'text', 'nul'], pragma: ['journal_mode = WAL']},
-	{type: 'real-world', table: 'allSmall', columns: ['integer', 'real', 'text', 'nul'], pragma: ['journal_mode = DELETE']}
+	{type: 'real-world', table: 'allSmall', columns: ['integer', 'real', 'text', 'nul'], pragma: ['journal_mode = WAL', 'synchronous = 1']},
+	{type: 'real-world', table: 'allSmall', columns: ['integer', 'real', 'text', 'nul'], pragma: ['journal_mode = DELETE', 'synchronous = 2']}
 ];
@@ -37,16 +37,16 @@
 	{type: 'select-each', table: 'allLarge', columns: ['blob']},
-	{type: 'insert', table: 'integerSmall', columns: ['integer'], pragma: ['journal_mode = WAL']},
-	{type: 'insert', table: 'realSmall', columns: ['real'], pragma: ['journal_mode = WAL']},
-	{type: 'insert', table: 'textSmall', columns: ['text'], pragma: ['journal_mode = WAL']},
-	{type: 'insert', table: 'blobSmall', columns: ['blob'], pragma: ['journal_mode = WAL']},
-	{type: 'insert', table: 'nulSmall', columns: ['nul'], pragma: ['journal_mode = WAL']},
-	{type: 'insert', table: 'textLarge', columns: ['text'], pragma: ['journal_mode = WAL']},
-	{type: 'insert', table: 'blobLarge', columns: ['blob'], pragma: ['journal_mode = WAL']},
-	{type: 'insert', table: 'integerSmall', columns: ['integer'], pragma: ['journal_mode = DELETE']},
-	{type: 'insert', table: 'realSmall', columns: ['real'], pragma: ['journal_mode = DELETE']},
-	{type: 'insert', table: 'textSmall', columns: ['text'], pragma: ['journal_mode = DELETE']},
-	{type: 'insert', table: 'blobSmall', columns: ['blob'], pragma: ['journal_mode = DELETE']},
-	{type: 'insert', table: 'nulSmall', columns: ['nul'], pragma: ['journal_mode = DELETE']},
-	{type: 'insert', table: 'textLarge', columns: ['text'], pragma: ['journal_mode = DELETE']},
-	{type: 'insert', table: 'blobLarge', columns: ['blob'], pragma: ['journal_mode = DELETE']},
+	{type: 'insert', table: 'integerSmall', columns: ['integer'], pragma: ['journal_mode = WAL', 'synchronous = 1']},
+	{type: 'insert', table: 'realSmall', columns: ['real'], pragma: ['journal_mode = WAL', 'synchronous = 1']},
+	{type: 'insert', table: 'textSmall', columns: ['text'], pragma: ['journal_mode = WAL', 'synchronous = 1']},
+	{type: 'insert', table: 'blobSmall', columns: ['blob'], pragma: ['journal_mode = WAL', 'synchronous = 1']},
+	{type: 'insert', table: 'nulSmall', columns: ['nul'], pragma: ['journal_mode = WAL', 'synchronous = 1']},
+	{type: 'insert', table: 'textLarge', columns: ['text'], pragma: ['journal_mode = WAL', 'synchronous = 1']},
+	{type: 'insert', table: 'blobLarge', columns: ['blob'], pragma: ['journal_mode = WAL', 'synchronous = 1']},
+	{type: 'insert', table: 'integerSmall', columns: ['integer'], pragma: ['journal_mode = DELETE', 'synchronous = 2']},
+	{type: 'insert', table: 'realSmall', columns: ['real'], pragma: ['journal_mode = DELETE', 'synchronous = 2']},
+	{type: 'insert', table: 'textSmall', columns: ['text'], pragma: ['journal_mode = DELETE', 'synchronous = 2']},
+	{type: 'insert', table: 'blobSmall', columns: ['blob'], pragma: ['journal_mode = DELETE', 'synchronous = 2']},
+	{type: 'insert', table: 'nulSmall', columns: ['nul'], pragma: ['journal_mode = DELETE', 'synchronous = 2']},
+	{type: 'insert', table: 'textLarge', columns: ['text'], pragma: ['journal_mode = DELETE', 'synchronous = 2']},
+	{type: 'insert', table: 'blobLarge', columns: ['blob'], pragma: ['journal_mode = DELETE', 'synchronous = 2']},
 	{type: 'transaction', table: 'integerSmall', columns: ['integer']},
@@ -53,0 +53,0 @@ {type: 'transaction', table: 'realSmall', columns: ['real']},

package.json

 {
   "name": "better-sqlite3",
-  "version": "2.3.0",
+  "version": "2.3.1",
   "description": "The fastest and simplest library for SQLite3 in Node.js.",
@@ -5,0 +5,0 @@ "homepage": "http://github.com/JoshuaWise/better-sqlite3",

README.md

@@ -8,2 +8,3 @@ # better-sqlite3 [![Build Status](https://travis-ci.org/JoshuaWise/better-sqlite3.svg?branch=master)](https://travis-ci.org/JoshuaWise/better-sqlite3)
 - Easy-to-use synchronous API *(faster than an asynchronous API... yes, you read that correctly)*
+- Custom SQL function support
 - 64-bit integer support *(invisible until you need it)*
@@ -16,3 +17,3 @@
 |better-sqlite3|1x|1x|1x|1x|1x|
-|[sqlite](https://www.npmjs.com/package/sqlite) and [sqlite3](https://www.npmjs.com/package/sqlite3)|7.6x slower|2.9x slower|3.2x slower|1.6x slower|7.2x slower|
+|[sqlite](https://www.npmjs.com/package/sqlite) and [sqlite3](https://www.npmjs.com/package/sqlite3)|7.8x slower|2.7x slower|3.0x slower|3.2x slower|6.2x slower|
 
@@ -19,0 +20,0 @@ > You can verify these results by [running the benchmark yourself](https://github.com/JoshuaWise/better-sqlite3/wiki/Benchmark).

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Number of lines in readme file

54

increased by1.89%

Number of low supply chain risk alerts

6

decreased by-14.29%

Worsened metrics

Total package byte prevSize

2721769

decreased by-0.06%

Number of package files

94

decreased by-2.08%

Lines of code

2193

decreased by-1.04%

No dependency changes