DBGate is a cross-platform application that allows viewing and editing database data in a browser.
Its server-side ASP.NET Core 3 application implements a REST service that does the following:
To create a service, just add a named connection string to the application settings.
DBGate creates a model for all available tables, views, and stored procedures reading the database metadata.
It supports SQL Server, Oracle, MySQL, MariaDB, PostgreSQL, DB2, NuoDB, and SQLite on Windows and Linux.
For example, this sample service is configured using the 'mssql-023' connection string:
Here is a sample screenshot of the client:
You can load data from tables, views, and stored procedures. You can edit data and save changes back.
We believe that DBGate revolutionary changes the in-house application development
because creating well-designed databases is enough to deliver corporate web applications.