Restler DB

[dragoninfrontofme]

hi there,

this questions not related with any bugs, i just want to know whether someone can advise regarding the Database query or database execution.
Currently i'm building REST webservice apps using Restler. is there any recommendation framework for communication with Database (Insert, Update, Delete) or maybe restler already come with this functionality / classes.

Thank you
Lucius

[Arul-]

Restler can work with any database layer so we did not provide any explicitly

RedBean

I have used Redbean php successfully for one of my clients, it is a light weight ORM that creates tables and columns on the fly as they are needed and makes SQL feel very much like NoSQL counter parts

CodeIgniter DB

In another project I had to help 2 developers using codeigniter and rest server plugin to move to restler. In order to make them feel as home I used codeigniter db, which is part of codeigniter but David Dula had removed all the dependencies and made it standalone. I used Stand Alone CI Activerecord - Based on 2.1.0 and made some improvements. I created a base class called API and created an instance of the db object as the db property so that the code we write in code igniter model such as the following can be copy pasted into restler api class as is

$query = $this->db->get('object',1,0);
$row = $query->result_array();
return $row;

Propel

It is an open-source Object-Relational Mapping (ORM) for PHP5. It allows you to access your database using a set of objects, providing a simple API for storing and retrieving data.

I have tried propel some time back. It has some initial learning curve understanding the configurations and all but well worth it

Doctrine 2

A Object Relational Mapper and the Database Abstraction Layer. I have heard from many that it is good. I havent tested it personally myself yet. It is also making use of Annotations similar to restler, I just need to check and make sure these annotations do not conflict

[nickl-]

Respect/Relational

Respect/Relational at the risk of sounding biased I will refrain from personal motivations and only quote the key points as per the documentation.

• Near-zero configuration.
• Fluent interfaces like $mapper->author[7]->fetch();
• Adapts itself to different database styles.
• Records are handled as Plain Data Object.
• No need to generate a thing, nada, nothing, zilch, bugger all!

[dragoninfrontofme]

Hi @Arul- and @nickl-

Thank you very much with the recommendation, i will take a look with the list :)

Thank you

[Arul-]

@dragoninfrontofme keep note of the updates at https://github.com/Luracast/Restler/wiki/Restler-3:-Datasbase

[dragoninfrontofme]

Hi Arul,

Great, Thanks :)