ElectroCRUD icon
ElectroCRUD icon

ElectroCRUD

 4 likes

Open Source SQL Database CRUD Application Built on Electron.

ElectroCRUD screenshot 1

License model

  • FreeOpen Source

Application type

Platforms

  • Mac
  • Windows
  • Linux
4 / 5 Avg rating (2)
4 likes
2comments
0 news articles

ElectroCRUD News & Activities

Highlights All activities

Recent activities

Show all activities

ElectroCRUD information

  • Developed by

    Garry Lachman
  • Licensing

    Open Source (MIT) and Free product.
  • Written in

  • Rating

    Average rating of 4
  • Alternatives

    75 alternatives listed
  • Supported Languages

    • English

AlternativeTo Categories

Office & ProductivityDevelopment

GitHub repository

  •  1,539 Stars
  •  307 Forks
  •  12 Open Issues
  •   Updated Oct 7, 2023 
View on GitHub

Our users have written 2 comments and reviews about ElectroCRUD, and it has gotten 4 likes

ElectroCRUD was added to AlternativeTo by garrylachman on Aug 16, 2019 and this page was last updated Aug 17, 2019.

Comments and Reviews

   
 Post comment/review
Garry L
  
Top positive commentAug 16, 2019

Great application

-1
Guest
  
ReviewJan 27, 2022

Not already used

0

What is ElectroCRUD?

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

ElectroCRUD Videos

Official Links