Diwata
Diwata is a database interface for PostgreSQL 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
 - Infinite load-on-deman scrolling
 - Meaningful dropdown lookup
 - 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
 - Display of images and file attachments
 - Interactive/dynamic record count indicator for toolbar buttons
 - Loading indicators
 - Page transition animation
 - Search/filter on tables
 -  Table/Columns filtering based on privilege system.
- Display only tables that the user has privilege
 - 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]