Hi all, I discussed with few web developers and raised the question in the forums. According to them, most popular method is to use the php data connections and data objects. In both cases application might fetch the required properties from a file in order to connect to the data source.
So in that case as Manjula has suggested - obtaining the property values via the REST API is feasible, IMO. On Fri, Aug 22, 2014 at 10:22 AM, Manjula Rathnayake <[email protected]> wrote: > Hi Ajanthan, > > On Fri, Aug 22, 2014 at 10:08 AM, Ajanthan Balachandran <[email protected] > > wrote: > >> >> >> >> On Fri, Aug 22, 2014 at 9:53 AM, Manjula Rathnayake <[email protected]> >> wrote: >> >>> Hi all, >>> >>> On Fri, Aug 22, 2014 at 8:41 AM, Dimuthu Leelarathne <[email protected]> >>> wrote: >>> >>>> Hi Madhawa, >>>> >>>> Does PHP have native datasource support? For example[1]. I am -1 on >>>> doing it through Java. We must look at how PHP community does it. First >>>> thing is to see how PHP community uses databases in apps. >>>> >>>> If they do have a native datasource concept we have to use it. If that >>>> is not available second option is using variables and calling registry via >>>> REST APIs. >>>> >>> +1, And AFAIK, web developers keep these variables in a configuration >>> file. This is because they have externalized all the variables which needs >>> to be replaced when they need to deploy in a new environment. If we provide >>> a mechanism to upload a complete configuration instead of property by >>> property, it will make the developer life easier. >>> >> Here there are some concerns, >> how the user going to manage credential for calling the REST api? Are we >> recommending to use config file inside source tree with encrypted password? >> Then there is a problem in sharing the private key between user and the >> server. Mutual ssl also has some limitation.If the user happen to know the >> admin username he can set it in the header and do operation as admin. >> > Good point. We have to go with OAuth based solution, This is REST API > security. We can expose these REST API via API Manager too. > > thank you. > >> >>> thank you. >>> >>> >>>> thanks, >>>> dimuthu >>>> >>>> [1] http://book.cakephp.org/2.0/en/models/datasources.html >>>> >>>> >>>> On Thu, Aug 21, 2014 at 7:17 PM, Manjula Rathnayake <[email protected]> >>>> wrote: >>>> >>>>> Hi Madhawa, >>>>> >>>>> We can keep these variables(string $dsn , string $user , string >>>>> $password) in registry and use registry rest API to get values at runtime. >>>>> So when you promote the application to Test and Production environments, >>>>> application will pick the environment specific values. This will not break >>>>> PHP developer experience as well. >>>>> >>>>> thank you. >>>>> >>>>> >>>>> On Thu, Aug 21, 2014 at 7:00 PM, Madhawa Bandara <[email protected]> >>>>> wrote: >>>>> >>>>>> Any thoughts please? >>>>>> >>>>>> >>>>>> On Tue, Aug 19, 2014 at 8:14 PM, Madhawa Bandara <[email protected]> >>>>>> wrote: >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> Appfactory supports data sources to be defined and be used in the >>>>>>> Java applications. >>>>>>> >>>>>>> In the process of enabling the PHP app type support in Appfactory, >>>>>>> we need to allow users(i.e.developers) to create data sources in >>>>>>> Appfactory >>>>>>> and use them directly inside their PHP applications. >>>>>>> >>>>>>> PHP applications use the odbc_connect ( string $dsn , string $user , >>>>>>> string $password [, int $cursor_type ] ) to connect to a database. >>>>>>> >>>>>>> There are third party libraries that enable Java inside PHP scripts >>>>>>> [1]. >>>>>>> An example for JNDI look-up in inside PHP is in [2]. >>>>>>> >>>>>>> In order to allow data sources to be called directly from the PHP >>>>>>> apps what are the preferable options available? >>>>>>> >>>>>>> You ideas are welcome. >>>>>>> >>>>>>> >>>>>>> [1] - http://php-java-bridge.sourceforge.net/pjb/ >>>>>>> [2] - >>>>>>> http://php-java-bridge.sourceforge.net/pjb/examples/source.php?source=documentClient.php >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Regards, >>>>>>> >>>>>>> *Madhawa Bandara* >>>>>>> Software Engineer >>>>>>> WSO2, Inc. >>>>>>> lean.enterprise.middleware >>>>>>> >>>>>>> Mobile - *+94777487726 <%2B94777487726>* >>>>>>> Blog* - *classdeffound.blogspot.com >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Regards, >>>>>> >>>>>> *Madhawa Bandara* >>>>>> Software Engineer >>>>>> WSO2, Inc. >>>>>> lean.enterprise.middleware >>>>>> >>>>>> Mobile - *+94777487726 <%2B94777487726>* >>>>>> Blog* - *classdeffound.blogspot.com >>>>>> >>>>>> _______________________________________________ >>>>>> Architecture mailing list >>>>>> [email protected] >>>>>> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Manjula Rathnayaka >>>>> Software Engineer >>>>> WSO2, Inc. >>>>> Mobile:+94 77 743 1987 >>>>> >>>>> _______________________________________________ >>>>> Architecture mailing list >>>>> [email protected] >>>>> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >>>>> >>>>> >>>> >>>> >>>> -- >>>> Dimuthu Leelarathne >>>> Architect & Product Lead of App Factory >>>> >>>> WSO2, Inc. (http://wso2.com) >>>> email: [email protected] >>>> Mobile : 0773661935 >>>> >>>> Lean . Enterprise . Middleware >>>> >>>> _______________________________________________ >>>> Architecture mailing list >>>> [email protected] >>>> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >>>> >>>> >>> >>> >>> -- >>> Manjula Rathnayaka >>> Software Engineer >>> WSO2, Inc. >>> Mobile:+94 77 743 1987 >>> >>> _______________________________________________ >>> Architecture mailing list >>> [email protected] >>> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >>> >>> >> >> >> -- >> ajanthan >> -- >> Ajanthan Balachandiran >> Senior Software Engineer; >> Solutions Technologies Team ;WSO2, Inc.; http://wso2.com/ >> >> email: ajanthan <http://goog_595075977>@wso2.com; cell: +94775581497 >> blog: http://bkayts.blogspot.com/ >> >> >> Lean . Enterprise . Middleware >> >> _______________________________________________ >> Architecture mailing list >> [email protected] >> https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture >> >> > > > -- > Manjula Rathnayaka > Software Engineer > WSO2, Inc. > Mobile:+94 77 743 1987 > > _______________________________________________ > Architecture mailing list > [email protected] > https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture > > -- Regards, *Madhawa Bandara* Software Engineer WSO2, Inc. lean.enterprise.middleware Mobile - *+94777487726* Blog* - *classdeffound.blogspot.com
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
