sqlx

Written 2021-03-19

Migrations
- To update the checksum of a migration when the file changed, you can recalculate the hash
  - cat migrations/FILENAME.sql | openssl dgst -sha384 | cut -d ' ' -f 2
- Then change the checksum for that row in the database:
  - ```
  update _sqlx_migrations 
  	set checksum='\x<the checksum>'
      where version ='<the version>';
```

Thanks for reading! If you have any questions or comments, please send me a note on Twitter. And if you enjoyed this, I also have a newsletter where I send out interesting things I read and the occasional nature photo.