pgtyped

New features

• Experimental mode to generate a unique typed SQL tag by @JesseVelden in https://github.com/adelsz/pgtyped/pull/520
• Generated imports are forced to be type-only where possible
• Introduced a config variable to limit the max number of worker threads

Bug fixes

• Generated import paths fixed on Window machines by @lucas-gregoire in https://github.com/adelsz/pgtyped/pull/533
• Separate name and definition of union types to prevent Array naming issues by @leifniem in https://github.com/adelsz/pgtyped/pull/521
• Added dir_base template parameter for emitTemplate by @mrsafalpiya in https://github.com/adelsz/pgtyped/pull/515
• PG ranges are no longer parsed as params
• Non-identifier object keys are properly escaped in generated code

New Contributors

• @lucas-gregoire made their first contribution in https://github.com/adelsz/pgtyped/pull/533
• @leifniem made their first contribution in https://github.com/adelsz/pgtyped/pull/521
• @mrsafalpiya made their first contribution in https://github.com/adelsz/pgtyped/pull/515

Full Changelog: https://github.com/adelsz/pgtyped/compare/v2.2.1...v2.3.0

What's Changed

• chore: support TSC v5 (thanks @water-a in https://github.com/adelsz/pgtyped/pull/516)

New Contributors

• @fjavierv made their first contribution in https://github.com/adelsz/pgtyped/pull/505

Full Changelog: https://github.com/adelsz/pgtyped/compare/v2.1.0...v2.2.0

New features

• Types overrides imports by @nick-keller in https://github.com/adelsz/pgtyped/pull/488 and https://github.com/adelsz/pgtyped/pull/494 💪
• Add support for cleartext password authentication by @RobinClowers in https://github.com/adelsz/pgtyped/pull/502 🔐

Bug fixes

• Postgres dollar string parsing fixed by @adelsz in https://github.com/adelsz/pgtyped/pull/493 💲

New Contributors

• @RobinClowers made their first contribution in https://github.com/adelsz/pgtyped/pull/502

Full Changelog: https://github.com/adelsz/pgtyped/compare/v2.0.1...v2.1.0

Bug fixes

• Fix fragmented TCP packet handling that had been causing random CLI hangs on big PG data types (https://github.com/adelsz/pgtyped/pull/487)

Full Changelog: https://github.com/adelsz/pgtyped/compare/v2.0.0...v2.0.1

Features:

• All packages and code migrated to ES modules 📚 (https://github.com/adelsz/pgtyped/pull/478)
• Introduced new @pgtyped/runtime package. 🏃 (https://github.com/adelsz/pgtyped/pull/478)
  It is the only package needed to run pgTyped generated queries and is optimized for package size (ESM & CommonJS compatible).
• Environment variable DATABASE_URL now supported as an alternative to PGURI (thanks to @msakrejda in https://github.com/adelsz/pgtyped/pull/484)
• Nullable scalar parameter are no longer required when running a query (https://github.com/adelsz/pgtyped/pull/482) 🥂
• Queries returning anonymous columns are now forbidden and result in an error
• PgTyped in watch mode warns & exits on config file changes (https://github.com/adelsz/pgtyped/commit/2515f15b009bb68482e22e1d751987d09633639e) 👀
• Migrate to a more modern and performant threadpool Piscina. 🐠

Bug fixes:

• failOnError config option now kills the threadpool and exits pgTyped with an error code (https://github.com/adelsz/pgtyped/commit/aada874f55f84f9caf290800b7d45de9e1c59ea4) 🙅

Development changes:

• Lerna upgraded to latest version, meaning we now use native npm workspaces.
• Jest upgraded to latest version, number of tests rewritten to work with ESM and latest Jest. Mocking no longer supported.
• `@pgtyped/example" Integration tests now using Jest.
• Docs upgraded to Docusaurus 2.

Funding

• You can now support pgTyped though Github Sponsors 🙌

New Contributors

• @msakrejda made their first contribution in https://github.com/adelsz/pgtyped/pull/484

Features:

• Support type overrides (thanks @nick-keller) 🛠️
• Hungarian notation in interface names is now opt-in (thanks @snarky-puppy) 🇭🇺

Bug fixes:

• Fixed the parser to support Unicode characters that were breaking some queries 🌏

Bug fixes:

• Adding a query with a JsonArray type now correctly emits a Json type as well (thanks @logan12358) 📚
• Fixed the bug where pgTyped would leave orphan worker processes after shutdown 🚸
• Fixed invalid dbUrl in the example config file 🔗

New features:

• File processing logic is now parallelized, meaning much faster runs on large codebases (thanks @golergka) 🏎️
• Output nullability overriding that provides a workaround for Postgres type inference quirks (thanks @JesseVelden) 🎉
• Column comments are now included in generated types (thanks @danvk) 💬
• Stable SQL query IR preventing git diffs on irrelevant query file changes (thanks @bradleyayers) 🏛️
• Postgres tsvector datatype now supported (thanks @bradleyayers) 🔖

Bug fixes:

• Improved parsing of SQL comments (thanks @bradleyayers)
• Lexer bug for params with specials chars preceding
• Multiline comments parsing bug fixed
• More verbose file processing messages

New features:

• Support enum array types (thanks @maylukas ) 📚
• Support SCRAM-SHA-256 authentication (thanks @JesseVelden) 🔑
• Introduce deterministic field ordering (thanks @fmmoret) 🔢

Bug fixes:

• Fix non-nullable parameters parsing edgecase 🐞
• Use unknown instead of never for unsupported types (thanks @theswerd) ❔

New features:

• Allow to specify param nullability as :paramName! (thanks @JohnnyCrazy) 🥇
• Postgis point type support (thanks @joecarver ) ⚪

Bug fixes:

• esModuleInterop: false compatibility fix (thanks @bag-man) 📦
• Cast numeric/decimal/money as a string (thanks @jgonera) 💵

New features:

• Only write files if the content differs (thanks @bradleyayers ) 💾
• More informative CLI with help and version flags 🖥️
• New database connection URI CLI flag 🔗

New features:

• Deterministic sorting for generated types (thanks @carlpeaslee ) 🔢
• SSL support (thanks @water-a ) 🔑
• New DB URL config option (thanks @mako-taco ) 🔌
• Make generated array types readonly (thanks @mako-taco ) 🔒

New features:

• Array types now supported (thanks @steelbrain) 🚀
• Command line option to generate type definitions only for a particular file (thanks @golergka) 🧷

Bug fixes:

• Config parser now accepts absolute file paths (thanks @golergka)
• Fixed existing npm audit issues and vulnerabilities 🔐
• Multi line comments inside SQL statements are now ignored

Bug fixes:

• Fixed column nullability when no nullability info is available (thanks @darky) 🔥
• Fixed char parsing (thanks @mudrz) 🍬
• Removed stub dependencies (thanks @mudrz)
• All dependencies updated

Bug fixes:

• Fixed parsing for param names and keys that contain underscores
• Fixed int8 type map (thanks @darky)
• Fixed object array spread queries when passed empty params

New features:

• New and more efficient TS query parsing engine
• Experimental field camel casing support (thanks @darky) 🐫

Bug fixes:

• Fix TS query parameter binding issues
• Fix bigint and bigserial parsing
• Fix query package dependency issues

New features:

• Support both JS and JSON config formats (thanks @mmiszy) 🔮
• New types support: citext, network, void and interval (thanks @davecardwell and @silasdavis ) 🔢
• Ignore irrelevant comments in SQL files 🙈

Bug fixes:

• Fix SQL and SQL-in-TS queries in which parameters were used multiple times #101 #99 🐞
• Fix query param identifier parsing bug 🐛
• Add TS as peer dependency #87

New features:

• Added an exit-on-error CLI flag failOnError (thanks @silasdavis) 🏴

Bug fixes:

• Fixed object key sorting bug for TS based queries #79 🐛

New features:

• Support Postgres types json, jsonb and bytea (thanks @silasdavis) 🏷️
• Support Postgres enum types (thanks @silasdavis) 🏄‍♂️

Bug fixes:

• Fixed parsing for queries that use the Postgres type-cast operator :: ❄️

New features:

• Support customizing generated file paths using emitTemplate 🛠️
• Nullable query params can now be passed as both null and undefined 🌗