Getting Started with DBEdit

Getting Started with DBEdit

DBEdit is an advanced database data editor.

It allows getting data from tables, views, stored procedures, or SQL queries and saving changes back to a database.

Here is a sample of data loaded from a view:

DBEdit - View Sample Without Translation

Contrary to other editors, DBEdit creates drop-down lists for fields and parameters using user-friendly value names from the referenced tables.

For example, this sample has the following tables:

Database Diagram of Sample 02 - Advanced Features

And, the view has the following code:

CREATE VIEW s02.view_cashbook

It is enough! DBEdit finds related tables itself.

Moreover, database developers can customize a lot of features.

Here is a sample of an editable report implemented using a stored procedure:

DBEdit - Procedure Sample

DBEdit can execute supplied procedures or SQL codes on cell change events.

For example, the handler of this stored procedure has the following declaration:

CREATE PROCEDURE s02.usp_cash_by_months_change
    @column_name nvarchar(255)
    , @cell_number_value money = NULL
    , @section int = NULL
    , @item_id int = NULL
    , @company_id int = NULL
    , @year int = NULL

The procedure gets the edited cell column name and value, and values from table columns and procedure parameters.

You can use DBEdit on any supported database platforms in the same manner:

  • Microsoft SQL Server
  • Oracle Database
  • IBM DB2
  • MySQL and MariaDB
  • PostgreSQL
  • NuoDB
  • Snowflake
  • SQL Server Compact
  • SQLite

You can try to connect to your database and edit data easily.

To learn DBEdit features, try its samples. You will find code templates for typical tasks.

See also: