[flexcoders] Re: Need Suggestions for database application.
--- In flexcoders@yahoogroups.com, riacoding riacod...@... wrote: 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 I saw this post on InsideRIA that might help as well http://www.insideria.com/2009/04/simple-server-backends-for-fle.html
[flexcoders] Re: Need Suggestions for database application.
Thanks Lee, 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 Well one more avenue, I will consider this too. Just for sec of information can u just briefly mention 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
[flexcoders] Re: Need Suggestions for database application.
Thanks JC for ur response, PHP is good for server-side and there are frameworks that will help you encapsulate database layer so you can easily switch from one db engine to another e.g. MySQL to PGSQL,etc. May I request u to name good ones so that our study minimizes to few ones for suitability. I Guess these will be Hibernate equivalent, are they ? Built in PHP is PHP Data objects library that can help you with this problem as well if you need a thin layer for your database layer. True we searched the links for PDO Steve has given and going to study them in detail for judging its suitability in our project. if u know some more good alternatives plz go ahead and suggest us since we are starting a fresh we dont have constraints. However we will give enough time to finalize the data access layer since that will be a strategic decision for our all future web applications. So we will evaluate thoroughly every short listed framework and technology for suitability in our most of the existing projects which probably might need to be converted into web application. Thanks and best regards. Raja
RE: [flexcoders] Re: Need Suggestions for database application.
There might be a few others in PEAR, but start with PEAR::DB http://pear.php.net/package/DB --Tim From: flexcoders@yahoogroups.com [mailto:flexcod...@yahoogroups.com] On Behalf Of raja_s_patil Sent: Friday, 17 April 2009 4:07 PM To: flexcoders@yahoogroups.com Subject: [flexcoders] Re: Need Suggestions for database application. Thanks JC for ur response, PHP is good for server-side and there are frameworks that will help you encapsulate database layer so you can easily switch from one db engine to another e.g. MySQL to PGSQL,etc. May I request u to name good ones so that our study minimizes to few ones for suitability. I Guess these will be Hibernate equivalent, are they ? Built in PHP is PHP Data objects library that can help you with this problem as well if you need a thin layer for your database layer. True we searched the links for PDO Steve has given and going to study them in detail for judging its suitability in our project. if u know some more good alternatives plz go ahead and suggest us since we are starting a fresh we dont have constraints. However we will give enough time to finalize the data access layer since that will be a strategic decision for our all future web applications. So we will evaluate thoroughly every short listed framework and technology for suitability in our most of the existing projects which probably might need to be converted into web application. Thanks and best regards. Raja
[flexcoders] Re: Need Suggestions for database application.
Thanks Tim Rowe There might be a few others in PEAR, but start with PEAR::DB http://pear.php.net/package/DB We will search there as quick as possible. Can u tell us more about security and performance issues if there are any, in adopting PHP as server side technology ? Thanks once again and best regards Raja
[flexcoders] Re: Need Suggestions for database application.
Just remove the dot from the end of the link and it will work. The IDE I like is from Zend (The makers of the PHP engine). Funnily enough it's the previous version (5.5). I tried the latest version and don't really like it as much. I know some people who swear by PhpED (http://www.nusphere.com/) and others who swear by Komodo (http://www.activestate.com/komodo/). There are others out there as well including the PHP project for Eclipse. The PHP book I like the best (And the one that I learned a lot from is PHP and MySQL Web Development (http://www.amazon.com/PHP-MySQL-Development-Developers-Library/dp/0672329166/ref=pd_lpo_k2_dp_k2a_2_txt?pf_rd_p=304485601pf_rd_s=lpo-top-stripe-2pf_rd_t=201pf_rd_i=067232525Xpf_rd_m=ATVPDKIKX0DERpf_rd_r=18CXNPJKPD3QQ9YEZM5F) --- In flexcoders@yahoogroups.com, raja_s_patil kpr.rspa...@... wrote: Thanks Steve, PHP 6 is not out yet and won't be for a while. The latest Release Candidate is 5.3 and latest stable is 5.2.9. I am using 5.2.3 on Red Hat Linux. For PDO, check out http://us.php.net/manual/en/book.pdo.php. This Link dont work, I think its not complete since ends with a . (dot) For WebORB check out http://www.themidnightcoders.com/products.html I have downloaded and I think I with a new Ball and Chain which will keep me tied to a place for a while. Well I will be back after few days since Flex data connectivity is a altogether new to us so we try to develop a pilot application and come back again with some issues if any. We have to learn PHP also. I found some good PHP books in local store here which we will buy today. BTW can u suggest some good PHP IDE, if there is any ? Thanks once again and Best Regards Raja
Re: [flexcoders] Re: Need Suggestions for database application.
I actually use PDT: http://www.eclipse.org/pdt/
Now the great thing about this is that I use it as my base and use Flex
Builder Eclipse plugin. So you're doing PHP and Flex in 1 place. I'm not
sure how you want to communicate with the PHP. Personally I like using
URLLoader. There are many other ways to consume data (AMF, WebServices).
I personally prefer to use XML because E4X gives you so much power on
filtering and manipulating data on the client end. Here is the function
I use for retrieving XML:
import flash.errors.IOError;
import flash.net.URLLoader;
import flash.net.URLVariables;
public function loadXML(url:String, vars:URLVariables,
completeFunction:Function):void {
var loader:URLLoader = new URLLoader();
var req:URLRequest = new URLRequest(url);
if (vars != null) {
req.data = vars;
}
req.method = URLRequestMethod.POST;
loader.addEventListener(complete, completeFunction);
loader.addEventListener(IOErrorEvent.IO_ERROR, ioErrorHandler);
loader.load(req);
}
public function ioErrorHandler(event:IOError):void {
trace(event.message);
}
It just cuts down the rest of my code in other places. All you have to
do then is have your result function specified for example:
public function gotData(event:Event):void {
var xmlResult:XML = XML(event.target.data);
}
[flexcoders] Re: Need Suggestions for database application.
Thanks Deane Venske and steve for ur valuable guidance, Now the data access ideas are taking some shape. now we have to study PHP first then the PDOs and finally the webORB. As far as PHP IDE is concerned we have to use Some open source solution initially till budget gets approved then we can think of commercial product.But by that time to develop pilot project I think its OK. I also read few threads about PHP vs JAVA as middle tier and found that PHP is not altogether rejected but almost everybody has agreed that its easy to learn, code and development is much faster compared to Java. Exactly this is what is expected from a developer, a fast response. We have decided that initially we will develop our first project with PHP as middleware and if we face some serious probles regarding security, scalability and performance we will think of Java middleware and have taken our client also in confidence he too have indicated consent to this idea. So this is the story at this moment and we are starting to read PHP from tomorrow may a week or two will be required to get things atleast going in PDO and webORB way meanwhile I have question about the third aspect of application i.e. Reporting for that I will open up a fresh thread Hope u ppl also contribute to that also. Thanks once again for sharing experience and taking us in right direction. I would like to express a sincere gratitude to all of you on behalf of our team. Raja
[flexcoders] Re: Need Suggestions for database application.
--- In flexcoders@yahoogroups.com, raja_s_patil kpr.rspa...@... wrote: (Snip) 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 None of these have anything to do with Flex. It all depends on the middleware you decide to use. In my case, I use PHP connecting to MySQL databases located on multiple different servers. I use WebORB as my AMF de/serializer which also has an option for secure data transfer. 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. That is definitely one way to do it. Another way would be with something like WebORB. They have a solution for .NET, Java, PHP, ColdFusion and Rails. HTH. Steve
[flexcoders] Re: Need Suggestions for database application.
Thanks Steve and Deane Venske for a valuable suggestion, I would like to take ur suggestions and study it further in details i.e. with a hands on experience before we adopt it in the project. Its nice that Deane Venske has past experience in delphi so his opinion is valuable for us. Well Deane Venske I would like to know more about PHP and PDO can u suggest me some study material and links so that it could save some time us. BTW Can u give us some guide line for having a Database independent application. Which PHP u are using 5 or latest 6 ? What u would like suggest us 5 or 6 ? Right now we have installed WAMP (Windows, Apache, MySQL PHP) and Flex builder. Our training resources are Lynda Essential, Beyond basics and Total training Flex 3. about 2/3 books on Flex and action script, and off course this list is a very valuable resource. last minute question, can Delphi PHP be helpfull ? thanks once again and best regards Raja
[flexcoders] Re: Need Suggestions for database application.
PHP 6 is not out yet and won't be for a while. The latest Release Candidate is 5.3 and latest stable is 5.2.9. I am using 5.2.3 on Red Hat Linux. For PDO, check out http://us.php.net/manual/en/book.pdo.php. For WebORB check out http://www.themidnightcoders.com/products.html Steve --- In flexcoders@yahoogroups.com, raja_s_patil kpr.rspa...@... wrote: Thanks Steve and Deane Venske for a valuable suggestion, I would like to take ur suggestions and study it further in details i.e. with a hands on experience before we adopt it in the project. Its nice that Deane Venske has past experience in delphi so his opinion is valuable for us. Well Deane Venske I would like to know more about PHP and PDO can u suggest me some study material and links so that it could save some time us. BTW Can u give us some guide line for having a Database independent application. Which PHP u are using 5 or latest 6 ? What u would like suggest us 5 or 6 ? Right now we have installed WAMP (Windows, Apache, MySQL PHP) and Flex builder. Our training resources are Lynda Essential, Beyond basics and Total training Flex 3. about 2/3 books on Flex and action script, and off course this list is a very valuable resource. last minute question, can Delphi PHP be helpfull ? thanks once again and best regards Raja
[flexcoders] Re: Need Suggestions for database application.
Thanks Steve, PHP 6 is not out yet and won't be for a while. The latest Release Candidate is 5.3 and latest stable is 5.2.9. I am using 5.2.3 on Red Hat Linux. For PDO, check out http://us.php.net/manual/en/book.pdo.php. This Link dont work, I think its not complete since ends with a . (dot) For WebORB check out http://www.themidnightcoders.com/products.html I have downloaded and I think I with a new Ball and Chain which will keep me tied to a place for a while. Well I will be back after few days since Flex data connectivity is a altogether new to us so we try to develop a pilot application and come back again with some issues if any. We have to learn PHP also. I found some good PHP books in local store here which we will buy today. BTW can u suggest some good PHP IDE, if there is any ? Thanks once again and Best Regards Raja
[flexcoders] Re: Need Suggestions for database application.
PHP is good for server-side and there are frameworks that will help you encapsulate database layer so you can easily switch from one db engine to another e.g. MySQL to PGSQL,etc. Built in PHP is PHP Data objects library that can help you with this problem as well if you need a thin layer for your database layer. JC --- In flexcoders@yahoogroups.com, raja_s_patil kpr.rspa...@... wrote: 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
