This package provides type classes to allow backends to implement
SQL DDL support for beam. This allows you to use beam syntax to
write type-safe schema generation code.
The package also provides features to introspect beam schemas,
and support for automatic generation of migrations in SQL and
Haskell formats.
This is mostly a low-level support library. Most often, this
library is used to write tooling to support DDL manipulation in
your project, or to enable migrations support in beam backends.
Changes
0.5.5.0
Added features
Added support for foreign key constraints:
New ForeignKeyAction datatype representing possible actions when updating
or deleting a row with referencing foreign keys.
The IsSql92TableConstraintSyntax typeclass now has an additional method,
foreignKeyConstraintSyntax, for constructing foreign key constraint syntax.
Introduce addTableForeignKey for declaring new foreign key constraints.
Added support for temporary tables:
The BeamHasTempTables typeclass is used for backends to emit
CREATE TEMPORARY TABLE syntax.
The runCreateTempTable command allows creating a temporary table.
The returned table entity can be used in queries like any other table.
Bug fixes
Fix an issue in which beam-migrate would fail to migrate a unique index
to a non-unique index or vice-versa.
Fixed an issue in which the migration solver could end up taking an
exponentially long time to conclude that migration isn’t possible.
0.5.4.0
Added features
Added support for declaring secondary indices on tables. User API is the
addTableIndex function, selectorColumnName and foreignKeyColumns helpers.
Backend support goes through new IsSql92CreateDropIndexSyntax (which carries
a per-backend Sql92CreateIndexOptionsSyntax type family) and
IsSql92UniqueIndexSyntax (for index uniqueness constraints).
Updated dependencies
Updated the upper bound on parallel to include parallel-3.3.0.0
Updated the upper bound on time to include time-1.14
0.5.3.2
Dependencies
Removed explicit dependency on ghc-prim, which was not used directly.
Updated the upper bound to include containers-0.8.
0.5.3.1
Bug fixes
Removed the IsString instance for DatabaseSchema, which allowed for the use of database schemas that did not exist.
0.5.3.0
Added features
Added support for creating database schemas and associated tables with createDatabaseSchema and createTableWithSchema, as well as dropping schemas with dropDatabaseSchema (#716).
0.5.2.1
Added features
Loosen some version bounds
0.5.2.0
Added features
IN (SELECT ...) syntax via inSelectE
0.5.1.2
Added features
Aeson 2.0 support
0.5.1.1
Added features
GHC 9.2 and 9.0 support
0.5.1.0
Added features
Expose IsNotNull class
Bug fixes
Order log entries when verifying migration status
0.5.0.0
Interface changes
Removed instances for machine-dependent ambiguous integer types Int and Word
Require MonadFail for BeamMigrationBackend
Added features
GHC 8.8 support
checkSchema: Like verifySchema, but detects and returns unexpected
predicates found in the live database
Bug fixes
Map Int16 to smallIntType instead of intType
Suppress creation of primary key constraints for tables with no primary keys
0.4.0.0
0.3.2.0
Added haskellSchema shortcut
0.3.1.0
Add Semigroup instances to prepare for GHC 8.4 and Stackage nightly
0.3.0.0
Re-introduce backend parameter as Database type class
Move beam migration log schema to beam-migrate, since many
applications will want to easily manage a database using the
haskell-based migrations
Add bringUpToDate and bringUpToDateWithHooks to
Database.Beam.Migrate.Simple, which can be used to bring a
database up to date with the given migration.
