README.md in strong_migrations-0.6.2 vs README.md in strong_migrations-0.6.3
- old
+ new
@@ -301,12 +301,22 @@
change_column :users, :some_column, :new_type
end
end
```
-One exception is changing a `varchar` column to `text`, which is safe in Postgres.
+A few changes are safe in Postgres:
+- Changing between `varchar` and `text` columns
+- Increasing the precision of a `decimal` or `numeric` column
+- Making a `decimal` or `numeric` column unconstrained
+- Changing between `timestamp` and `timestamptz` columns when session time zone is UTC in Postgres 12+
+
+And a few in MySQL and MariaDB:
+
+- Increasing the length of a `varchar` column from under 255 up to 255
+- Increasing the length of a `varchar` column over 255
+
#### Good
A safer approach is to:
1. Create a new column
@@ -688,7 +698,14 @@
```sh
git clone https://github.com/ankane/strong_migrations.git
cd strong_migrations
bundle install
+
+# Postgres
+createdb strong_migrations_test
bundle exec rake test
+
+# MySQL and MariaDB
+mysqladmin create strong_migrations_test
+ADAPTER=mysql2 bundle exec rake test
```