Home

Welcome to the embers wiki!

Embers aims to be a small embeddable javax.ws.rs servlet that runs pre-configured sql queries against a jdbc datasource.

Why?

I have been in situations where stakeholders wanted a variety of reports run against the production database on a repeatable basis. Rather than do this by hand, this aims to quickly allow queries to be developed and deployed outside of the release cycle, and run by the stakeholder directly.

Developed

Add query (POST)

Update query (POST)

Run query (GET)

• Record performance of query
• Display the results as CSV

Configuring database access

• jdbc Datasource - currently this needs to be the same datasource with the queries tables, and the tables to be reported on.

Default queries

• Show all queries

Notes

It requires some persistent storage of its own:

• 1 table to store the queries
• 1 table to record performance.

TODO

Querying

• Allow Input Parameters for filtering

Displaying the results

• HTML
• JSON
• XML

Auditing

• track user

Error Logging

• Slf4j

Caching

• cache a query result
• re-use the cached query result
• replace the cached query result