Documentation

Buckle up and get ready to take off with Datably!

The Philosophy Behind Datably

Datably is based on RapidWeaver and requires the Stacks plugin to work. Other than that, Datably is a set of stacks which makes it super easy to set up CRUD based web sites.

The actual process of creating, designing and customising your CRUD interface is entirely based on drag & drop principles, no coding is necessary, no knowledge of SQL, HTML or CSS is required.

Streamlined

The process of developing a CRUD interface with Datably is straight forward and no programming or SQL know-how is necessary.

Datably consists of the following elements:
  • A theme wrapper which makes it easy to integrate Datably with frameworks such as Platform or Foundry; the design can be completely customised
  • A database wrapper which encapsulates the entire interaction with the database. It supports MySQL, SQLite 3 and PostgreSQL
  • A Table stack which connects to a specific table on the database. You can place as many tables onto a page as you like
  • Column stacks which represent the fields of a table. They can have formatters and editors and there are stacks for text, HTML, Markdown, numbers, images, star ratings, progress bars, traffic lights etc.

Requires
RapidWeaver version 8, Stacks plugin version 4.1.4 or higher
PHP v. 7.2 or higher with PDO drivers enabled for one of the database systems:
  • SQLite 3 v. 3.16 or higher
  • MySQL 5.6 / MariaDB 10.0 or higher
  • PostgreSQL 9.1 or higher

What it does not do

  • Create and change database structures (DDL)
  • Manage users, passwords on the database
  • Manage permissions on the database

If you require tools for the above mentioned tasks, please have a look at these:

Datably Stack

The initial basics of a CRUD page made with Datably are provided by placing the Datably Theme stack on each page.

This stack not only prepares all the necessary background but also allows you to customise the look and feel of the CRUD elements, such as standard colors etc.

Database Stack

Provides the connectivity to the database. This can either be MySQL or Postgres or SQLite3.
It manages access through CORS, an application firewall and functionality. However it does not provide user/password/permissions management.

Table Stack

Connects directly to a table or view in your database. It also provides the visual representation of the table. Here you can set table-wide styles and options.

Column Types

Datably provides different Column types for different data types, formatters and editors:

Basic - is the default formatter for all cells and will simply display the value of the cell as text
HTML -
displays un-sanitized html
Markdown -
displays the content as Markdown text
Date-Time - a specialised column stack to display dates
Number -
displays cell content as a (formattable) number
Money -
formats a number into currency notation
Image -
creates an img element with the src set as the cell value
Link -
renders data as an anchor with a link to the given value
Meter -
displays a coloured bar that changes colour depending on the numeric value of the cell
Progress Bar -
displays a progress bar that fills the cell from left to right, using values 0-100 as a percentage of width
Navigio Icon

Made by Navigio