Re: [flexcoders] Need Suggestions for database application.
Raja S Patil wrote: Hi Raja, I am using Symfony framework as the php application layer to serve XML to the flex front end. It allows an easy way to duplicate the site with an Ajax/HTML alternative front end. Symfony achieves database abstraction through and internal component ( i believe it is Creole but not 100%). in any case changing database vendor is a one line switch. I have only used it with MySQL but know that it works with many others. Scalability shouldn't be a problem with symfony. Have a look at the projects built with it http://trac.symfony-project.org/wiki/ApplicationsDevelopedWithSymfony. Regards Lee Button riaCoding how u are using it wrt Flex application and how database abstraction is achieved in Symphony ? To best of my knowledge only persistence is to be handled by PHP server and in a very fast browse of website i could not locate any information about handling persistence. I feel that Flex application will need data to/fro from server either in XML format or in form of data objects rest of the things will be taken care by Serverside framework. Off course performance also a factor to be considered. Have u tested it on multiple dbms ? Thanks Once again and best regards. Raja -- View this message in context: http://www.nabble.com/Need-Suggestions-for-database-application.-tp23071392p23279333.html Sent from the FlexCoders mailing list archive at Nabble.com.
Re: [flexcoders] Need Suggestions for database application.
Hi Raja, I have been searching around for a while on different setups for flex and have recently been using the following: A Flex UI with symfony framework on php5.2.8 on MySQL database. Although I have only been trying out the symfony framework for a while it appears very powerful and would meet your criteria of using multiple database vendors. There are also some great tutorials on their site www.symfony-project.org Regards, Lee riaCoding Raja S Patil wrote: 1 The application should be independent of Backend database. i.e. it should be able to use any of Oracle, MS-SQL, MySQL, PostgreSQL, Firebird as backend. 2 The business logic should move from Stored procedures to some middle layer i.e. to Application server. 3 It should be possible to separate application server and database server i.e. application server and Database servers can be at different physical locations or they can reside on same server. 4 the communication between database server-application server and application Server-Client should be secured one or may be encrypted so that man in middle is not able to modify the data . Thanks for reading this long post and best regards raja -- View this message in context: http://www.nabble.com/Need-Suggestions-for-database-application.-tp23071392p23100077.html Sent from the FlexCoders mailing list archive at Nabble.com.
[flexcoders] Need Suggestions for database application.
Hello, We are in process of converting a Desktop C/S Database application to web application. Till date we have not developed any web application. We have evaluated Flex as development platform and created a small pilot application without data access and the respective client has admired general features provided by Flex. Now we would like to evaluate data access part of Flex. Now what we need is help on designing data access part of application. Since this is First Adventure for Both of us (Client and We) there is no legacy system so we are starting from scratch. Can somebody suggest how we should proceed so that there are no/minimum problem in production. At present the application being ported to we is written in Delphi with Firebird as Database Engine. Most of the business logic is stored in Stored Procedures and runs on Linux, Win XP, Win 98 as data base servers. We dont mind on time to be taken for development or efforts in developing/implementing but we expect to achieve following goals. 1 The application should be independent of Backend database. i.e. it should be able to use any of Oracle, MS-SQL, MySQL, PostgreSQL, Firebird as backend. 2 The business logic should move from Stored procedures to some middle layer i.e. to Application server. 3 It should be possible to separate application server and database server i.e. application server and Database servers can be at different physical locations or they can reside on same server. 4 the communication between database server-application server and application Server-Client should be secured one or may be encrypted so that man in middle is not able to modify the data To best of our knowledge we have got a rough layout as follows. To start with have spring as application server with hibernate integration for data access. Then Flex application will communicate with application server through BlazeDS. Can somebody suggest us a better way of doing it so that above goals are achieved and efforts are minimised for both development/implementation and maintenance. Thanks for reading this long post and best regards raja