Docs‎ > ‎

Live Browser

Live Browser is a user interface built directly from your schema.  It uses HTML5, CSS and JavaScript, so runs well on desktops and tablets.
It's a great way to view data for existing systems, regardless of their architecture.

It is layered over Live API and Live Logic, so enforces your logic and security.  This enables you to use it to test your API, and for "back office" production apps.

Live Browser is a multi-table application with (see these features in action using your Getting Started Guide videos):
  • Multi-table application interfaces derived from your parent/child relationships, including
    • Master/Detail, to show child objects for a parent (e.g, orders of customer)
    • Drill Down Navigation, to show related data (e.g., Order detail, or SalesRep for Order)
  • Filtering on multiple fields, with paginated scrolling (subject to row/column security)
  • Row Sharing, so you can send the current Form Row to colleagues
  • Update Services, including 
    • Updatable grids
    • Lookups, to associate a child to a parent (e.g., Product for Item)
    • Enforcement of Live Logic 
  • Authoring, so you can control which attributes are displayed and their formats, and skinning
The Live Browser uses the same REST API as any other Espresso Logic application: everything it does can, by definition, be done by using the REST API.

Instant Back Office Apps

You can use Live Browser instantly on any existing database.  Typical scenarios:
  • Back Office Database Maintenance applications

  • Schema Exploration

  • Data Administration and Repair

  • Prototyping
For new systems or new components, integration with Live Logic means you have a solid back-office interface that enforces your business logic and security, working in conjunction with REST-based mobile and web apps.




ERP technology for custom systems

Many "back office" packaged systems (ERP, CRM) contain many hundreds of screens.  It is too costly and time-consuming to hand-build each screen, which moreover would not reflect subsequent schema extensions.

So, such packages often build screens automatically, based on models, configuration files and so forth.  Such screens have been shown to be quite adequate for "back office" use to query, browse and update data.

Internal custom systems have the same requirements.  Not only can this represent substantial time and cost, in many cases these applications are simply not provided, with the result that data maintenance tasks are often performed with raw SQL, which is tedious and risky.

Live Browser can help by providing ERP-style automated UI for any database.  We leverage the schema for such automation as described below, so that you do not have to configure settings files, or maintain them when the schema changes.


Schema-driven

Live Browser implements a number of heuristics based on the foreign key relationships in your database:
  • Each child relationship becomes a tab in the master/detail section

  • Each parent relationship is used for Lookups and Navigations

Automatic Joins

Many database employ surrogate keys.  For example, the Business Logic Demo identifies a Product by product_number., instead of a name like Hammer or Shovel.

The basic heuristics above would not produce a usable result for child tables containing foreign keys to Products, such as Lineitem.  It would not be interesting to see a list of 10 part-1'2, 5 part-2's and so forth.  Clearly, we want to see the name of the parent row.

When parents are identified by a numeric key, the system selects the first text fields to be the UserKey: a field likely to be a more recognizable name.  The Live Browser provides an interface to reselect such keys when the heuristic makes the wrong choice.


Terminology

We refer to the following:
  • Search Grid
  • Form
  • Child Grid (Form + Child Grid is often called Master/Detail


Launching

You can run Live Browser via the Espresso Designer, or stand-alone.  

Author Mode

Author Mode is a simper approach to customizing applications than a complicated IDE.  The Tools menu on the far right provides Author Mode, to: 
  • customize your data content (use the various gears that appear to select columns, rename them, choose formatting), and to 

  • control appearance via upload able style sheets (samples available for download at the bottom of this page - use the down-arrow on the right)
To use Author Mode, you will need to login in a Developer (not App User), using the same credentials used to access the Espresso Designer.

The screen shot below illustrates Live Browser with a different style sheet, in Author Model



ċ
Helvetica Neue Light.zip
(389k)
Val Huber,
Jul 31, 2014, 6:05 PM
ċ
Style Sheets.zip
(6k)
Val Huber,
Jun 21, 2014, 5:27 PM