PHP Tour 2016 Phinx Presentation

Phinx is one of the most popular standalone database migration tools. Learn the basic concepts of Phinx with its creator Rob Morgan. This presentation covers adding it to a project, creating new migrations and then executing them, . You are also exposed to more advanced features of Phinx and everyday use cases.

1. Rob Morgan
@_rjm_
#phinx #php #phptour

2. What is a Database or
Schema Migration?

3. “A schema migration is performed on a
database whenever it is necessary to update
or revert that database's schema to some
newer or older version. Migrations are
performed programmatically by using a
schema migration tool.”

4. source: https://en.wikipedia.org/wiki/Schema_migration

6. What is Phinx?
“Phinx is a tool that allows you to migrate
your database schema over time”

7. Rob Morgan
•Creator & Lead Developer of Phinx
•Writing PHP for almost 15 years
•Email: [email protected]
•https://robmorgan.id.au
@_rjm_

8. asd
Australia

10. Brief History
•Open Sourced in 2012 under the MIT License
•38 Releases to Date
•1.2 million Downloads and 115+ Contributors
•Used in CakePHP 3.0.0
•Built on top of Symfony Components (and only 3)

11. Features
•Write database migrations using PHP code
•Migrate up and down
•Seed data after database creation
•Take advantage of SCM features such as branching
•Integrate with any app
•Get going in less than 5 minutes

12. Supported Databases

13. Test Matrix
MySQL PostgreSQL SQLite SQL Server
PHP 5.4 ❌ ❌ ❌ ❌
PHP 5.5 ❌ ❌ ❌ ❌
PHP 5.6 ❌ ❌ ❌ ❌
PHP 7 ❌ ❌ ❌ ❌
HHVM ❌

14. Why did I write Phinx?

16. We started to look for
better solutions

17. Phing with DbDeploy

18. We developed on Mac &
Linux, but deployed on
Windows

20. Why Should I Use
Phinx?

21. Phinx is Fast

22. It requires PHP 5.4

23. Production Ready

24. How can I install Phinx?
•Pear
•Composer
•Build a Phar package (see Github)

25. How can I install Phinx?
•Pear
•Composer
•Build a Phar package (see Github)

26. It’s a command line
application (although it does
contain a web application)

27. $ vendor/bin/phinx

29. Creating a migration

30. $ vendor/bin/phinx create CreatePostsTable

31. Phinx by Rob Morgan - https://phinx.org. version 0.5.3
using config file ./phinx.yml
using config parser yaml
using migration path /Users/robbym/Code/phinx/db/migrations
using seed path /Users/robbym/Code/phinx/db/seeds
using migration base class Phinx\Migration\AbstractMigration
using default template
created ./db/migrations/20160309162303_create_posts_table.php

32. Phinx by Rob Morgan - https://phinx.org. version 0.5.3
using config file ./phinx.yml
using config parser yaml
using migration path /Users/robbym/Code/phinx/db/migrations
using seed path /Users/robbym/Code/phinx/db/seeds
using migration base class Phinx\Migration\AbstractMigration
using default template
created ./db/migrations/20160309162303_create_posts_table.php

33. Best Practises
•Write environment agnostic code
•Version control your migrations
•Enforce default values in the migrations
themselves
•Avoid custom SQL if possible
•Use the change method by default

34. Reversible Migrations

37. Only some methods
can be reversed!

38. createTable
renameTable
addColumn
renameColumn
addIndex
addForeignIndex

39. Seed Command

40. $ vendor/bin/phinx seed:create UserSeeder
$ vendor/bin/phinx seed:run -e development

42. Real World Use Case

43. Let’s pretend our Customer
wants us to build a new
web application

44. The Customer
•He wants a competitor to Wordpress
•Needs it tomorrow
•Willing to pay alot some money

46. Phinx can help!

(but not do everything)

47. But first we must
install it…

48. Installing via
Composer

49. # first require Phinx
$ php composer.phar require robmorgan/phinx
# then install it including the dependencies
$ php composer.phar install

51. Creating a Migration

54. What’s coming in
Phinx 0.6.0?

55. Docker Support?

56. # setup your project
$ docker run --rm -v $(pwd):/app robmorgan/
phinx init
# create a migration
$ docker run --rm -v $(pwd):/app robmorgan/
phinx create MyFirstMigration
# migrate your db
$ docker run --rm -v $(pwd):/app --link db:db
robmorgan/phinx migrate -e development

57. Lightweight ORM

58. API Freeze towards
1.0

59. What about the future?

60. Multiple Database
Support

61. Migration Generator

62. Data Transformation

63. Documentation

65. Please Read before
opening an issue!

66. Contributing
•Before you open an issue, search the existing
ones!
•Fixing the documentation is a great place to start
•Read the CONTRIBUTING.md file on Github
•At the end of the day, nobody bites and its only
PHP!

67. Cheers!
•Rob Morgan (@_rjm_)
•https://phinx.org
•https://robmorgan.id.au
Rob Morgan
@_rjm_
#phinx #php #phptour