Add pg-promise-native

porsager · porsager · commit c14764deaefc · 2020-01-12T23:33:19.000+01:00
diff --git a/README.md b/README.md
@@ -21,6 +21,7 @@ client     |         select |     select_arg |    select_args |   select_where
 :--------- | -------------: | -------------: | -------------: | -------------:
 postgres   |    82ms (5.1x) |    91ms (5.3x) |   226ms (3.6x) |   229ms (5.0x)
 pg-promise |   331ms (1.3x) |   368ms (1.3x) |   605ms (1.3x) |   771ms (1.5x)
+pg-promise-native |  0.317s (1.3x) |  0.401s (1.2x) |  0.618s (1.3x) |  0.799s (1.4x)
 pg         |   292ms (1.4x) |   473ms (1.0x) |   772ms (1.1x) |  1070ms (1.1x)
 pg-native  |   419ms (1.0x) |   478ms (1.0x) |   816ms (1.0x) |  1138ms (1.0x)
 slonik     | 10466ms (0.0x) | 10904ms (0.0x) | 11190ms (0.0x) | 11107ms (0.0x)
diff --git a/index.js b/index.js
@@ -7,6 +7,8 @@ const queries = [
     , clients = [
       'postgres',
       'pg-promise',
+      'pg-promise-native',
+      'postgres-promise',
       'pg',
       'pg-native',
       //'slonik'
diff --git a/pg-promise-native/index.js b/pg-promise-native/index.js
@@ -0,0 +1,29 @@
+const pg = require('pg-promise')
+
+const db = pg()({ max: 4, pgNative: true })
+
+module.exports = {
+  queries: {
+    select: () => db.query('select 1 as x'),
+    select_arg: () => db.query('select $1 as x', [1]),
+    select_args: () => db.query(`select
+      $1::int as int,
+      $2 as string,
+      $3::timestamp with time zone as timestamp,
+      $4 as null,
+      $5::bool as boolean,
+      $6::bytea as bytea,
+      $7::jsonb as json
+    `, [
+      1337,
+      'wat',
+      new Date().toISOString(),
+      null,
+      false,
+      Buffer.from('awesome'),
+      JSON.stringify([{ some: 'json' }, { array: 'object' }])
+    ]),
+    select_where: () => db.query(`select * from pg_catalog.pg_type where typname = $1`, ['bool'])
+  },
+  end: () => db.$pool.end()
+}
diff --git a/results.png b/results.png
