Create flexible API's which suit the needs of front-end developers
Today's front-end developers want fast, RESTful api's which feed them with rich, nested data. Moreover they want to have control over structure of the data, without reprogramming the backend. This is exactly what TinyQueries can provide.
- TinyQueries can be used to build fast, flexible API's
- TinyQueries can be used for realtime analytics
- TinyQueries is ideal to create custom database exports or feeds
TinyQueries versus SQL
Handwritten SQL is in general considered to be the fastest way to retrieve data from a relational database. However it may still be difficult to find to most optimal way of querying, especially if many tables are involved. TinyQueries is designed to take advantage of several best practices in query design, like splitting up complex queries into simpler ones.
We did a test on MySQL's Sakila sample database containing movie and actor data. One of the views retrieves a list of the actors and for each actor gets a the list of movies they played in, grouped by the movies' category. We compared the views' underlying query with an equivalent query written in TinyQueries. Below are the results.
These kind of benchmarks are of course dependent on the hardware used and the size of the database. But anyhow it shows the potential gain in performance which is possible by the TinyQueries type of querying.
Key advantages of TinyQueries™
- Fast performance, even for rich, deeply nested data
- Best of three worlds: it has a simple interface for developers like ORM, it is optimized for efficiency like plain SQL and it has the flexibility like NoSQL
- Analytics can be done without transferring the data to an analytical database
- Stimulates developers to improve code quality by separating code and queries
Who's using it?
Want to see a demo or have questions, don't hesitate to contact Wouter Diesveld, creator of TinyQueries™.