A cross-platform REST service and JavaScript client
for creating corporate web applications with
SQL Server, Oracle, DB2, MySQL, MariaDB, NuoDB and PostgreSQL
DBGate can be used as a database data editor without any configuration.
Basic client features include:
In general, we have 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.
DBGate also identified primary key tables of the accounts, items, and companies, and generated value lists for parameters and cells.
To get such an editor, just add the database connection string.
By configuring on the server-side, DBGate gets the following features:
DBGate features, for example, are sufficient for working in budgeting and planning applications.
The screenshot shows an example of budget reports.
Data, formatting, parameter values, translation of column names and parameters are loaded from the database.
You can try DBGate with the applications online:
https://dbgate.savetodb.com/en-us/budgeting-app.htm
https://dbgate.savetodb.com/en-us/planning-app.htm
To start DBGate, add an anonymous database connection string.
When the server-side receives a user request,
it connects to the database under the user's username and password,
reads metadata and creates the REST service based on user permissions in the database.
The server-side actually converts HTTP GET, POST, PUT, and DELETE commands
to SQL SELECT, INSERT, UPDATE, DELETE (or EXEC for procedures) statements.
The JavaScript client uses REST requests to work in the browser.
Since DBGate uses a shared data layer and settings with the SaveToDB add-in,
it gets rich and compatible application configuration options.
The server-side is implemented with ASP.NET Core 3.1 and supports Windows and Linux.
It can work as a console application, a Windows service,
and also under IIS, IIS Express, Apache, and Nginx web servers.
It supports Microsoft SQL Server, Oracle Database, DB2, MySQL, MariaDB, PostgreSQL, and NuoDB.
The JavaScript client supports Chrome, Firefox, Opera, Safari, Edge, and IE 11 on desktops, tablets, and smartphones.
DBGate targets database developers who can create full-fledged corporate web applications with DBGate.
Applications are configured by editing configuration tables in a database
and creating database objects, for example, to get lists of values or save data.
Also, DBGate would be useful for current customers of the SaveToDB add-in,
since, within an hour, they can get an additional web application
due to the compatibility of the configuration of the SaveToDB add-in and DBGate.
The free edition of DBGate has a limit on two users.
The price of a perpetual license is 1,200 USD for use on up to five servers.
We also recommend purchasing the warranty (20% of the price) to upgrade to the next major versions at no additional cost.
We recommend starting with a developer learning resource:
This course will allow you to understand all the ideas interactively.
Then download and unzip the installation package to a separate folder and launch the console application.
You will get a working service on port 5003 with the same examples.
See https://www.savetodb.com/dbgate/quick-start.htm for details.
In the article, you will also find details on deploying the application on Windows and Linux in various ways.
In general, it will take less than an hour to get the first web application for an existing database.
Feel free to contact us.