CRUD?
Create, Read, Update, and Delete (CRUD) are the four basic functions of persistent storage (Database).
Why?
After a failed search for a basic admin panel that not involves writing code or installs web-based solutions, I come with ElectroCRUD idea.
ElectroCRUD v1
The ElectroCRUD v1 was born in 2016, An Electron application that made it possible to create a friendly dashboard with data tables, search, widgets, filter & relations with few clicks without any experience in programming.
ElectroCRUD v2
After a few years that the project was inactive, I decided to bring it an alive again. The codebase was build from scratch using Electron+Angular8. The new version contains most of the features of the first version, and new features added on a weekly basis.
Functionality
SSH Tunnels (Keys & Password)
Accounts (represent a database)
- Add / Edit
- Test connection (ssh, db)
Export / Import - soon
Views (represent a table)
- Add new view & Edit view configurations
- Data table with pagination
- Search
- Permissions (C,R,U,D)
- Terminology
- Selection of columns to display or search by
- Add new record / Edit record
- Edit record
- Connect existing view as sub views
- Export data in various formats like: csv, dump - soon
Subviews (represent a sub table)
Views relations
- Drill from view to view (subview)
- Column based tables relation (left join)
View widgets (display aggragated data in the view)
- Add / Edit / Remove widgets
- Aggregation functions (AVG, SUM, MIN, MAX, COUNT)
- Apply filters on widget data - soon
View filters (build where clauses to filter the data)
- Add / Edit / Remove filter in each view
- One click apply / unapply on view data
- Simple & friendly interface to build where clauses
Process manager (view running queries) - soon
Export / Import of all user accounts. - soon
Databases
MySQL/MariaDB
PostgreSQL
MSSQL - soon
Oracle - soon
Need an alternative to ElectroCRUD? Read on. We've looked at the best ElectroCRUD alternatives available for Windows, Mac and Android.
Open-source database front-end similar to Microsoft Access with extensive database engine support.
Features:
Add your reviews & share your experience when using ElectroCRUD to the world. Your opinion will be useful to others who are looking for the best ElectroCRUD alternatives.
Table of Contents
Popular Alternatives
iOS Alternatives
Android Alternatives
Copyright © 2021 TopAlter.com
Sites we Love: AnswerBun, MenuIva, UKBizDB, Sharing RPP