@databases/[email protected]

Performance Improvements

• Release connections before running post commit steps (#274)

  This reduces the risk of deadlocks where the post-commit step might be waiting for a connection from the pool while a connection is still being held by the transaction, even though the transaction cannot be used once the post-commit steps begin running.

@databases/[email protected]

New Features

• Added SQLQuery.toSql() method to allow you to get the SQLQuery generated by pg-typed without executing it against the database. This can allow you to generate type safe parts of larger, more complex queries. (#268)

• Added Table.conditionToSql(whereCondition) utility to convert a type safe condition to the condition part of an SQLQuery. This can be used to generate type safe conditions for queries that require a join or other more complex operation. (#268)

• Added SQLQuery.distinct(...columnNames) utility to allow you to request only distinct rows without indicating a required sort order. (#268)

• Allowed arbitrary SQLQuerys to be passed to the .find() method, the .andWhere() method and the and/or utilities. This lets you construct mostly type safe queries while still using some unsafe conditions written in raw SQL. (#268)

@databases/[email protected]

Bug Fixes

• Transactions were handled incorrectly and could therefore not be rolled back (#263)

@databases/[email protected]

Bug Fixes

• Detect REINDEX queries (#266)

@databases/[email protected]

Bug Fixes

• Transaction rollback failed due to using the wrong keyword (#258)

@databases/[email protected]

New Features

• Sort generated type declarations alphabetically (#257)

  This makes the output more stable when adding & removing foreign keys

• Add getIgnoreTest utility (#256)

  Given lists of tables to include and ignore, this returns a function to test if a given table should be ignored

@databases/[email protected]

Bug Fixes

• Types were sometimes generated for ignored tables if referenced by other tables (#256)

@databases/[email protected]

Bug Fixes

• Types were sometimes generated for ignored tables if referenced by other tables (#256)

@databases/[email protected]

New Features

• Add options to ignore tables when generating types (#254)

  • includeTables - if specified, types will only be generated for the tables listed
  • ignoreTables - if specified, types will not be generated for the tables listed, even if they are also listed in includeTables

@databases/[email protected]

Bug Fixes

• Add options to ignore tables when generating types (#254)

  • types.includeTables - if specified, types will only be generated for the tables listed
  • types.ignoreTables - if specified, types will not be generated for the tables listed, even if they are also listed in types.includeTables