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

egoist / sponsors

Open-source project suggestions powered by my sponsors.

7 stars 0 forks source link

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

Closed egoist closed 4 years ago

egoist commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

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 commented 5 years ago

@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 commented 5 years ago

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 commented 5 years ago

like phpmyadmin?

daltondiaz commented 5 years ago

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

xialvjun commented 5 years ago

have a look at https://github.com/KyleU/databaseflow

2nthony commented 5 years ago

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

unix commented 5 years ago

@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 commented 5 years ago

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?

nanne007 commented 5 years ago

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 commented 4 years ago

This issue was moved to https://egoist.chat/t/a-web-ui-for-popular-databases-like-mysql-mongodb-postgresql/20