Skip to content
This repository has been archived by the owner. It is now read-only.

A web UI for popular databases like MySQL, MongoDB, PostgreSQL #6

Closed
egoist opened this issue Apr 23, 2019 · 12 comments

Comments

@egoist
Copy link
Owner

@egoist egoist commented Apr 23, 2019

A web UI (like phpMyAdmin) for popular databases like MySQL, MongoDB, PostgreSQL etc, you can use it to view all databases, tables, edit columns etc, this would be very useful for local development, it could potentially use TypeORM to manage databases.

Example usage:

# Let's call it `dbadmin` for now
$ dbadmin
> The web UI is available at http://localhost:3456
@egoist

This comment has been minimized.

Copy link
Owner Author

@egoist egoist commented Apr 23, 2019

The backend language you use to build this doesn't really matter, Rust? Probably better than Node.js but make sure you can find a good ORM.

@richardo2016

This comment has been minimized.

Copy link

@richardo2016 richardo2016 commented Apr 23, 2019

bookshelf is recommended to manage SQL like databases.

Maybe it's nice to allow pass option to use http server which isn't driven by NodeJS, to manage database. That is, the UI just provide one interface to the http server rather than a specific runtime/library like NodeJS/TypeORM

@egoist

This comment has been minimized.

Copy link
Owner Author

@egoist egoist commented Apr 23, 2019

@richardo2016 Yes, we can separate the UI and the API for database operations, the UI only needs to make REST or GraphQL calls to the API.

@daltondiaz

This comment has been minimized.

Copy link

@daltondiaz daltondiaz commented Apr 23, 2019

I think the UI can be both a build in web and one in electronics, today I use DBeaver for many databases (MySQL, PostgreSQL and MSSQL) in a single IDE, this helps me a lot.

@djyde

This comment has been minimized.

Copy link

@djyde djyde commented Apr 23, 2019

like phpmyadmin?

@daltondiaz

This comment has been minimized.

Copy link

@daltondiaz daltondiaz commented Apr 23, 2019

@djyde yes, like phpmyadmin or like Hue Hue demo .

@xialvjun

This comment has been minimized.

Copy link

@xialvjun xialvjun commented Apr 24, 2019

@evillt

This comment has been minimized.

Copy link

@evillt evillt commented Apr 24, 2019

It would be better if also have desktop(electron) app

@unix

This comment has been minimized.

Copy link

@unix unix commented Apr 24, 2019

@evillt It can be used in any envs if just a lightweight command-line tool.
only run $ dbadmin or $ npx dbadmin, its look coool.

@kenshinji

This comment has been minimized.

Copy link

@kenshinji kenshinji commented Apr 25, 2019

The backend language you use to build this doesn't really matter, Rust? Probably better than Node.js but make sure you can find a good ORM.

@egoist Rust, ORM...hmm, you mean this?

@lerencao

This comment has been minimized.

Copy link

@lerencao lerencao commented May 29, 2019

I had come across the same idea one year ago.
There is a project https://github.com/nodeadmin/nodeadmin written in angular, but it seems not maintained anymore.
I had searched other oss solutions, and found no good one which can suit my need:

  • should be web ui.
  • using user/pass of db to login in.
  • rich interface of ddl like the nodeadmin mentioned above.

Such project can be a killer of many desktop db managers like DBeaver.

@egoist egoist transferred this issue from egoist/ideas Oct 2, 2019
@egoist

This comment has been minimized.

Copy link
Owner Author

@egoist egoist commented Oct 18, 2019

@egoist egoist closed this Oct 18, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
9 participants
You can’t perform that action at this time.