Direct access to MiaRec DB

MiaRec uses open architecture with ability to access MiaRec database directly from your web application.

Comparing to REST API a direct access to MiaRec database allows to implement advanced integration between your web application and MiaRec recorder. This will allow you to build complex SQL queries on MiaRec data and optimize these queries according to your scenarios of data usage (for example, you can create additional database indexes on specific columns to speedup search operations). Also direct access to MiaRec database provides access to internal data, which is not possible to retrieve via REST API.

MiaRec uses PostgreSQL as a database engine. PostgreSQL has many application interfaces for many monogramming languages, like C, C#, Java, Python, Ruby, PHP etc.

Check the following web-page to see a list of available interfaces to PostgreSQL: http://www.postgresql.org/download/products/2-drivers-and-interfaces/

Simplified diagram

Detailed diagram

See also: MiaRec Architecture