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.

First of all we need to get free version of Abris Platform. We will use docker container with pre-installed Apache+PHP+PostgreSQL+Abris. So open your command line prompt and type the commands (Docker should be installed…


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>

Let’s look at the standard data view.

Image for post
Image for post
Screenshot from https://abris.site/pagila/#list/customer

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 the user because the user wants to know how lot of data is available to him. …

About

Aleksey Novikov

Founder and lead software developer of Abris Laboratory, LLC. Creator of Abris Platform (https://abrisplatform.com). Scientist. Teacher.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store