ourDB - an agile app / database design platform

1. CREATE databases

Create a new database, give it a name and define its columns, and turn the database ON demo +

2. MANAGE/QUERY data

Input data - Go into the database and start entering records to the database

Upload data - Or enter a number of records by importing CSV (comma separated version) file demo +

Edit, delete data - Select and edit a record, and then save it. Or select and delete a record, or delete a number records each time demo +

Query data - Quick search records on all database tables or on a specific table. Run a select query with specific criteria or with one or more parameters. And save it for repetitive use demo +

3. SHARE databases + COLLABORATE

Assign permission - Assign different permissions to another user (e.g. assign "Browse", "Query" and "Add" permissions), and then copy the link of the database and send it to the user demo +

Share and collaborate - Having got the link to the database, the user with the permissions, after successful login, can start browsing the data and entering new records. The user will not be able to execute any actions without relevant permissions demo +

THEN ON TOP OF DATABASE...

4. BUILD QuickApp

Want to turn the database into an app? The simplest way is to build QuickApp. QuickApp is like a workspace where the shortcuts to database tables and saved queries are stored demo +

5. RUN QuickApp

Any users who have the right to access and run the QuickApp can see the boxes representing different database tables or saved queries. Having the permissions, the users can manage datasets like records browsing, querying, adding/editing/deleting demo +

6. SUBMIT to Galleria

If finding the QuickApp useful, users may submit it to ourDB Galleria, so that other users may also activate it for their own use

OR ALTERNATIVELY...

7. DESIGN Appages

Appages are a set of HTML files where tag-like controls are used to tell ourDB how to interpret and present the data inside database tables. With Appages, users can design sophisticated web apps using ourDB built-in features like group, permission and workflow management, all together enabling the app users to interact with data more securely and more smoothly. Further, by importing 3rd-party framework or script libraries to Appages, the app can deliver much more user-experience elements to end users

8. RUN the App

9. SUBMIT to Galleria

Similar to QuickApp, users may submit an app built with Appages to ourDB Galleria. Other users may activate the app for their organizations or other missions

10. ACTIVATE pre-built QuickApp / App

Search from ourDB Galleria and activate a QuickApp or an app built with Appages which fit different scenarios. Examples:

• ourInvoice invoicing system with inventory control
• ourBook double-entry accounting system
• ourEvent members/activities management
• ourVote online survey builder
• ourPost social-network-like updates sharing site
• ourCart Paypal-enabled online shop
• ourLabel portal with parallax layout
• ourCircle blog for non-government organizations
• ourPicRoll curating contents with images
• ourPicons photos sharing system
• ourWeb site for SME to spreading their ideas
• ourSite slide-show-enabled site
• ourPage blog for sharing opinions
• ourEDM email-marketing tool
• ... and

11. RUN QuickApp / the App

Click any one of the pre-built QuickApp or apps, and the app is just right there (e.g. let's activate the online shop app ourCart) demo +

THEN BASED ON QUICKAPP / THE APP...

12. CUSTOMIZE QuickApp / Appages

Simple customization - For example, using an app built with Appages as a base, change the basic settings of the app like the app name or the background color. For most pre-built apps, owners can manage a user database table about the app's style. Refer to the 'Demo/Note' about how to change those settings demo +

Advanced customization - change database structure - Sometimes more complicated changes are necessary. For example, one more column is needed to present more information inside an app demo +

Advanced customization - change Appage - To match with the changes in a database, most of the time Appages have to be changed, too. So, download the Appage HTML file, open it with any text editor, or directly open the Appage using the online HTML editor, modify the corresponding Appage controls to fit different requirements demo +

13. RUN QuickApp / the App - again

Re-run the customized, tailor-made QuickApp / App. The above is just an example. Refer to the online help to know more about QuickApp / Appage and how to use it demo +

14. SUBMIT to Galleria - again

So users may always activate QuickApp or apps built with Appages through ourDB Galleria, customize them and contribute their efforts by submitting the modified apps back to ourDB Galleria, again and again