Re: [qooxdoo-devel] SQL Backend & transport

2007-05-28 Thread derrell . lipman
"Christian Boulanger" <[EMAIL PROTECTED]> writes: > Hello List, > > I have a backend design question for people who do transport and security > stuff. I have so far coded the backend in PHP, which I know well. I don't > know any other server-side language well and have no time to learn > anything

Re: [qooxdoo-devel] SQL Backend & transport

2007-05-26 Thread Christian Boulanger
Thinking about it a bit further, I realized the flaw in my design. Even though MySQL, for example, has a user and access right management built-in, these rules are not sophisticated enough to differentiate between legitimate and illegitimate sql querys. Even though a user might have the right t

Re: [qooxdoo-devel] SQL Backend & transport

2007-05-26 Thread Christian Boulanger
Hello Siarhei, thank you for your thoughts. I know MVC from CakePHP (which is a PHP equivalent of RoR) but it was exactly the problem that Cake forced me to use MVC. With qooxdoo I do not need the "V" (View) part at all since in CakePHP, it is based on the HTML-page way of doing things. The way

Re: [qooxdoo-devel] SQL Backend & transport

2007-05-26 Thread Siarhei Barysiuk
Hello, Exists a structure of application called MVC (exactly it's pattern in software architecture). MODEL-VIEW-CONTROLLER Model represent data in your Database. View renders this data. Controller processes user requests, changes data(model) and provides data to view. It's a good architecture. Vie

Re: [qooxdoo-devel] SQL Backend & transport

2007-05-26 Thread Christian Boulanger
... an additional advantage would be that the same application would work with a variety of backends without any change. I was searching google to see if there is some project already that does direct access to sql database via a javascript "active record" objects, but have not found anything. Do

[qooxdoo-devel] SQL Backend & transport

2007-05-26 Thread Christian Boulanger
Hello List, I have a backend design question for people who do transport and security stuff. I have so far coded the backend in PHP, which I know well. I don't know any other server-side language well and have no time to learn anything new. My qooxdoo application mainly needs data from a sql data