search

thyseus / yii-user-management

a user management module collection for the yii framework
186 stars 122 forks source link

Postgresql support #122

Open fernandojsg opened 11 years ago

fernandojsg commented 11 years ago

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?

thyseus commented 11 years ago

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.

SilverPreece commented 10 years ago

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.

thyseus commented 10 years ago

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 !

SilverPreece commented 10 years ago

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.

thyseus commented 10 years ago

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

kurtjavier commented 10 years ago

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