search

jappeace / rentals

self hosted airbnb-like rental unit management
GNU Affero General Public License v3.0
1 stars 0 forks source link

Move over to postgresql and add postgresql-migration for migrations #28

Closed jappeace closed 8 months ago

jappeace commented 8 months ago

we ran into an issue during deploy where our database migration failed due to some default value missing.

https://hackage.haskell.org/package/postgresql-migration

Jan 03 12:47:48 outsource rentals[2602520]: rentals: SQLite3 returned ErrorConstraint while attempting to perform step: NOT NULL constraint failed: listing_backup.cleaning

this was worked around by adding a default value however it's not a reliable long term solution, experience learns that these migrations can be rather complex.