knex

knex copied to clipboard

How to config database.js: connect remote database (eg: mysql)

1

# Environment Knex version: 1.0.4 Database + version: mysql 5.7.8 OS: centos7.4 nodejs 14, strapi v4 Select applicable template from below. If issue is about oracledb support, tag @ atiertant....

eyea

Bad handling of special characters using knex raw

1

# Environment Knex version: ^2.1.0 Database + version: postgresql 14.4 OS: Ubuntu 20.04 # Bug I'm trying to store a `string` into my postgres database. The problem is the special...

eugenelet

two CTE with

2

Hi, I have this CTE in sqlite3: ``` WITH aCTE AS (SELECT 'a'), bCTE AS (SELECT 'b') SELECT * FROM aCTE, bCTE; ``` now I know how to select from...

sqllyw

unable to run raw query for `nextval`

1

# Environment Knex version: `0.21.19` Database + version: PostgreSql OS: macOS Select applicable template from below. If issue is about oracledb support, tag @ atiertant. For MSSql tag @ smorey2....

pokhiii

Releasing connection to pool slow?

1

# Environment Knex version: 2.1.0 Database + version: PostgreSQL 11.13 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-12), 64-bit OS: MacOS Monterey 12.0.1 # Bug 1. Explain...

damaon

fix(better-sqlite3): support `returning` for `update` and `del` method

3

https://sqlite.org/lang_returning.html

yodhcn

Builder extend() options w/ force

1

This PR is to add an Options object to each of the builder.extend functions. Further down the road, the options object can expand without creating breaking changes. The main motivation...

agiangrant

Hey, couldn't find anything in the docs about this. In the case that we're using `node-sqlite3`, how might we call their `.configure()` [method](https://github.com/TryGhost/node-sqlite3/wiki/API#configureoption-value)? Or even better, is there a way...

umaar

chore(types): use syntax `import from` instead of `import = require()`

1

waitingsong

Memory leak when using transactions

9

# Environment Knex version: 0.14.6 Database + version: Postgres 10 OS: OSX + linux on circleci # Bug Using knex transactions in tests causes a memory leak. Likely also in...

zamiang