v2.3.0

New features

• Experimental mode to generate a unique typed SQL tag by @JesseVelden in #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 #533
• Separate name and definition of union types to prevent Array naming issues by @leifniem in #521
• Added dir_base template parameter for emitTemplate by @mrsafalpiya in #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 #533
• @leifniem made their first contribution in #521
• @mrsafalpiya made their first contribution in #515

Full Changelog: v2.2.1...v2.3.0

v2.2.0

What's Changed

• chore: support TSC v5 (thanks @water-a in #516)

New Contributors

• @fjavierv made their first contribution in #505

Full Changelog: v2.1.0...v2.2.0

v2.1.0

New features

• Types overrides imports by @nick-keller in #488 and #494 💪
• Add support for cleartext password authentication by @RobinClowers in #502 🔐

Bug fixes

• Postgres dollar string parsing fixed by @adelsz in #493 💲

New Contributors

• @RobinClowers made their first contribution in #502

Full Changelog: v2.0.1...v2.1.0

v2.0.1

Bug fixes

• Fix fragmented TCP packet handling that had been causing random CLI hangs on big PG data types (#487)

Full Changelog: v2.0.0...v2.0.1

v2.0.0

Features:

• All packages and code migrated to ES modules 📚 (#478)
• Introduced new @pgtyped/runtime package. 🏃 (#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 #484)
• Nullable scalar parameter are no longer required when running a query (#482) 🥂
• Queries returning anonymous columns are now forbidden and result in an error
• PgTyped in watch mode warns & exits on config file changes (2515f15) 👀
• 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 (aada874) 🙅

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 #484

v1.1.0

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 🌏

v1.0.2

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 🔗

v1.0.0

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

v0.13.0

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

v0.12.0

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