Urbanairship tessera MySQL or MariaDB backend.

The Tessera project created by aalpern at Urban Airship is a graphite dashboard frontend.

There is one little thing that was missing for me personally on the documentation page, how to use an alternative SQL backend and how to populate it. They do mention Postgresql short but I couldn’t find any other information. (maybe because I need new glasses, who knows)

I’ve included the SQL schema I used for release v0.6.1, I’ll try to follow the evolution in database layout, but I don’t expect big changes since all the data is saved as one big json blob in the database.

Your config.py should also refer to MySQL instead of the local sqllite db. Please change the parameters user,password,machine,database to a useful value in order to make this work:
SQLALCHEMY_DATABASE_URI = 'mysql://user:password@machine/database'

Checkout the awesome Tessera dashboard at Github.

Leave a Reply

Your email address will not be published. Required fields are marked *