mirror of
https://github.com/brianc/node-postgres.git
synced 2025-12-08 20:16:25 +00:00
520bd35319
This switches the internals to use faster protocol parsing & serializing. This results in a significant (30% - 50%) speed up in some common query patterns. There is quite a bit more performance work I need to do, but this takes care of some initial stuff & removes a big fork in the code.
65 lines
1.8 KiB
YAML
65 lines
1.8 KiB
YAML
language: node_js
|
|
dist: bionic
|
|
|
|
before_script: |
|
|
yarn build
|
|
node packages/pg/script/create-test-tables.js postgresql:///
|
|
|
|
env:
|
|
- CC=clang CXX=clang++ npm_config_clang=1 PGUSER=postgres PGDATABASE=postgres
|
|
|
|
node_js:
|
|
- lts/dubnium
|
|
- lts/erbium
|
|
# node 13.7 seems to have changed behavior of async iterators exiting early on streams
|
|
# if 13.8 still has this problem when it comes down I'll talk to the node team about the change
|
|
# in the mean time...peg to 13.6
|
|
- 13.6
|
|
- 14
|
|
|
|
addons:
|
|
postgresql: '10'
|
|
|
|
matrix:
|
|
include:
|
|
# Run tests/paths that require password authentication
|
|
- node_js: lts/erbium
|
|
env:
|
|
- CC=clang CXX=clang++ npm_config_clang=1 PGUSER=postgres PGDATABASE=postgres PGPASSWORD=test-password SCRAM_TEST_PGUSER=scram_test SCRAM_TEST_PGPASSWORD=test4scram
|
|
before_script: |
|
|
sudo -u postgres sed -i \
|
|
-e '/^local/ s/trust$/peer/' \
|
|
-e '/^host/ s/trust$/md5/' \
|
|
/etc/postgresql/10/main/pg_hba.conf
|
|
sudo -u postgres psql -c "ALTER ROLE postgres PASSWORD 'test-password'; SELECT pg_reload_conf()"
|
|
yarn build
|
|
node packages/pg/script/create-test-tables.js postgresql:///
|
|
sudo -u postgres -- psql \
|
|
-c "SET password_encryption = 'scram-sha-256'" \
|
|
-c "CREATE ROLE scram_test login password 'test4scram'"
|
|
|
|
- node_js: lts/carbon
|
|
addons:
|
|
postgresql: '9.5'
|
|
dist: precise
|
|
|
|
# different PostgreSQL versions on Node LTS
|
|
- node_js: lts/erbium
|
|
addons:
|
|
postgresql: '9.3'
|
|
- node_js: lts/erbium
|
|
addons:
|
|
postgresql: '9.4'
|
|
- node_js: lts/erbium
|
|
addons:
|
|
postgresql: '9.5'
|
|
- node_js: lts/erbium
|
|
addons:
|
|
postgresql: '9.6'
|
|
|
|
# PostgreSQL 9.2 only works on precise
|
|
- node_js: lts/carbon
|
|
addons:
|
|
postgresql: '9.2'
|
|
dist: precise
|