Hi,
Researching the design of a publishing B2B database, cataloguing data objects and files. Require a fast, scalable MySQL/REST Web service for 500+ users with row level permissions/authentication.
MySQL/REST creates local client caches of XML files. Clients connect to local MySQL database or remote partner databases to update XML caches. Clients use python XML/REST calls from C++ applications to query XML. (REST calls available for the client to develop).
Overwhelmed by choice(i'm intermediate/student programmer).
Strengths & weaknesses? Experiences?
------------------------------------------------
MAIN CHOICES:
------------------------------------------------
XAware
http://www.xaware.org
J2EE Spring framework
deployed on web/application server or standalone
eclipse tools
------------------------------------------------
Glassfish application server
http://www.sun.com/software/products/comm_appsrvr/index.xml
JEE5 API
netbeans & eclipse tools
------------------------------------------------
Axis / JDBC
http://ws.apache.org/axis2
deployed on tomcat server or standalone
C(fast) (or J2EE Spring framework)
------------------------------------------------
Apache with PHP 5 DOM
------------------------------------------------
OTHERS:
------------------------------------------------
Apache Struts Rest Module
http://struts.apache.org/
J2EE Spring framework
JSP API
------------------------------------------------
Apache Mod_ndb
http://forge.mysql.com/wiki/ProjectPage_mod_ndb
Direct access to cluster(fast but requires ndb server)
Apache's subrequest API / PHP / Perl scripting
------------------------------------------------
Turbogears
http://www.turbogears.org
python framework
------------------------------------------------
Apache CXF
http://cxf.apache.org
J2EE Spring framework
JAX-WS eclipse tools
------------------------------------------------
REX
http://sourceforge.net/projects/rex-restsqlxmap/
------------------------------------------------
Apache Shindig
http://incubator.apache.org/shindig/
Java and PHP (opensocial API)
------------------------------------------------
http://sourceforge.net/projects/resteasy/ (Java)
------------------------------------------------
http://dev.dschini.org/mysqlsoapserver/ (C++)
--
thanks
rafal
Edited 10 time(s). Last edit at 10/06/2009 06:40AM by rafal kaniewski.