Using DBGate

Using DBGate

What is DBGate

DBGate is a cross-platform ASP.NET Core 3 application and a JavaScript client.

You may install it on Windows with IIS, on Linux with Apache, or Linux with Nginx.

The server-side part creates REST endpoints on-the-fly for all connection strings specified in the application settings file.

DBGate supports SQL Server, Oracle, MySQL, MariaDB, PostgreSQL, DB2, NuoDB, and SQLite.

The built-in JavaScript client allows viewing and editing data. It looks like this:

DBGate Samples - s02.cashbook

You may try online samples at dbgate.savetodb.com.

How it works

DBGate reads connection strings from the app settings file and creates REST endpoints for every string.

Here is a sample of a connection string:

  "ConnectionStrings": {
    "mssql": {
      "ProviderName": "System.Data.SqlClient",
      "ConnectionString": "Data Source=mssql.savetodb.com;Initial Catalog=AzureDemo90;User ID=user;Pwd=pass"
    },

In this case, DBGate creates the 'mssql' endpoint for the AzureDemo90 database on the mssql.savetodb.com server:

The 'user' and 'pass' are placeholders to turn on the authentication.

The REST service supports GET, POST, PUT, and DELETE.

Also, you may use a built-in JavaScript client to view and edit data:

You may test this sample with the following credentials:

Username: sample02_user3
Password: Usr_2011#_Xls4168

See more details about DBGate endpoints here.

How to use DBGate

Basically, DBGate is a web viewer and editor for database data.

You may use a built-in editor page or embed DBGate controls into other web pages.

Also, DBGate is a REST service that can be consumed by third-party clients.

We recommend taking the following steps to start using DBGate:

  1. Playing with online samples at dbgate.savetodb.com (10-15 minutes)
  2. Testing DBGate using the QuickStart steps (5-10 minutes)
  3. Installing DBGate (10-20 minutes)

Less in an hour, you will have a REST service and a web editor for your databases.

Note that DBGate is free for two users (identified by logins).

So, you may use it for development purposes and yourself for free.

Activate the trial version when you are ready to try it for a large number of users.

How to configure REST service models

DBGate creates models reading the database metadata under the user's credentials.

So, every user gets a model based on available objects only.

DBGate analyses SQL definitions of views and stored procedures and adds a lot of features automatically.

However, you may customize the following features using a database-side SaveToDB Framework:

Notes for SaveToDB and DBEdit customers

DBGate uses the same data layer as the SaveToDB add-in for Microsoft Excel and the DBEdit desktop application.

So, you might get almost the same application features with the built-in JavaScript client.

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.OK