Concept

You may imagine or expect me to be like Tomcat and/or Rails that can manage Databases and Web APIs.
Well, it does not hit the center, but OK, let’s start there. Indeed, I am in there. This video may help you understand me quickly, and some videos are as well.

  1. Who am I
  2. What am I
  3. Where am I
  4. When I am
  5. How I am
  6. Which I am
  7. JSON! JSON! JSON!

  1. Who am I
    I am a server-side program that is written in Julia. I am very friendly, but not AI.

2. What am I
I can handle multiple databases, such as PostgreSQL, MySQL, Redis, and MongoDB, simultaneously. Simultaneously means ‘coexistence’. Of course, you can choose only one database as usual.
‘handle’ meaning is ‘create table’, ‘create DBI’, ‘publish the DBI as WebApi’, and of course, can execute the DBI/WebApi both in real and in testing.

3. Where am I
I work between the HTTPD server and the Database, as shown in the figure below. I pass the data from a database to the httpd. The data form is in JSON format, and the data depends on the DBI that you and I created.

4. When I am
Oops, this isn’t easy to answer. You use me when you need to create a new DBI/WebApi, table, add new data, and so on. And may you sometime want to see my conditions: WebApi execution speed, access numbers, or when you are down. (^o^)v

5. How am I
Yes, I can explain this clearly. The details are in ‘How to use …’ for (1)-(3) and ‘How to call …’ for (2).
(1) Create a table on the database by uploading a CSV file to me.
(2)create DBI: you can create ‘select’ and ‘update’ DBIs by selecting table columns, ‘insert’ and ‘delete’ DBIs are under my control.
(3) Publish the DBI as a Web API: Each DBI has its unique API name, which is to be the Web API name; you call this name.
(4) Execute the DBI/WebApi: order me with typing ‘test api’…. then I will guide you

6. Which I am
I know every present application, no matter which client side or server side, is operated by ‘click icons’ and/or ‘entering commands on a screen’.
These are developed in progressing computer systems. ‘Icons’ are friendly, imagable, the functions, ‘commands’ are known by describing them in many blogs. However, you must learn their meaning and location on the screen each time you start using them. This ‘knowledge’ is called ‘skill’ and ‘experience’. Is that true? Knowing them or not makes a hierarchy between a beginner and an expert.
However, you may have had an experience where you shouted, ‘I just wanna upload this file there, but can’t find a proper function in icons, or do not know the command to run it.’ You may think “do everything if i asked ‘upload’”. This is very natural.
In my case, you can type ‘wanna upload file’ or just ‘file upload’. Adding ‘please’ is more friendly, e.g., ‘file upload please’.\(^o^)/
That way, you don’t need to study how to do something anymore; ask me what you want to do in our chatbox.

7.JSON! JSON! JSON!
All data is passed in JSON. I mean, no matter which Plan A or Plan B, please refer to the form in ‘How to call…’.

fig: where i am