Getting started for users of rodakino RAD

Rodakino consists of a browser based frontend and a node.js driven backend, which is connected to PostgreSQL.

Everything on both browser- and backend- side is written in html, css and javascript and fully adjustable to yours needs.

 

Login to a rodakino application

Rodakino login screen

The login form authenticates against the existing postgres users of the connected database.

 

The adjustable rodakino menu

Adjustable rodakino menu

Every user has a Menu Profile attached. This menu profile describes the menu items that are displayed to that user.

So virtually any user can have a different set of allowed menu items, but of course users can share the same profile. 

To allow access to a menu item, simply add the menu item to the users profile (only allowed, if you are the administrator user).

A click on a menu item either calls a submenu or a rodakino window.

 

What is a rodakino window?

A rodakino window allows you to select/insert/update/delete one or more tables of the Postgres database underneath.

You can open more than one rodakino window in one browser window at the same time and seamlessly switch between them.

A click on the menu item "Countries" opens the following rodakino window:

 

example rodakino window for Countries

 

Clicking on Query in the overhead menu, you can query/filter rows of the database:

Filter/Query database tables

The above query retrieves all rows containing a Country-Abbreviation starting with the letter "U".

If you add "%e% into the second row, you get all "U" abbreviations and all country names containing the letter "e".

This is called Query-By-Example.

 

Insert, Delete and Update rows

Insert, Delete or Update rows

To insert new database rows , simply click on the "+" button and fill in your data.

To delete a row, click on the "-" button.

Updates can be made inline, just change the value of the field. There is no need to open extra forms.

After you're done, you click "Save" in the overhead menu and all your new Rows, changes or deletes are sent to the Postgres database.

 

Change the look and feel

If you don't like the colors of windows, text, fonts or want to display background images or whatever, everything is easy to change - since its all plain html and css.

 

Display Master/Detail Relationships

Display Master/Detail Relationships

If you click on a different master row, all the matching detail rows are retrieved on the fly. 

Details can have details on their own, a master can have more than one detail.

The structure is defined by a simple javascript link object.

Of course, Insert/Delete/Updates are allowed in all masters and details, just as described above.