ElectroCRUD 2

ElectroCRUD?

ElectroCRUD is Open Source Database CRUD (Create, Read, Update, Delete) Software. No Code Needed — Just in a few clicks, you can create a Database Admin/Dashboard/Whatever. Its Open Source — It's Free.

Why?

After a failed search for a basic admin panel that does not involve writing code or installs web-based solutions, I came up 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 of the project being inactive, I decided to bring it to life again. The codebase was built from scratch using Electron+Angular8. The new version contains most of the features of the first version, and new features are added on a weekly basis.

From version 2.7.0 SQLite has been added, currently its very limited support but we working on full support for next version.

Functionality

• [x] MySQL Support
• [x] PostgreSQL Support
• [x] SQLite Support (limited support, work in progress)
• [x] SSH Tunnels (Keys & Password)
• [x] Accounts (represent a database)
  • [x] Add / Edit
  • [x] Test connection (ssh, db)
  • [ ] Export / Import
• [x] Views (represent a table)
  • [x] Add new view & Edit view configurations
  • [x] Data table with pagination
  • [x] Search
  • [x] Permissions (C,R,U,D)
  • [x] Terminology
  • [x] Selection of columns to display or search by
  • [x] Add new record / Edit record
  • [x] Edit record
  • [x] Connect existing view as sub views
  • [ ] Export data in various formats like: csv, dump
• [x] Custom SQL Queries
• [x] Subviews (represent a sub table)
• [x] Views relations
  • [x] Drill from view to view (subview)
  • [x] Column based tables relation (left join)
• [x] View widgets (display aggragated data in the view)
  • [x] Add / Edit / Remove widgets
  • [x] Aggregation functions (AVG, SUM, MIN, MAX, COUNT)
  • [ ] Apply filters on widget data
• [x] View filters (build where clauses to filter the data)
  • [x] Add / Edit / Remove filter in each view
  • [x] One click apply / unapply on view data
  • [x] Simple & friendly interface to build where clauses
• [ ] Process manager (view running queries)
• [ ] Export / Import of all user accounts.
• [x] Themes
• [x] Log Console

Databases

• [x] MySQL/MariaDB
• [x] PostgreSQL
• [x] SQLite (Limited support)
• [ ] MSSQL
• [ ] Oracle

Download Binaries

• Mac OSX
• Linux
• Windows

Install via Package Managers

Homebrew/brew (Mac OS/X)

brew install --cask electrocrud

Download Sources

ElectroCRUD on GitHub

Videos

Screenshots

Build from source

npm install

With codesign

npm run electron:mac-win-linux

Without codesign

CSC_IDENTITY_AUTO_DISCOVERY=false npm run electron:mac-win-linux