Step 1 – Start with a Database Schema
The first step is to either tap into a database “schema definition” for an existing enterprise system or create one for a new system. For our examples below, we’ll use MySQL and the database tool phpMyAdmin since most developers are familiar with it, but AmpUp works with other SQL-based and even some non-SQL database engines.
Let’s put together a sample fundraising enterprise system for an organization and define the database table for its staff members this way:
For those unfamiliar with database definitions, the above is a list of data fields on the left and their data types on the right, “int(11)” for a maximum 11-digit integer number and “varchar(20)” for a maximum 20-character string of characters.
Step 2 – Install AmpUp
Installing AmpUp is easy. AmpUp can be utilized as a remote service from one of the DataPlex cloud servers, or it can be installed on a private server which, fortunately, is a straightforward process as no low-level OS libraries are required. Not relying on low-level OS-specific features makes systems based on AmpUp enormously portable, even between different Linux, Unix and Windows platforms.