WideDB Unique Features

Most likely you already tested several database application constructor services. We too. So what is so unique about our service?

WYSIWYG and Drag-and-Drop Development

With WideDB you just drag-and-drop blocks, fields, panels, pages in real time placing them there you like (even script lines).

All changes made to your application apply immediately.

Right-click any element you see in your app - and set its color, location, behavior, access levels.

Absolutely everything is customizable!

Speed of Desktop Application

WideDB uses unique JID technology that allows to develop an application and work with records without waiting for server reply.

You click a button and get an immediate response like you are working with a desktop app.

Of course, if your database has million of records and you request historical data - it will take few milliseconds to process the query - but data from recent records will be displayed immediately!

Just try it for free to see that it really works!

Visual Scripts - for server/client side

Create scripts with simple Drag-and-Drop Script designer. Add logic, variables, inputs, operations without typing any code and studying syntax.

Same scripts can be executed on client-side (e.g., ask values, show form, change fields) or on server-side (calculate large amount of records, grant access, etc).

Visual Script Designer includes all professional tools - step-by-step debugging, multi-window work, variables type control and syntax highlight.

Generate PDF, DocX, HTML, XML, XLS and more

WideDB is not like many others modern "internet-only" services.

It includes number of Visual Designers to generate documents based on your database records.

E.g., use Report Designer to create PDF catalogue, XLS export to create report for accounting or DocX Template Designer to generate an agreement document.

PDF Report can be published online with possibility to edit record values.

Fine-tune Access Control

Configure access of each user group to all elements - tables, fields, blocks, pages.

In addition to the standard user access groups, you can add anonymous access and API access rights.

By server-side scripts you can grant access for specific records only. E.g. allow to edit restricted record by PIN-code.

Technical Features

Field Types

Field type determines type of data you can operate with:

Simple text
Multiline
Numerical
Combo
List
One-to-Many Relational
Many-to-One Relational
Image
Files
User
Users
Comments
Map

Block Types

Each application interface contains of pages and panel. And pages contain blocks:

Data view:

Table View
News Feed
Chart
Calendar
Map

Forms:

Record Edit Form
Filter Form
Script Form
Search Line

Controls:

Buttons panel
HTML (Static/Generated by Script)
Navigation menu

Visual Scripts

Functions

Login: If, For, For Each, Break;
Records: Create, Show, Update, Delete,Export/Send,Close;
Interface: Show Message, Confirm, Input List/Value, Files, etc;
Page: Navigate, Set/Get Block info;
System: Get system value (date, time, etc), Grant Access, Execute on Server;
Other: Number of Math, JS, HTML, String, Date functions.

Additional

Drag-and-drop script design;
Undo/Redo
Multiple script windows;
Debugging (step-by-step, skip, variables view);
User functions;
Variables type control;
Arrays, Objects, Associative Arrays;
Code Highlighting;

Multimedia

Convert video (MTS, AVI, etc) to MP4 format
Resize Images
Resample Videos
Play Videos online
Play MP3 files online
Images Slideshow
Access to multimedia info via Scripts (width, height, length, size, etc)

Records

Filtering
Sorting
Group operations
History of changes
Restoring
Comparing
Combining
Massive update

Advanced Tools

View as
App Localization
Include .CSS file
Include .JS File
Customize development tools

Access Control

Setup access for:

Fields
Tables
Blocks
Pages

Grant access by:

User group (Default, API, Anon)
User/Users content;
Visual Script
Record Owner
Device (Full/Mobile)

Export/Import

Export

XLS (Excel)
XML
CSV
TXT
Zip Archive (Data, Files)
PDF
HTML
DocX (Ms Word)
E-Mail
SMS

Import:

CSV
XLS
XML
XML (by URL)
Import using keys (to update existing records)

API

REST API (array as JSON string). Commands:

Select by Rule (Order, From, Limit)
Create New Records
Update Records
Delete Records
List Tables and Fields