The Datably Database stack provides the core data services, such as:
- Connection Management for MySQL, PostgreSQL, sqlite3
- Caching
- TreeQL - SQL-Interface
- Security Features (app firewall, CORS)
Step 1: Select the Database Driver
Step 2: Enter the Access Data
Step 3: Complete Your Project Data
Complete your project data under "Settings —> General", particularly the field "Web Address".
This field must contain the address from which your CRUD page will be reachable. Otherwise Preview and other related features will not work!
Step 4: Publish Your Project
Now it is time to publish your project. Don't worry if there is nothing to show yet. This step is necessary to put the Database Stack at the right place so that you can preview your work in the next steps.
You will have to configure your publishing data under "File —> Publishing Settings".
Remember to re-publish once you change a setting in this stack!
Step 5 (Optional): CORS Settings
Datably implements CORS (Cross Origin Resource Sharing) features for the communication between the frontend (I.e. the web interface) and the backend (I.e. the Database Middleware). If you want to learn more about CORS,
this is a good starting point.
CORS is notoriously difficult to debug, so at this point you can l
eave the default setting ("All") enabled and come back to this at a later point when you feel comfortable to configure it.
Step 6: Set Allowed Methods
The Database Stack basically opens the database up for interaction. Often, you do not want to expose all types such as Create, Edit, Delete, since this has security implications. For a simple Display page, you should turn this off.
Step 7 (Optional): App-Firewall & Reverse Proxy
Datably provides further security settings. Once you are ready to finally publish your site, you can come back to these settings and configure them according to your environment.