Abris Platform is really good to create a back-end for your database. While the front-end is pretty simple the back-end can be more complicated because of many tables that you need to edit. For every table you need to create a display page, edit form and write some server code to retrieve and save data. It is a long and boring job.
You can be surprised, but your database contains almost all information to create the interface automatically. Abris Platform can do it for you.
When we want to display data from a large table in the user interface, we usually get it using the query
SELECT * FROM <table_name> WHERE <condition> ORDER BY <key> LIMIT <limit> OFFSET <offset>
If sorting is performed on an indexed field, then the query is executed fast. But is this enough for the user interface to work effectively?
Let’s look at the standard data view.
Here we see the result of the query, buttons for switching pages and a field indicating the total number of rows.
This little field brings a big problem. It represents pretty important information for…