sqlx

Written
  • 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 write about tech thoughts, interesting things I've read, and project updates each Thursday.

You can check out a recent issue, or enter your email below to subscribe.