ElectroCRUD

Open source

Database CRUD application built on Electron

Contribute


Become a financial contributor.

Recurring contribution

Backer

Become a backer for $5.00 per month and support us

Starts at$5 USD / month

Recurring contribution

Sponsor

Become a sponsor for $100.00 per month and support us

Starts at$100 USD / month

Custom contribution

Donation

Make a custom one-time or recurring contribution.

Latest activity by


Top financial contributors

1
Pieter Geelen

$20 USD since Oct 2019

2
diego

$5 USD since Mar 2020

ElectroCRUD is all of us

Our contributors 3

Thank you for supporting ElectroCRUD.

Pieter Geelen

$20 USD

Great tool, I am excited that the project has b...

diego

$5 USD

Budget


Transparent and open finances.

$
Today’s balance

$20.80 USD

Total raised

$20.80 USD

Total disbursed

--.-- USD

Estimated annual budget

--.-- USD

About


ElectroCRUD 2 (beta)

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. Many of the original functionality is still missing, but I'm working to cover backward compatibility.

Functionality

  • [x] MySQL Support
  • [x] SSH Tunnels
  • [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
  • [ ] Export data in various formats like: csv, dump
  • [ ] Views relations
  • [ ] One to one, One to many
  • [ ] Drill from view to view
  • [x] View widgets (display aggregated 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.

Databases

  • [x] MySQL/MariaDB
  • [ ] MSSQL
  • [ ] PostgreSQL
  • [ ] Oracle

Download Binaries

Download Sources

ElectroCRUD on GitHub

Screenshots

Our team