phinx | PHP Database Migrations for Everyone | Data Migration library

 by   cakephp PHP Version: 0.13.4 License: MIT

kandi X-RAY | phinx Summary

kandi X-RAY | phinx Summary

phinx is a PHP library typically used in Migration, Data Migration, PostgresSQL applications. phinx has no bugs, it has no vulnerabilities, it has a Permissive License and it has medium support. You can download it from GitHub.

PHP Database Migrations for Everyone

            kandi-support Support

              phinx has a medium active ecosystem.
              It has 4348 star(s) with 904 fork(s). There are 138 watchers for this library.
              It had no major release in the last 12 months.
              There are 131 open issues and 883 have been closed. On average issues are closed in 376 days. There are 2 open pull requests and 0 closed requests.
              It has a neutral sentiment in the developer community.
              The latest version of phinx is 0.13.4

            kandi-Quality Quality

              phinx has 0 bugs and 0 code smells.

            kandi-Security Security

              phinx has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.
              phinx code analysis shows 0 unresolved vulnerabilities.
              There are 0 security hotspots that need review.

            kandi-License License

              phinx is licensed under the MIT License. This license is Permissive.
              Permissive licenses have the least restrictions, and you can use them in most projects.

            kandi-Reuse Reuse

              phinx releases are available to install and integrate.
              Installation instructions, examples and code snippets are available.
              phinx saves you 4931 person hours of effort in developing the same functionality from scratch.
              It has 10621 lines of code, 1009 functions and 78 files.
              It has high code complexity. Code complexity directly impacts maintainability of the code.

            Top functions reviewed by kandi - BETA

            kandi has reviewed phinx and discovered the below as its top functions. This is intended to give you an instant insight into phinx implemented functionality, and help decide if they suit your requirements.
            • Print the migration status .
            • Returns the instructions to alter a column .
            • Resolve conflicts .
            • Parse a default value .
            • Set the data domain .
            • Get PHinx type
            • Load a configuration file .
            • Parse dsn from dsn
            • Get inverted commands .
            • Resolve migration path .
            Get all kandi verified functions for this library.

            phinx Key Features

            No Key Features are available at this moment for phinx.

            phinx Examples and Code Snippets

            No Code Snippets are available at this moment for phinx.

            Community Discussions


            Fetch data for a select query in yii migrations
            Asked 2021-May-12 at 14:01

            I am creating a parent child table using yii migration where there is a foreign key on the child table. I tried using execute but that did not help me fetching the data needed. Is there a way I can query the parent table and insert the parent id on the child table as a foreign key? Something like fetch()/fetchAll() that is used inside phinx migrations.



            Answered 2021-May-11 at 22:38


            MySQL: How do you query on a compound-primary-key? Specifically, a NOT IN query?
            Asked 2020-May-26 at 18:48

            I have a comment table and a comment_edit table, as well as olddb_edit. Simplified, the relevant table looks like this:



            Answered 2020-May-26 at 18:48

            Never mind, I figured it out myself while formulating the question. I'll post the answer anyway, for others with a similar question.

            First, vanilla-MySQL. It's as intuitive as you would think if you break up the NOT IN (imo):



            Cakephp 4 Windows Installation Issues
            Asked 2020-Apr-14 at 20:38

            I am running into composer/installation errrors on wamp64 setup on Windows 10... had this working previously on older app but now starting new app on 4.0.3 and running into dependency issues

            Below is output - Any thoughts on why it's not finding any matching packages? the "myapp" folder is created and cakephp source is copied but then a number of dependencies show "no matching package found"

            Can these packages be ignored? some, such as migrations fall under "require" in the composer.json I have tried both the below command and composer create-project --prefer-dist "cakephp/app:^4.0" myapp



            Answered 2020-Apr-14 at 20:38

            Installation issues turned out to be combination of things. First appears to be a reference to old package in cakephp's composer.json as noted by ndm here

            second issue was due to issue with php 7.4.0 and the STNDIN not allowing for a response and throwing exception from composer as noted here and on stack overflow

            Thanks for comments to help troubleshoot.



            Phinx migration error, "Could not find class" but looking in the correct file?
            Asked 2020-Mar-05 at 12:30

            I'm trying to run database migrations using the phinx library for a Phalcon framework example project called 'Vokuro' and I'm getting this error. The file directory is correct so I'm clueless as to why this is happening.




            Answered 2020-Mar-05 at 12:30

            Because you are using your own config file:



            How i can getDatabaseName in Phinx?
            Asked 2020-Feb-20 at 10:11

            I am using Phinx to migrate.

            Now i want to use the name of my database in some special query in Migration file, the database name is specified depending on the enviroment in the phinx-config file.



            Answered 2020-Feb-20 at 10:09

            You can access environment config params like $this->getAdapter()->getOption(''); inside your migration:


            Community Discussions, Code Snippets contain sources that include Stack Exchange Network


            No vulnerabilities reported

            Install phinx

            See version and branch overview for branch and PHP compatibility.


            Phinx natively supports the following database adapters:.
            Find more information at:

            Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items

            Find more libraries
          • HTTPS


          • CLI

            gh repo clone cakephp/phinx

          • sshUrl


          • Stay Updated

            Subscribe to our newsletter for trending solutions and developer bootcamps

            Agree to Sign up and Terms & Conditions

            Share this Page

            share link

            Consider Popular Data Migration Libraries

            Try Top Libraries by cakephp


            by cakephpPHP


            by cakephpPHP


            by cakephpPHP


            by cakephpPHP


            by cakephpPHP