This package contains a backend for persistent using the
MySQL database server. Internally it uses the mysql-simple
and mysql packages in order to access the database.
This package supports only MySQL 5.1 and above. However, it
has been tested only on MySQL 5.5.
Only the InnoDB storage engine is officially supported.
Known problems:
This package does not support statements inside other
statements.
Changes
Changelog for persistent-mysql
2.10.2.3
Fix issue with multiple foreign keys on single column. #1025
2.10.2.2
Compatibility with latest persistent-template for test suite #1002
2.10.2.1
Changed persistent-mysql to use ‘utf8mb4’ instead of ‘utf8’ in migrations #980 @charukiewicz
Added constraint= attribute to allow users to specify foreign reference constraint names.
2.10.0
Remove deprecated SomeField type and pattern synonym. Use HandleUpdateCollision type instead and the copyField function instead of SomeField constructor/pattern. #894
2.9.0
Added support for SQL isolation levels to via SqlBackend. [#812]
Fix 832: repsertMany now matches mapM_ (uncurry repsert) and is atomic.
2.8.1
Implemented connPutManySql to utilize batched putMany. #770
2.8.0
Switch from MonadBaseControl to MonadUnliftIO
Fix duplicate migrations when using mediumtext, longtext, mediumblob, longblob, and doubles using a custom precision. #754
– This can be released as a minor change on the next update. Currently persistent-mysql can’t be released because 2.6.2.2 depends on persistent-2.7.2 being released.
The SomeField type was renamed to HandleUpdateCollision and deprecated. Please migrate to using HandleUpdateCollision.
The SomeField constructor was deprecated, and a temporary pattern synonym introduced. Please migrate to using copyField.
2.6.2.2 [UNRELEASED ON HACKAGE]
– This version depends on persistent 2.7.2, which introduced breaking changes and is deprecated on hackage.
Fix ambiguous type errors introduced by persistent-2.7.2#723
Extend the SomeField type to allow insertManyOnDuplicateKeyUpdate to conditionally copy values.
Depend on mysql-simple >= 0.4.3 to fix encoding and decoding of date/time values with fractional seconds (when a column is specified using something like sqltype=TIME(6)). See also #705
Fix behavior of insertManyOnDuplicateKeyUpdate to ignore duplicate key exceptions when no updates specified.
2.6.1
Add functions insertOnDuplicateKeyUpdate, insertManyOnDuplicateKeyUpdate to Database.Persist.MySQL module.
2.6.0.2
Prevent spurious no-op migrations when default=NULL is specified - revised version #672 (which fixes bug #671 introduced by the earlier attempt #641)
2.6
Compatibility for backend-specific upsert functionality.
A lucky contributor could add upsert to the MySQL backend now, i.e.:
INSERT … ON DUPICATE …
2.5
changes for read/write typeclass split
2.3.0.1
Support usign default= for changing the id field type
2.3
Distinguish between binary and non-binary strings in MySQL #451
Previously all string columns (VARCHAR, TEXT, etc.) were being returned from Persistent as PersistByteStrings (i.e. as binary data). Persistent now checks character set information to determine if the value should be returned as PersistText or PersistByteString.
This is a breaking change if your code is relying on a PersistByteString being returned for string-like MySQL values; persistent-mysql itself had several runtime errors that needed to be fixed because of this patch. High-level code dealing purely with PersistEntities should be unaffected.