Skip to content
Database CRUD Application Built on Electron | MySQL, Postgres
TypeScript CSS HTML JavaScript
Branch: master
Clone or download
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github Update issue templates Jul 22, 2019
docs docs Jul 21, 2019
e2e fix(e2e): add mocha types Apr 14, 2019
src ssh tunnel fix, ssh tunnel keys, splash, frameless draggable window Aug 13, 2019
.DS_Store splash, frameless ui, upgrade electron Aug 12, 2019
.editorconfig Merge remote-tracking branch 'angular-electron/master' into dev-v2 Jun 23, 2019
.gitattributes init May 14, 2016
.gitignore ignore whhg example Aug 2, 2019
.travis.yml Remove Node.js v12. May 8, 2019
CHANGELOG.md [Bumped Version] 6.0.1 May 31, 2019
LICENSE.md refactor: upgrade to NodeJS 8, Angular 6, CLI 6, Electron 2.0, RxJS 6.1 May 18, 2018
README.md readme update Aug 13, 2019
_config.yml Set theme jekyll-theme-architect Apr 12, 2017
angular.json new icons Aug 2, 2019
browserslist ref/ upgrade Angular 8 and Electron 5 May 31, 2019
electron-builder.json change mac build to ElectroCRUD Jul 11, 2019
logo-angular.jpg v1.0.0 Apr 2, 2017
logo-electron.jpg v1.0.0 Apr 2, 2017
main.ts ssh tunnel fix, ssh tunnel keys, splash, frameless draggable window Aug 13, 2019
package.json ssh tunnel fix, ssh tunnel keys, splash, frameless draggable window Aug 13, 2019
postcss.config.js upgrade lib version Sep 9, 2017
postinstall-web.js ref/ postinstall web & electron Jun 27, 2018
postinstall.js ref/ postinstall web & electron Jun 27, 2018
splash-screen.html ssh tunnel fix, ssh tunnel keys, splash, frameless draggable window Aug 13, 2019
tsconfig-serve.json accounts + ipc + store Jun 26, 2019
tsconfig.json bugsnag Jul 22, 2019
tslint.json alphabetized and formatted Jun 2, 2019

README.md

ElectroCRUD 2 GitHub Release Date Open Collective backers and sponsors

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.

forthebadge

Functionality

  • MySQL Support
  • PostgreSQL Support
  • SSH Tunnels (Keys & Password)
  • Accounts (represent a database)
    • Add / Edit
    • Test connection (ssh, db)
    • Export / Import
  • 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
  • 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
  • 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)
  • Export / Import of all user accounts.

Databases

  • MySQL/MariaDB
  • PostgreSQL
  • MSSQL
  • Oracle

Download Binaries GitHub release

Download Sources

ElectroCRUD on GitHub

How to Video

How to use

Screenshots

GitHub All Releases GitHub package.json version Analytics

You can’t perform that action at this time.