# Revision history for Selda ## 0.5.1.0 -- 2020-01-20 * Support for raw SQL fragments. (#134) * Expose tableName. * Document performance drawbacks of withoutForeignKeyEnforcement. * Fix several bugs validating auto-incrementing PKs. (#133) ## 0.5.0.0 -- 2019-09-21 * 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.0.0 -- 2019-06-02 * 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. ## 0.3.4.0 -- 2018-09-29 * Added convenience functions for working with nullable columns. ## 0.3.3.1 -- 2018-09-04 * DISTINCT should now always return distinct results. * DISTINCT can no longer produce ill-scoped queries. ## 0.3.3.0 -- 2018-09-01 * Ad hoc selectors using OverloadedLabels. * Shorter build times. * Minor API updates and simplifications. ## 0.3.2.0 -- 2018-08-07 * Some aggregates are now nullable. * sum_ on an empty table doesn't crash anymore. * Aggregating over an empty selectValues doesn't crash anymore. ## 0.3.1.0 -- 2018-08-06 * Minor API fix when defining table attributes. ## 0.3.0.0 -- 2018-08-05 * Support for Stack and GHC 8.4. * Precedence fix for selector index (!) operator. * Accept INT and SMALLINT columns in user-created PostgreSQL tables. * Add combinator for turning off foreign key checking. * Rename unsafeRowId/unsafeId to toRowId/rowId. * Add typed row identifiers. * More generic type for sum_. * Table validation against current database. * Basic migration support. * Basic index support. * Remove ad hoc tables; only generic tables from now on. ## 0.2.0.0 -- 2018-04-02 * Support custom column names for generic tables. * Scope safety fix for inner queries. * Better type errors on GHC 8+ for inner queries. ## 0.1.12.1 -- 2018-02-27 * New PPConfig hook for more flexibility when compiling types. ## 0.1.12.0 -- 2018-01-11 * Allow recursive and optional foreign keys. * Allow arbitrary enums in tables, represented as text. * Fix RowID issues for PostgreSQL. * Fix auto-incrementing primary keys for generic tables. ## 0.1.11.2 -- 2017-12-14 * Fix treatment of booleans in PostgreSQL backend. ## 0.1.11.1 -- 2017-10-10 * Fix rare infinite loop bug in in-process cache. ## 0.1.11.0 -- 2017-09-08 * Fix name generation in the presence of isIn over queries. * SELECT DISTINCT support. * Conditional expressions and matchNull. ## 0.1.10.1 -- 2017-08-11 * Fix name generation in the presence of multiple aggregates. ## 0.1.10.0 -- 2017-08-01 * Async exception safety. * Allow MonadSelda instances not built on SeldaT. * Chunk very large insertions on backends that request it (i.e. SQLite). * GHC 8.2 support. ## 0.1.9.0 -- 2017-06-16 * Properly document semantics of order. * Export conditional inserts. * Fix Haste build for backends. ## 0.1.8.0 -- 2017-06-10 * Move SQL pretty-printing config into a single type. * Support for binary blobs. * Support for prepared statements. * Support for connection reuse across Selda computations. * Cleaner and more robust backend API. * Stricter type constraints on comparisons. * Allow limit on inner queries. * Allow inspecting row identifiers. ## 0.1.7.0 -- 2017-05-17 * Add specialized insertUnless upsert variant. * Fix potential race condition in upserts. * Use abstract row identifier type for auto-incrementing primary keys. * Less strict version bounds on dependencies. ## 0.1.6.0 -- 2017-05-07 * Conditional insert ("upsert") support. * Support `SELECT x IN (SELECT ...)` and `SELECT x IN (a, b, ...)` queries. * Explicit inner queries. * Rename `inner` to `innerJoin`, more intuitive behavior for `suchThat`. * Add `from` shorthand for `\s q -> fmap (!s) q`. * Unique and foreign key constraints for generics. ## 0.1.5.0 -- 2017-05-05 * Inner join support. * More sensible names in backend API. * Fix rounding and casts. ## 0.1.4.1 -- 2017-05-04 * Fix cache consistency bug in the presence of multiple databases. ## 0.1.4.0 -- 2017-05-04 * Add uniqueness constraints and foreign keys. ## 0.1.3.3 -- 2017-05-04 * Fix cache invalidation race when using transactions. ## 0.1.3.2 -- 2017-05-01 * Only throw well-documented, Selda-specific exceptions. ## 0.1.3.1 -- 2017-05-01 * More Hackage-friendly README. ## 0.1.3.0 -- 2017-04-30 * Add selectors for non-generic tables. * Allow default insertions on all columns. * More sensible API for LIMIT. * Fix broken SQL being generated for pathological corner cases. * Documentation fixes. ## 0.1.2.0 -- 2017-04-20 * Replace `ยค` with `:*:` in table definitions. ## 0.1.1.1 -- 2017-04-20 * Minor documentation fixes. ## 0.1.1.0 -- 2017-04-20 * Generic tables, queries and mutation. * Select from inline tables. * Tutorial updates. * Minor bugfixes. ## 0.1.0.0 -- 2017-04-14 * Initial release.