This document describe what is Trillo Workbench and how does it help you in building your application.
Trillo Workbench is a low-code platform that helps you build applications for the Google Cloud by writing very little code or, in some cases, without any code.
The Trillo Workbench platform consists of microservices that run on the top of Google Kubernetes Engine. It uses several Google cloud services listed below.
- Cloud SQL - Postgres, MySQL, Microsoft SQL, any of these databases can be used to store data. You can connect to more than one database and mix different types.
- Cloud Storage - To store application files. Trillo Workbench provides file management on the top of the cloud storage buckets.
- MemoryStore - for caching and session management.
- Pub/Sub - for internal and application message passing.
- Google Identity Platform - as user store, authentication, issuing access tokens.
- BigQuery - for storing data and data warehouse.
- BigTable - Caching, hyperscaling.
- Google AI Services - Document AI, Speech to Text, Vision OCR, Auto ML
We have abstracted Google Service integration using restful APIs. Therefore it is very easy to integrate any new services using plugins. All services except Cloud SQL, Cloud Storage, MemoryStore and Pub/Sub follow the plugin architecture for the integration. These plugin are available as source code so you can easily customize their functionality.
A UI lets developers input and edit metadata and serverless functions. For example, in order to add a new table, a user can specify table metadata (columns, types of each column, primary key, etc.).
Trillo Workbench UI
You must wonder how you could use Trillo Workbench to build an application. How does it benefit you?
You can use Trillo Workbench to build the following functionality in your application. You can use it for one or more functions. The following is a brief description of significant components.
Trillo Workbench converts Google Cloud SQL into Data-as-a-Service without any coding. Specify database schema using JSON or UI. Once the metadata is specified, the workbench automatically delivers secure APIs for the database operation. For existing databases, you can introspect its schema. It supports Cloud SQL Postgres, MySQL, and MS SQL. Trillo Workbench provided data-as-a-service is proven, secure and high performance.
Trillo Workbench provides a similar abstraction for Cloud SQL as Firebase does for the FireStore (NoSQL).
Cloud SQL as Service using Trillo Workbench
Trillo Workbench provides a somewhat Unix-like file system on Cloud Storage Bucket. It supports folder hierarchy and all operations available in a file manager (upload, download, trash, rename, move, copy, etc.). Users get their secure home folder. Members of a group use group folders for collaboration. It also provides an inbuilt SFTP server. The difference vis-a-vis direct GCS API is that it overlays the application's user permission.
It also provides UI for files management which is like GDrive or DropBox UI.
File Management using Trillo Workbench
Trillo Serverless Functions are currently written in Java. Unlike Google Cloud Functions, they plug into the workbench as scripts. Therefore they are easy to write and deploy compared to Cloud Functions. Instead, you can also use Cloud Functions with the workbench.
Trillo Workbench Serverless Functions for Business Behavior
In Trillo Workbench, a workflow executes functions as a flowchart. A workflow runs in the background. Instead of a sequence of tasks, Trillo Workbench can also execute a single function as a background task. An API call, an event, or a scheduler can trigger a workflow or task.
Background Tasks, Workflows and Schedules
Trillo Workbench provides user, role, group management, and access control out of the box. It delivers authentication using its database or Google Identity platform. It supports multi-factor authentication, password policy, and enterprise authentication systems such as LDAP.
It includes UI available under a friendly open source license.
Trillo Workbench User Management, Access Control, Authentication
Trillo Workbench integrates with several Google Cloud services out of the box. The following diagram shows integration with Google AI APIs. It is one typical execution of AI/ML inference, ingest files, pre-process, run through Google Cloud AI APIs, post-process the result of API, and store it in the Cloud SQL. The data in the Cloud SQL can be accessed using Data-as-a-Service APIs.
Trillo Workbench provides several complementary services to make it a flexible platform for customization. Trillo Workbench eliminates the need for DevOps. The above is the list of significant functions.
Next, we will see how to build an enterprise class application's backend using Trillo Workbench.