You don’t need to be a developer to use FlexiDB. We have created graphical tools for creating databases. Once you’ve created your database you can use the FlexiDB WordPress plugin to link your database to your WordPress website. The WordPress plugin has a number of widgets that work with databases; these include data query (table), form, map, gallery (image slider) and chart.
If you would like to try out FlexiDB you can use our demo site. Our demo site works with WordPress multisite. You will be provided with a WordPress sub-site and a FlexiDB server. Please note this service is provided purely for new users to try out FlexiDB. If you want to use FlexiDB for your live WordPress site there are instructions here for getting FlexiDB.
FlexiDB has a separate database from the WordPress database. This means that it can also link to the FlexiDB app. This offers great flexibility to how your users interact with your database. The FlexiDB app is a bit like an eReader, but instead of reading books you are accessing a database. FlexiDB includes an app editor that works in a similar way to a traditional CMS like WordPress. Each database app consists of pages, which in turn have database widgets.
FlexiDB databases can be divided into data sets. As an example consider a database of restaurants. Each restaurant would have its own data set ID. This is ideal for WordPress multisite. The FlexiDB WordPress plugin works with multisite; each sub-site has its own data set. The plugin integrates fully with new site creation; admin can create both page and database object templates, so that when a new site is created it is already configured.
The ER tool enables users to create a database schema graphically. These can also be exported or imported. This feature is for the community. Why re-invent the wheel!
FlexiDB admin can create user roles. A user role can be given a name, such as admin, manager or clerk. Each role specifies the access rights: e.g. create, read, edit or delete which are on a per object type basis. So for example a clerk might be able to read certain types of object, but only a manager can edit or delete them. When users subscribe to a FlexiDB database the FlexiDB admin can select which user role they have. FlexiDB databases also have Data Sets. These are logical IDs, which enable a database to be partitioned. As an example consider a restaurants database. Each restaurant has its own data set ID. User roles can be assigned on a per data set basis. This means an individual user could be admin for one restaurant, but only a customer for another.