search

hitontology / database-frontend

HITO Flask-SQLAlchemy Database Frontend
MIT License
0 stars 0 forks source link

Systemauswahl #1

Closed ThomasPause closed 4 years ago

ThomasPause commented 4 years ago

We need a frontend for our database that conforms to our system specification at https://github.com/hitontology/database-frontend/issues/2. For this, the first idea is to use an existing approach. Investigate!

ThomasPause commented 4 years ago

here is a good comparison: https://scalegrid.io/blog/which-is-the-best-postgresql-gui-2019-comparison/ it says, that pgadmin4 and dbeaver are the best tools, pgadmin4 comes as a docker container version (https://hub.docker.com/r/dpage/pgadmin4/) but this link is down..

ThomasPause commented 4 years ago

another list: https://wiki.postgresql.org/wiki/PostgreSQL_Clients#Web_Clients again, are in front there also, SIDU seems to be pretty nice (http://topnew.net/sidu/) another alternative could be Hisha (https://github.com/xshogi/hisha) but the main problem is that it is made for IT people and we need a more 'userfirendly' thing

ThomasPause commented 4 years ago

the proposed solution Oracle Forms is a proprietary software solution, but a free alternative is Libre Office Data. I will try this, because it also supports forms etc.

ThomasPause commented 4 years ago

lo_base_with_hito

ThomasPause commented 4 years ago

Pro: seems to be easy usable, many assists for userfriendly experience, configured in short time Contra: not a web based solution (but reads/writes from/to server backend), needs to be installed on devices

ThomasPause commented 4 years ago

form

a form for inserting new catalogues and to scroll existing (Design is flexible, just as an idea)

ThomasPause commented 4 years ago

query

also regular querying is possible..

KonradHoeffner commented 4 years ago

Are there good frontends for TerminusDB?

I asked people who know the team:

[...] very good developers, so I am sure terminusdb has a good core. Not sure if it is convenient/business-mature

KonradHoeffner commented 4 years ago

Maybe this is helpful https://news.ycombinator.com/item?id=16508965.

KonradHoeffner commented 4 years ago

https://dev.to/ekafyi/the-most-simple-stack-to-create-a-web-app-for-public-use-4fij

KonradHoeffner commented 4 years ago

https://firebase.google.com/ It's likely not right for us:

FireBase is a NoSQL database. Data stored/processed in a cloud. ... Unlike SQL there's no schema for the database, no tables, no columns, it's just a combination of key/value pairs. It is quit fast in response in comparison to MySQL as it stored the information in the JSON objects.

KonradHoeffner commented 4 years ago

See also:

KonradHoeffner commented 4 years ago

I am investigating the Flask framework for Python. There is also the https://github.com/dpgaspar/Flask-AppBuilder.

KonradHoeffner commented 4 years ago

Developing a prototype using Flask-AppBuilder, see https://flask-appbuilder.readthedocs.io.

KonradHoeffner commented 4 years ago

Flask-AppBuilder can show other tables using their labels as a multi selection field and allows search and CRUD, so a custom solution using Flask-AppBuilder is the choice.