JsonApi - Live in harmony with JSON-Responses
JSON-Strings are often used to exchange data through HTTP-Requests. Many times the wheel is invented newly by defining an exchange-format. JSON-API tries to specify a common format for requesting, modifying and expressing resources. So let's talk about the specification, limits, underspecification, error-handling and useful ideas when using that format.
Put my data into pages
Pagination is the process to divide data into several blocks and navigate through it. Are there different algorithms and are all of them equally efficient?
So let's have a look at different possibilities to query a database-table, compare the time spent executing the query and talk about effects on navigating through the resulting pages.
Additionally, let's have a look if indexes can also speed up our queries.