Auth library for PostgreSQL database

[eluser]kamik[/eluser]
Hi,
I am new to CodeIgniter, I am looking for some library like AU or Redux but for Postgres.

I need basic Auth methods (not for blog or anything similar=no captcha, no email activation and etc., just log in, log out, create user, drop user, who logged ...) and if there is done basic backend it will by fantastic.


Best regards

J.K.

[eluser]matt.asbury[/eluser]
Hi Kamik

The beauty of codeigniter is that it can switch between database types easily (if an application is developed correctly). Look at the source code for those two libraries you mentioned and you'll probably notice that they query the database using codeigniter functions (rather than classic PHP ones). Look for things like:

Code:

$this->db->select();
$this->db->from();
$this->db->where();
$this->db->get();

All you need to do is apply the plugin as specified in the associated instructions and set your database driver to postgre in the database.php file in system/application/config/

[eluser]kamik[/eluser]
there is something like this:
$sql = "CREATE TABLE `aurole` (`id` int(11) NOT NULL auto_increment,`name` varchar(50) default NULL,PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8";

$this->db->query($sql);

I am not so familiar with MySQL to rewriteing this MySQLs SQLs, there are many others for create tables, selects and etc. In some other libraries I saw that in requirements was MySQL, so I thing that it is the same like this. I am looking good simple Auth library where do not matter on kind of database like you posted. There is many of them, but nothing looks good and when it looks good, there are MySQL commands ... :-(.

Regards
J.K.

[eluser]matt.asbury[/eluser]
Depending on how many of these queries you would need to amend, I don't think it would be too difficult for you to understand the logic. I would recode them using codeigniter's database forge class (http://ellislab.com/codeigniter/user-gui...forge.html). In this example the logical entry would be:

Code:

$this->load->dbforge();
$this->dbforge->add_field('id'); //automatically create an int[9] auto increment primary key field
$this->dbforge->add_field('name varchar(50) NULL');
$this->dbforge->create_table('aurole');

This will give you code that will be portable between any CI supported database.

[eluser]kamik[/eluser]
Yeah, it is good idea ... I am going on it.