A customizable Windows client
for creating corporate applications with
SQL Server, Oracle, DB2, MySQL, MariaDB, SQLite, and PostgreSQL
You can use DBEdit as a database data editor.
Basic features include:
In general, we tried to provide the required minimum of Microsoft Excel functionality for working with data.
The screenshot shows getting data from a stored procedure that can be saved to a source data table.
DBEdit also identified primary key tables of the accounts, items, and companies, and used value lists for parameters and cells.
By configuring on the server-side, DBEdit gets the following features:
DBEdit features, for example, are sufficient for working in budgeting and planning applications.
You can download the demo app workbooks and try all the features.
The screenshot shows an example of budget reports.
The table is fully interactive.
By clicking the right button, users can get value details.
DBEdit supports Microsoft SQL Server, SQL Data Warehouse, Oracle Database, DB2,
MySQL, MariaDB, PostgreSQL, NuoDB, Snowflake, SQL Server Compact, and SQLite.
We have used the SaveToDB add-in in a number of our projects,
where working with databases was not the main functionality.
At the same time, some clients expressed confusion about the need to have Excel and install the add-in.
Therefore, first of all, we created DBEdit as a replacement for the SaveToDB add-in in our projects.
Even though it has significantly fewer features, it solves all the required tasks.
The main value of DBEdit is that database developers can use it as a ready-made client
from the very beginning of the project and add the necessary features by configuring it.
If a company needs a different primary client, DBEdit can still be used at the initial stage,
when the primary client is not yet available, but database development is already underway.
The free edition of DBEdit includes all functions, except for saving data
to server databases such as SQL Server, Oracle, MySQL, MariaDB, or Postgres.
In fact, DBEdit can be used as a data and report viewer.
Also, the free edition allows saving data to SQL Server Compact and SQLite databases.
The Enterprise edition includes all features.
The base price of a perpetual license is 100 USD per computer.
Discounts apply when purchasing more licenses.
The package price for 500 licenses is 6,000 USD.
We also recommend purchasing the warranty (20% of the price) to upgrade to the next major versions at no additional cost.
If you only need to view and edit database data, just use File, New to create a new workbook.
For tables and most views and procedures, you will see an active Save button.
If you are considering customizing the application,
we recommend starting with the developer learning resource of the ODataDB web app
This is the latest and most comprehensive course that will allow you to understand all the ideas interactively.
The basic configuration options for ODataDB and DBEdit are about the same.
To test the DBEdit features, use File, Create from online examples.
The menu contains a lot of examples for various application development tasks.
We also recommend looking at the DBEdit SDK included in the downloaded package,
which contains the source code of all examples.
Feel free to contact us.