Skip to content

Sample DB, Project

The sample application (run it here) is created from the pre-installed sample database shown below (tutorial here). It is an extension to Northwind that includes additional relationships:

  • multiple relationships between Department / Employee
  • multi-field relationships between Order / Location
  • self-relationships in Department

Sample Database

You can create projects for it with or without logic, as described below.

 

Northwind without logic

To install without pre-installed customizations for the API and Logic:

ApiLogicServer create --project_name=ApiLogicProject --db_url=nw-
Open the project in your IDE, and open the readme for a walk-through:

Tutorial Welcome

 

Add Customizations

The tour begins with a review of the uncustomized project.

This illustrates the level of automation you can expect with your own projects.

The tutorial then shows how to add customizations:

ApiLogicServer add-cust

This installs:

  1. Logic: The integrity of this database is enforced with this logic
  2. Security: this sqlite-based security
  3. Integration: this Kafka logic

 

Northwind with Logic

You can also create the project with the logic pre-installed:

ApiLogicServer create --project_name=ApiLogicProject --db_url=nw+

Sample-ai

The ChatGPT-based sample is structured as follows:

Sample-ai Database

Basic Demo

The ChatGPT-based sample is structured as follows:

Sample-ai Database