V7.4.0

What's Changed

• Support NpgsqlMultiHostDataSource by @Hawxy in #126
• New convenience methods to make it easier to use migrations on loose … by @jeremydmiller in #130
• Consistent generic support by @CptWesley in #129
• Postgres pk column ordering by @jeremydmiller in #131

New Contributors

• @CptWesley made their first contribution in #129

Full Changelog: V7.3.0...V7.4.0

V7.3.0

What's Changed

• Updated to .NET 8 by @oskardudycz in #108
• Added Postgres Full Text Index together from Marten by @oskardudycz in #110
• Added support for Npgsql data source by @oskardudycz in #112
• Updated DefaultNpgsqlDataSourceFactory to maintain the lifetime of data sources by @oskardudycz in #113
• Batch builder for Postgres by @jeremydmiller in #115
• Making CompoundWhereFragment auto-flatten to facilitate Marten LINQ l… by @jeremydmiller in #119
• Fixed PostgresqlProviderTests table_columns_should_match_raw_types where one test-case wasn't executed by @gfoidl in #121
• Working on DataSource usage (WIP) by @jeremydmiller in #122
• Being really paranoid about closing everything by @jeremydmiller in #123
• fix: When comparing indexes, drop the "public." prefix from index by @carlokok in #120
• Implement fix for marten issue #3068 by @bittercoder in #124
• Add a typed value overload for AppendParameter by @Hawxy in #116
• Bump Microsoft.Data.SqlClient from 5.1.2 to 5.1.3 in /src/Weasel.SqlServer by @dependabot in #117

New Contributors

• @carlokok made their first contribution in #120
• @bittercoder made their first contribution in #124
• @dependabot made their first contribution in #117

Full Changelog: 6.4.1...V7.3.0

6.4.1

✏️ What's Changed

• Fixed regression around setting up Foreign Keys made in #103. Replaced cast to PostgresqlObjectName from DBObjectName with conversion. Overloaded also equality comparison to ensure that schema diffs will be backwards compatible by @oskardudycz in #109

Milestone: https://github.com/JasperFx/weasel/milestone/17?closed=1
Full Changelog: 6.4.0...6.4.1

6.4.0

🚀 What's New

• Added "bigserial" and "smallserial" to the type mappings by @gfoidl in #106
• Bumped peer dependencies by minor version by @oskardudycz in #107

Milestone: https://github.com/JasperFx/weasel/milestone/16?closed=1
Full Changelog: 6.3.0...6.4.0

6.3.0

🚀 What's New

• New overload on CommandBuilder.AppendWithParameters() to override the separator character. by @jeremydmiller in d713e81

Full Changelog: 6.2.0...6.3.0

6.2.0

🚀 What's New

• Added support for case-sensitive SQL generation for PostgreSQL. So far, our schema comparison has not taken case sensitivity into account for PostgreSQL (as it's a default and recommended option). Still, for some cases it's useful to have it. Now you can do it by setting PostgresqlProvider.Instance.UseCaseSensitiveQualifiedNames to true in your application initialisation. by @oskardudycz in #103
• Added option to preview the last parameter added CommandBuilder by @jeremydmiller in #104

Milestone: https://github.com/JasperFx/weasel/milestone/15
Full Changelog: 6.1.2...6.2.0

6.1.2

✏️ What's Changed

• Added support for concurrent index creation for Postgres versions above 13. In version 13, the support for concurrent indexes changed, and they couldn't be run in the same statement as other queries. Thus, we didn't support it for versions above 13. This change brings also support to recent versions. by @danilfilatoff in #99
• CI improvements to ease local testing by @oskardudycz in #102

New Contributors

• @danilfilatoff made their first contribution in #99

Full Changelog: 6.1.1...6.1.2
Milestone: https://github.com/JasperFx/weasel/milestone/14?closed=1

6.1.1

✏️ What's Changed

• Moved to drop constraints before tables creation in Postgres deltas. Thanks to that removing column that's part of primary key should work well by @jeremydmiller in #101

Full Changelog: 6.1.0...6.1.1
Milestone: https://github.com/JasperFx/weasel/milestone/13?closed=1

6.1.0

🚀 What's New

• Added Function support in MSSQL by @smbecker in #91
• Update index support to allow for INCLUDE (columns) syntax in MSSQL by @smbecker in #91
• Added support for PostgreSQL 15's NULLS NOT DISTINCT for unique indexes by @VilleHakli in #89

✏️ What's Changed

• Corrected JSON type mapping in MSSQL by @smbecker in #91
• Fixed calculation of the full-text indexes by @mysticmind in #96
• Added support for CI for different Postgres versions by @oskardudycz in #98

New Contributors

• @VilleHakli made their first contribution in #89

Full Changelog: 6.0.3...6.1.0
Milestone: https://github.com/JasperFx/weasel/milestone/12?closed=1

1.3.0

Weasel.Postgres

Enhancements

• Add index definition parse logic to handle nulls sort order #52
• Add implementation to support COLLATE on index creation #54

Bug Fixes

• Index parsing fails with an exception when USING clause is not there in the index definition #53
• Fix index definition parse logic to handle tablespace #51

Miscellaneous

• Add unit test for support FASTUPDATE on gin indexes #25

Milestone v1.3.0: https://github.com/JasperFx/weasel/milestone/8?closed=1
Full Changelog: v1.2.0...v1.3.0