... 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 you know of any projects? (And to save your time: yes, I know that Ruby on Rails is great, but no, I cannot invest the time in learning ruby / RoR right now). Christian > 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 database such as > mysql. I have tried a number of php backends such as CakePHP. I find, > however, that they all introduced unneccessary overhead and I find that > constantly having to switch between client-side javascript and server-side > PHP logic slows me down significantly. > > Since I need the server basically to execute sql queries and deliver the > data, I wonder if it wouldn't make sense to write a generic backend in PHP > and other server-side languages which do nothing except authenticating and > checking incoming sql queries for attacks like injection etc. and passing > them to the chosen SQL backend. The sql engine is most efficient in > processing the queries, it also has a sophisticated user authentication > and access right system built right in - why introducing another layer? > > The goal would be to create an almost direct connection between javascript > and the sql database and to create and manipulate the data model on the > client directly. The JSON-RPC backend could be extended to handle these > requests, so devlopers would not need to write custom code for sql queries > on the server. One then could restrict one's work to javascript coding and > administrating the sql database with a GUI tool. No more PHP, Java, etc... > > Do you see any performance and security problems with this approach? > > Christian > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > qooxdoo-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel > ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ qooxdoo-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/qooxdoo-devel
