ivanceras / Diwata
Licence: apache-2.0
A user-friendly database interface
Stars: ✭ 386
Programming Languages
rust
11053 projects
Projects that are alternatives of or similar to Diwata
React Antd Admin
用React和Ant Design搭建的一个通用管理后台
Stars: ✭ 1,313 (+240.16%)
Mutual labels: database-management, database, database-gui
App
Directus Admin Application — An Intuitive WebApp for Managing Database Content
Stars: ✭ 464 (+20.21%)
Mutual labels: database-management, database, database-gui
Directus Docker
Directus 6 Docker — Legacy Container [EOL]
Stars: ✭ 68 (-82.38%)
Mutual labels: database-management, database, database-gui
Docker
Directus Docker — The Official Docker Container for the Directus Suite
Stars: ✭ 93 (-75.91%)
Mutual labels: database-management, database, database-gui
Sdk Js
Directus JS SDK — JavaScript Software Development Kit for Node and Browser
Stars: ✭ 117 (-69.69%)
Mutual labels: database-management, database, database-gui
Obevo
Obevo is a database deployment tool that handles enterprise scale schemas and complexity
Stars: ✭ 192 (-50.26%)
Mutual labels: database-management, database, postgresql
Postgres Operator
Production PostgreSQL for Kubernetes, from high availability Postgres clusters to full-scale database-as-a-service.
Stars: ✭ 2,166 (+461.14%)
Mutual labels: database-management, database, postgresql
Postgui
A React web application to query and share any PostgreSQL database.
Stars: ✭ 260 (-32.64%)
Mutual labels: database, postgresql, database-gui
Erd
A Rails engine for drawing your app's ER diagram
Stars: ✭ 296 (-23.32%)
Mutual labels: database-management, database
Sql exporter
Database agnostic SQL exporter for Prometheus
Stars: ✭ 301 (-22.02%)
Mutual labels: database, postgresql
Squeal
Squeal, a deep embedding of SQL in Haskell
Stars: ✭ 308 (-20.21%)
Mutual labels: database, postgresql
Psycopg3
New generation PostgreSQL database adapter for the Python programming language
Stars: ✭ 278 (-27.98%)
Mutual labels: database, postgresql
Dbeaver
Free universal database tool and SQL client
Stars: ✭ 23,752 (+6053.37%)
Mutual labels: database, postgresql
Pgquarrel
pgquarrel compares PostgreSQL database schemas (DDL)
Stars: ✭ 274 (-29.02%)
Mutual labels: database, postgresql
Gokv
Simple key-value store abstraction and implementations for Go (Redis, Consul, etcd, bbolt, BadgerDB, LevelDB, Memcached, DynamoDB, S3, PostgreSQL, MongoDB, CockroachDB and many more)
Stars: ✭ 314 (-18.65%)
Mutual labels: database, postgresql
Rel
💎 Modern Database Access Layer for Golang - Testable, Extendable and Crafted Into a Clean and Elegant API
Stars: ✭ 317 (-17.88%)
Mutual labels: database, postgresql
Dbq
Zero boilerplate database operations for Go
Stars: ✭ 273 (-29.27%)
Mutual labels: database, postgresql
Ansible Role Postgresql
Ansible Role - PostgreSQL
Stars: ✭ 310 (-19.69%)
Mutual labels: database, postgresql
Pgloader
Migrate to PostgreSQL in a single command!
Stars: ✭ 3,754 (+872.54%)
Mutual labels: database, postgresql
Diwata
Diwata is a database interface for PostgreSQL,Mysql, Sqlite with the goal of being usable, user-friendly with its basic and advanced functionality be discoverable by the user.
Demo
Quick local demo setup using sqlite sakila.db
Use the nightly compiler.
git clone https://github.com/ivanceras/diwata
cd diwata
git submodule update --init --recursive
./run_sqlite_sakila.sh
open http://localhost:9000
Features
- Automatic display of direct and indirect linked record
- Freeze column and freeze rows
- Infinite scrolling / loading of page on scrolling
- User friendly granular search and filter
- Diplay descriptive referred records. (ie: Instead of displaying the foreign_key value integer or uuid, display the referred records in such a way it is distinguisable by the user)
- Well integrated with the browsers, clickable tables, records and tabs can be openned in a new window and displays the data as though clicking on it.
Roadmap checklist:
- [ ] Basic data display
- [X] Infinite load-on-deman scrolling
- [ ] Meaningful dropdown lookup
- [X] Seamless url-based navigation
- [ ] Delete records
- [ ] Update records
- [ ] Insert records
- [ ] Detail record update/insert, delete link detail records [ ] Filtering and searching on has_many and indirect records for detailed record
- [ ] Undo update/delete records (upon deletion/modification, user have a grace period to undo the changes)
- [ ] Search and filter data
- [ ] Drag/Rearrange and resize columns
- [ ] Multi column sorting
- [ ] Smart delete cascade messages
- [ ] Error Handling/Error messages display
- [ ] Advanced filtering, where user can type in the logic for filtering
- [X] Display of images and file attachments
- [ ] Interactive/dynamic record count indicator for toolbar buttons
- [X] Loading indicators
- [ ] Page transition animation
- [ ] Search/filter on tables
- [ ] Table/Columns filtering based on privilege system.
- [X] Display only tables that the user has privilege
- [X] Display only columns that the user has privilege
- [ ] An interface for superusers to set user privileges for each tables
- [ ] Row level security
- [ ] When the server is configured to require user login, the user will be forced to login
- [ ] Plugin and module system
- [ ] Custom validation on field
- [ ] Custom buttons for application specific functionality
Notes:
[1]: You can use sakila database dump as demo database https://github.com/ivanceras/sakila
Patreon:
Please support me on patreon, so I can dedicate more time to the development of this project
Contact me:
ivanceras [a t] gmail.com
Contributors
This project exists thanks to all the people who contribute.
Backers
Please be a backer of this project! 🙏 [Become a backer]
Sponsors
Support this project by becoming a sponsor. Your logo will show up here with a link to your website. [Become a sponsor]
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].