After connected to a database, DbFace will create data module for the database connection. Data module lets you manage data as easy as possible.

Data module provides the functions such as CRUD (creating, updating, deleting), filtering, paging the original database table, etc.

DbFace built-in data module is powerful:

DbFace provides a super easy way to navigate and sort table data page by page. Open the selected table:

MySQL table data navigation and sorting

Delete Row#

To delete a row, click the "Delete" icon at the left, will remove the row.

Delete row in table editor

The database table require a primary key to make delete function work.

Tip

The database table requires a primary key to support this feature.

Update Row#

Double click the row data, will open the row updating dialog, at this dialog, change the row data, and click "Save Change" button to apply the row changes.

Open row data editor

Tip

The database table require a primary key to make update function work.

Insert Row#

At the table editor page, click the "New Record" link to open the row data editor, you can select a single row of data, DbFace will copy the seclected row data to the editor automatically.

new record in table editor

After edited the row data, click "Save Change" button to apply this new row data.

Filter#

Click the "Filter" button to open the filter condition editor.

apply filter conditions in data module

Save filter conditions#

You can save your frequently-used filter conditions.

Save filter conditions in DbFace

You might want to navigate to other tables by value, this feature helps you to do this easily. Click the "Field Settings" link at the column, at the "Field Settings" page, select the table column your want to link, click "Save" button to apply this change.

Build table links

After this change, the value will convert to link, click value to navigate to other table with the selected data value.

DbFace table links

Field Formatter and Validatter#

You can code your own formatter functions for fields in DbFace.

Click "Settings" and open the "Customization" page, select the "Functions(javascript)" tab, here you can code global javascript functions, DbFace will load these codes while page loaded. We define a function that convert timestamp to readable date string.

function timestamp_to_date(UNIX_timestamp){
  var a = new Date(UNIX_timestamp * 1000);
  var year = a.getFullYear();
  var month = a.getMonth() + 1;
  var date = a.getDate();
  var hour = a.getHours();
  var min = a.getMinutes();
  var sec = a.getSeconds();
  var time = year + '-' + month + '-' + date + ' ' + hour + ':' + min + ':' + sec ;
  return time;
}

define custom javascript functions to extend DbFace

Now you apply the "timestamp_to_date" function to an unix timestamp field.

apply custom function as field formatter

Export Data#

To export the current data, choose format, and click the corresponding button, you can export data to CSV, PDF and email.

Export data to CSV, PDF format