Don't worry I'm not bothered. The only misunderstanding is that mine is not GAE specific. Its REST API can be (and has been) called from other languages (Matlab, R, Perl), as well as from the command-line (curl, wget). Now the JSON output by the Google Java Library is kind of hard to consume (its meant to be used by Google's javascript visualization library), but we are looking at providing alternate JSON outputs, specifically to be used by a different visualization library (http:// vis.stanford.edu/protovis). However the CSV and TSV outputs are well suited for my clients (i.e. command-line scripts).
The intended use for my service is to provide a simple query interface for scientific datasets. So I have no transaction or domain modeling concerns. So my usage profile tends to be write-once/read-lots. Is your service meant to support writes (INSERT, UPDATE, DELETE) as well? I'm assuming that you meant to call your http-mysql webapp from a webapp running on GAE (or anywhere for that matter). I'm also curious about the kind of output that you'll be producing. As far as support for other databases other than MySQL, I have the advantage of leveraging JDBC which abstracts most of the database specifics away from my code. On Jul 15, 2:23 pm, James Jones <[email protected]> wrote: > Its very similar but your's will allow for use of many different types > of databases and requires tomcat. Also is GAE specific. Mine is a little > more lite weight and only requires a web server that has php with mysqli > and json support. Mine can also be use by any language that do http > requests and understands json. The down side is that it only supports > MySQL. Just to be clear I am not knocking yours at all, just pointing > out the difference as I understand them. Please let me know if I missed > anything. > > -James > > On 14/07/10 6:26 PM, hector rovira wrote: > > > I have created a web service that may be similar to what you are > > doing. I use it as part of a service registry that runs on GAE and > > provides a REST API used by visualizations, web UIs, command-line > > scripts and other web services. > > > My service exposes the Google Visualizations Data Source API (http:// > > code.google.com/apis/visualization/documentation/dev/dsl_about.html) > > as a REST web service, extending the Java library provided by Google. > > I find this to be a comprehensive standard for providing read-only > > access to databases. The Google Java library outputs JSON, CSV, TSV, > > HTML but it can easily be extended to provide a custom output format. > > > I have configured my web service to provide access to any table or > > view in a MySQL database; but I've also been able to connect to other > > databases with supported JDBC drivers (PostgreSQL, Derby, SqlServer), > > although some of the GQL syntax is not supported by all databases > > (e.g. limit, offset). > > > My service defines URIs of the form: /service-name/database-name/ > > table-or-view-name. It provides a simple REST API that allows users > > to: > > - list registered databases > > - list tables (and views) within a database > > - list columns (and datatypes) within a particular table (or view) > > - submit queries that conform to the datasource wire protocol - > >http://code.google.com/apis/visualization/documentation/dev/implement... > > > I just uploaded a standalone version that easily deploys to any J2EE > > web app container (I use Apache Tomcat 6.x): > >http://addama.googlecode.com/files/google-dsapi-svc.war. You can > > rename this war file. Before you deploy it just include the following > > files in the classpath ($TOMCAT_HOME/lib): > > - the appropriate JDBC driver (jar file) -> > > http://dev.mysql.com/downloads/connector/j/5.0.html > > - a configuration file called "google-dsapi-svc.config" containing > > local database mappings in a JSON format. For example: > > { > > locals: [ > > { > > uri: "/google-dsapi-svc/demodb", > > classname: "com.mysql.jdbc.Driver", > > jdbcurl: "jdbc:mysql://hostname:port/ > > databasename", > > username: "username", > > password: "********" > > } > > ] > > } > > > You can find some more information about my software at: > > http://cloud.addama.org > > > On Jul 14, 4:57 am, outcast<[email protected]> wrote: > > >> I am working on new project that will let me use mysql inside of GAE. > >> I just wanted to some other peoples thought on it. check > >> outhttp://github.com/outcast/http-mysqlandlet me know what you think. > > >> -James -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
