yii-user-management

yii-user-management copied to clipboard

Is there any way to support postgresql installation? I've checked and it looks like every script uses the mysql syntax. I tried to change the basic installation just for user / translation tables and even if I got them working and the installation succesful, It didn't work. Any plan for this?

Actually there are no plans for supporting postgresql. I think for someone interested in using yum in postgres it would not be so difficult since ActiveRecord is used in most of the places. Only the installer needs to be rewritten or the sql installation dump needs to be converted to postgresql syntax.

I am also very much interested in PostgreSQL support. I have previously converted the SQL structure to a PostgreSQL format, which I can provide to anyone interested. That said, would you be interested if I were to rewrite the installer to work across all databases? I believe that Yii is able to support this, so it shouldn't be too difficult to achieve. Having previously used YUM in a PostgreSQL environment, once it was installed and running there were very few issues, so most of the work required is in the installer.

Postgresql support isn't actually hard to implement. Thanks to yii, In theory, we are independent of the unterlying database system. Only thing that needs to be rewritten is the installer and resolve the small issues, which should be as easy as replacing some custom SQL with AR stuff.

I also think about doing an automatic installation like the absolute awesome audit module [http://www.yiiframework.com/extension/yii-audit-module]/[https://github.com/cornernote/yii-audit-module] does. When yum is in debug mode, it detects if tables are not available and automatically creates them.

I am interested in your pgsql dump file though, if you send it to me i will include it in the yum distribution. Alternatively you can do a pull request. Thanks !

Sounds great! I'll double-check that the file is current and send it to you. I'm also working on converting YumInstallController.php to use constructed queries. I have MySQL, PostgreSQL, Oracle and MS SQL available to test on, so I can ensure smooth installation on all 4 before submitting a pull request for that one. I'll do that and the PgSQL dump separately, if that's OK.

Yes, thats ok! thanks a lot for your efforts.

Greetings, thyseus I'm trying to convert the struture to postgresql and I just saw your commnt, and I wonder if you can send me the structure in posqtgresql that you made please ?, maybe in a pastebin or other service.. Thanks