Home Arrow Icon Knowledge base Arrow Icon Global Arrow Icon Can Blueprint handle schema changes in PostgreSQL
    Laravel Shift Blueprint PostgreSQL schema changes Laravel Blueprint PostgreSQL support database migration custom data types schema management Laravel


Can Blueprint handle schema changes in PostgreSQL


it appears that Laravel Shift Blueprint can handle schema changes in PostgreSQL databases, though there are a few important considerations:

1. PostgreSQL-specific Features: The search results indicate that Blueprint supports some PostgreSQL-specific features, such as custom data types, compression, and using expressions to transform data types during migrations. This suggests that Blueprint can handle more advanced PostgreSQL schema changes.

2. Extensibility: The documentation mentions that Blueprint is designed to be extensible, so it's possible for developers to add support for additional PostgreSQL-specific features if needed.

3. Existing Database Support: One of the search results [4] mentions that Blueprint can be used to change the default schema from "public" to "current" in a PostgreSQL database, indicating that it can work with existing PostgreSQL databases.

4. Laravel Database Support: Since Blueprint is a Laravel-based tool, it inherits the database support provided by the latest version of Laravel, which includes full support for PostgreSQL.

So in summary, while the documentation may not explicitly state PostgreSQL support, the search results suggest that Laravel Shift Blueprint can be used to handle schema changes in PostgreSQL databases, including features like custom data types, compression, and transforming data types during migrations. The extensibility of Blueprint also means that developers can add support for additional PostgreSQL-specific functionality if needed.

Citations:
[1] https://laracasts.com/discuss/channels/laravel/blueprint-laravel-shift
[2] https://laravel-news.com/laravel-shift-blueprint
[3] https://github.com/tpetry/laravel-postgresql-enhanced
[4] https://github.com/reliese/laravel/issues/186
[5] https://laravel.com/api/8.x/Illuminate/Database/Schema/Blueprint.html