DbGate

GitHub开源地址：https://github.com/dbgate/dbgate
下载地址：https://dbgate.org/download/

Why is DbGate different

There are many database managers now, so why DbGate?

• Works everywhere - Windows, Linux, Mac, Web browser (+mobile web is planned), without compromises in features
• Based on standalone NPM packages, scripts can be run without DbGate (example - CSV export )
• Many data browsing functions based using foreign keys - master/detail, expand columns, expandable form view

Design goals

• Application simplicity - DbGate takes the best and only the best from old DbGate, DatAdmin, DbMouse and SQL Database Studio
• Minimal dependencies
  • Frontend - Svelte
  • Backend - NodeJs, ExpressJs, database connection drivers
  • JavaScript + TypeScript
  • App - electron
• Platform independent - runs as web application in single docker container on server, or as application using Electron platform on Linux, Windows and Mac

How to run development environment

Simple variant - runs WEB application:

yarn
yarn start

If you want more control, run WEB application:

yarn # install NPM packages

And than run following 3 commands concurrently in 3 terminals:

yarn start:api # run API on port 3000
yarn start:web # run web on port 5001
yarn lib # watch typescript libraries and plugins modifications

This runs API on port 3000 and web application on port 5001
Open http://localhost:5001 in your browser

If you want to run electron app:

yarn # install NPM packages
cd app
yarn # install NPM packages for electron

And than run following 3 commands concurrently in 3 terminals:

yarn start:web # run web on port 5001 (only static JS and HTML files)
yarn lib # watch typescript libraries and plugins modifications
yarn start:app # run electron app

How to run built electron app locally

This mode is very similar to production run of electron app. Electron doesn’t use localhost:5001.

cd app
yarn

yarn
yarn build:app:local
yarn start:app:local

How to create plugin

Creating plugin is described in documentation

But it is very simple:

npm install -g yo # install yeoman
npm install -g generator-dbgate # install dbgate generator
cd dbgate-plugin-my-new-plugin # this directory is created by wizard, edit, what you need to change
yarn plugin # this compiles plugin and copies it into existing DbGate installation

After restarting DbGate, you could use your new plugin from DbGate.