Super Simple SimpleDB Example using Java and Typica
What is here?
3 Java programs that run on command line or in IDE:
SimpleDBCreateDomain.java - creates an Amazon Simple DB domain called example
SimpleDBLoadData.java - loads sample records in example domain
SimpleDBShowData.java - shows loaded data in pipe-delimited format
Web Example
SimpleDBShowData.jsp - JSP that returns data in pipe-delimited format
yuitest.html - Yahoo data table displays data supplied by SimpleDBShowData.jsp
The 3 Java programs interact with SimpleDB using Typica in a very straightforward way. Note that the actual Access Code and secret key are not included. You will need to replace KEY and SECRET to run these examples.
Pipe-delimited data is returned from SimpleDBShowData.java and SimpleDBShowData.jsp.
That was done to illustrate loading the data into the YUI data table using a text model. The YUI data table also accepts XML or JSON.
Limitations, questions, and things to try
I edited the sample data to exclude single quotes and asterisks. Those are special characters that need to be escaped to work properly.
I am including attributes with multiple values like keyword, but this can be done better
I am very deliberately building the data output in the required format, is there a slicker way to do this?
What about output in JSON or XML?
What about using a raw XML format to dump to the YUI data table?
Helpful Links:
Typica Project
Typica JavaDoc
YUI Data Control
3 Java programs that run on command line or in IDE:
SimpleDBCreateDomain.java - creates an Amazon Simple DB domain called example
SimpleDBLoadData.java - loads sample records in example domain
SimpleDBShowData.java - shows loaded data in pipe-delimited format
Web Example
SimpleDBShowData.jsp - JSP that returns data in pipe-delimited format
yuitest.html - Yahoo data table displays data supplied by SimpleDBShowData.jsp
The 3 Java programs interact with SimpleDB using Typica in a very straightforward way. Note that the actual Access Code and secret key are not included. You will need to replace KEY and SECRET to run these examples.
Pipe-delimited data is returned from SimpleDBShowData.java and SimpleDBShowData.jsp.
That was done to illustrate loading the data into the YUI data table using a text model. The YUI data table also accepts XML or JSON.
Limitations, questions, and things to try
I edited the sample data to exclude single quotes and asterisks. Those are special characters that need to be escaped to work properly.
I am including attributes with multiple values like keyword, but this can be done better
I am very deliberately building the data output in the required format, is there a slicker way to do this?
What about output in JSON or XML?
What about using a raw XML format to dump to the YUI data table?
Helpful Links:
Typica Project
Typica JavaDoc
YUI Data Control
