Pgtyped Versions Save

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) 💵