BSD-3-Clause licensed by Scrive AB
This version can be pinned in stack with:hpqtypes-extras-1.16.4.3@sha256:04a8c473516ca75ca5b66e6fc3785d18d134c6d6472c164fffed3c0ef58f40aa,4786
Module documentation for 1.16.4.3
DatabaseDatabase.PostgreSQLDatabase.PostgreSQL.PQTypes
Depends on 12 packages
(full list with versions ) :
base ,
base16-bytestring ,
bytestring ,
containers ,
cryptohash ,
exceptions ,
extra ,
hpqtypes ,
log-base ,
mtl ,
text ,
text-show hpqtypes-extras
The following extras
for hpqtypes library:
DSL for easy, modular construction of SQL queries.
System for automatic validation and migration of a database schema.
hpqtypes-extras-1.16.4.3 (2023-06-12)
Synchronize timezone of a session with timezone of a database after changing
the latter.
hpqtypes-extras-1.16.4.2 (2023-05-23)
Make order of tables during schema creation irrelevant.
hpqtypes-extras-1.16.4.1 (2023-05-15)
Relax checks around indexes related to the REINDEX
operation.
hpqtypes-extras-1.16.4.0 (2023-04-20)
Add support for the UNION ALL
clause via sqlUnionAll
.
hpqtypes-extras-1.16.3.1 (2023-04-13)
Add support for GHC 9.6.
Fix checkAndRememberMaterializationSupport’s query.
hpqtypes-extras-1.16.3.0 (2023-01-25)
Add support for WITH MATERIALIZED
with backward compatibility.
Add sqlWhereEqualsAny
.
hpqtypes-extras-1.16.2.0 (2022-10-27)
Add support for setting collation method for columns.
hpqtypes-extras-1.16.1.0 (2022-08-02)
Add support for sqlResult
in sqlDelete
.
Add a migration type for modifying columns.
hpqtypes-extras-1.16.0.0 (2022-05-20)
Trigger functions are now part of triggers and have their names generated.
hpqtypes-extras-1.15.0.0 (2022-05-11)
Add support for GHC 9.2.
Drop support for GHC < 8.8.
Add support for triggers and trigger functions.
Allow to specify the operator class of an index column.
hpqtypes-extras-1.14.1.0 (2022-01-11)
Support unmanaged local indexes whose names start with “local_”.
hpqtypes-extras-1.14.0.0 (2021-12-13)
Add support for ON CONFLICT to sqlInsertSelect.
Remove upper bounds from library dependencies.
Remove kRun* and kWhyNot functions.
hpqtypes-extras-1.13.1.0 (2021-11-26)
Add support for including columns in indexes.
hpqtypes-extras-1.13.0.0 (2021-11-08)
Add support for handling lock_timeout during migrations.
Improvements for making no downtime migrations easier to write.
Commiting after each migration was made non-optional.
hpqtypes-extras-1.12.0.1 (2021-10-11)
Add support for log-base-0.11.0.0
hpqtypes-extras-1.12.0.0 (2021-09-29)
Use plain exceptions instead of DBExtraException
hpqtypes-extras-1.11.0.0 (2021-03-29)
Support running with higher table versions in the database than in the code
hpqtypes-extras-1.10.4.0 (2021-02-04)
Generate valid INSERT SELECT query with data modifying WITH clauses
Add DerivingVia helpers for enums
hpqtypes-extras-1.10.3.0 (2020-11-16)
Include LIMIT clause in UNION subqueries of the select
hpqtypes-extras-1.10.2.1 (2020-05-05)
hpqtypes-extras-1.10.2.0 (2020-01-20)
Add support for UNION clause
Add support for GHC 8.8
hpqtypes-extras-1.10.1.0 (2020-01-09)
Add support for ON CONFLICT clause
hpqtypes-extras-1.10.0.0 (2019-11-05)
Implement UuidT
Column Type (#28 ).
Fix sqlValidateCheck and sqlValidateFK
hpqtypes-extras-1.9.0.1 (2019-06-04)
Create composite types automatically only if database is empty
(#24 ).
hpqtypes-extras-1.9.0.0 (2019-05-22)
Extend checkDatabaseAllowUnknownTables
to allow unknown composite
types and rename it to checkDatabaseAllowUnknownObjects
(#22 ).
Remove the Default
instance for ExtrasOptions
; use
defaultExtrasOptions
instead
(#23 ).
hpqtypes-extras-1.8.0.0 (2019-04-30)
Make composite types subject to migration process
(#21 ).
Add a migration type for concurrent creation of an index
(#21 ).
hpqtypes-extras-1.7.1.0 (2019-02-04)
Fix an issue where unnecessary migrations were run sometimes
(#18 ).
hpqtypes-extras-1.7.0.0 (2019-01-08)
Added support for no-downtime migrations
(#17 ):
sqlCreateIndex
is deprecated. Use either
sqlCreateIndexSequentially
or sqlCreateIndexConcurrently
(no-downtime migration variant) instead.
sqlAddFK
is deprecated. Use either sqlAddValidFK
or
sqlAddNotValidFK
(no-downtime migration variant) instead.
API addition: sqlValidateFK
, for validating a foreign key
previously added with sqlAddNotValidFK
.
sqlAddCheck
is deprecated. Use either sqlAddValidCheck
or
sqlAddNotValidCheck
(no-downtime migration variant) instead.
API addition: sqlValidateCheck
, for validating a check
previously added with sqlAddNotValidCheck
.
API addition: sqlAddPKUsing
, converts a unique index to a
primary key.
New Table
field: tblAcceptedDbVersions
.
ValidationResult
is now an abstract type.
ValidationResult
now supports info-level messages in addition to errors.
hpqtypes-extras-1.6.4.0 (2019-02-04)
Fix an issue where unnecessary migrations were run sometimes
(#19 ).
hpqtypes-extras-1.6.3.0 (2018-11-19)
API addition: sqlWhereAnyE
(#16 ).
hpqtypes-extras-1.6.2.0 (2018-07-11)
Support hpqtypes-1.6.0.0.
Drop support for GHC < 8.
hpqtypes-extras-1.6.1.0 (2018-03-18)
Add support for GHC 8.4.
Drop support for GHC 7.8.
hpqtypes-extras-1.6.0.0 (2018-01-25)
Introduce checkPKPresence
to enforce primary keys on all tables supplied to checkDatabase
Introduce an options data type, ExtrasOptions
hpqtypes-extras-1.5.0.1 (2018-01-09)
Changed getDBTableNames
to only schemas explicitly in search path, rather
than an exclusion list. Affects table version and unknown tables checks.
hpqtypes-extras-1.5.0.0 (2017-12-08)
Changed internal representation of PrimaryKey to NubList (#11)
This will break existing PKs set on multiple columns unless they are
alphabetically sorted in the defining list.
hpqtypes-extras-1.4.0.0 (2017-11-24)
Introduced tsvector postgres type and indexing methods GIN and BTree
hpqtypes-extras-1.3.1.1 (2017-07-21)
Now depends on ‘log-base’ instead of ‘log’.
hpqtypes-extras-1.3.1.0 (2017-07-20)
Improved migration order sanity checking (#7).
hpqtypes-extras-1.3.0.0 (2017-05-17)
Add drop table migrations.
Add a test suite.
Improve documentation.
Add option to force commit after every migration.
hpqtypes-extras-1.2.4 (2016-07-28)
Stackage is a service provided by the
Haskell Foundation
│ Originally developed by
FP Complete