# Revision history for Selda


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