0.5.2.0

What's Changed

• Add support for GHC versions 8.10-9.2
• Add typed UUIDs
• Allow literal rows in update queries. (#139)
• Add support for UNION/UNION ALL. (#140)
• Suppor raw PostgreSQL connetion strings. (#136)
• Move to Docker and GitHub actions for testing.
• Drop support for GHC versions <8.8.
• Fix typos in tutorial by @divarvel in #145
• Add distinction between int 64 and int 32. by @TomMD in #150
• Do not isolate distinct to avoid missing renames by @TomMD in #168
• SeldaT uses a ReaderT instead of StateT by @YPares in #167
• Cleaned up stack config for lts 17.0 by @YPares in #166
• Exporting GSqlRow to be able to refer to it by @YPares in #164
• Psql and Sqlite both allow "DOUBLE PRECISION" but not "DOUBLE" by @TomMD in #163
• Add tableInfoName field to TableInfo that holds the TableName from Table by @cdepillabout in #149
• Enable compatibility with newer GHC and dependency versions by @jchia in #175

New Contributors

• @divarvel made their first contribution in #145
• @YPares made their first contribution in #167
• @cdepillabout made their first contribution in #149
• @jchia made their first contribution in #175

Full Changelog: 0.5.1.0...0.5.2.0

0.5.1 release

Major feature of this release: build queries from raw SQL fragments.

Changelog:

• Support for raw SQL fragments. (#134)
• Expose tableName.
• Document performance drawbacks of withoutForeignKeyEnforcement.
• Fix several bugs validating auto-incrementing PKs. (#133)

0.5 release

Would have been a minor release if not for index and indexUsing getting new type signatures.

Changelog

• index and indexUsing now accept a Group instead of a Selector (#121)
• Custom type errors for scope mismatches.
• Provide Generic instances for ID and RowID.
• Provide To/FromJSON instances for ID and RowID (selda-json).
• Add back MonadTrans instance for SeldaT.

0.4 release

Major release, mainly focusing on API improvements and new functionality. Not entirely backwards compatible with the 0.3 branch.

Changelog

• Type-safe support for backend-specific functionality. Top level query definitions now require explicit type signature. (#80)
• Native UUID support. (#47)
• Support JSON columns on all backends through aeson.
• Support JSON lookups (i.e. SELECT json_column.some_property FROM ...) on PostgreSQL.
• Multi-column primary key and uniqueness constraint support. (#25, #99)
• Switch to PostgreSQL binary protocol. (#18)
• Prevent dangerous user-defined SQL result instances.
• Expose backend internals through Database.Selda.Backend.Internal. (#109)
• Expose SQLite connection handle. (#101)
• Make MonadSelda more amenable to connection pooling. (#108)
• Add weakly auto-incrementing primary keys. (#94)
• Move compile* functions to Database.Selda.Debug.
• Remove half the tuple convenience functions.
• Remove in-process cache. (#117)
• Officially support GHC 8.6, 8.8 (SQLite only until postgres dependencies catch up with 8.8).
• Drop support for GHC 7.10. (#118)
• Manual (i.e. non record label) selectors are no longer exported by default; import Database.Selda.MakeSelectors is you need them. (#118)
• Update toolchain to use v2-style cabal commands.
• Fix date/time types for PostgreSQL. (#104)
• Fix bug when migrating tables with indexes. (#107)
• Misc. smaller bug fixes.