Garry Lachman

Database CRUD application built on Electron

Pieter Geelen

diego

Open Source Collective

<p><img src="https://opencollective-production.s3.us-west-1.amazonaws.com/9e31b340-3e4b-11ed-a4c0-4ddd0565effb.png" /></p>
<h3>ElectroCRUD 2 (beta) <img src="https://opencollective-production.s3.us-west-1.amazonaws.com/9eb736f0-3e4b-11ed-a4c0-4ddd0565effb.svg" /></h3>
<p><a href="https://opencollective.com/redirect?url=https%3A%2F%2Fforthebadge.com"><img src="https://opencollective-production.s3.us-west-1.amazonaws.com/9f262560-3e4b-11ed-a4c0-4ddd0565effb.svg" /></a> <a href="https://opencollective.com/redirect?url=https%3A%2F%2Fforthebadge.com"><img src="https://opencollective-production.s3.us-west-1.amazonaws.com/9f7026b0-3e4b-11ed-a4c0-4ddd0565effb.svg" /></a> <a href="https://opencollective.com/redirect?url=https%3A%2F%2Fforthebadge.com"><img src="https://opencollective-production.s3.us-west-1.amazonaws.com/9fb8c870-3e4b-11ed-a4c0-4ddd0565effb.svg" /></a></p>
<h3>CRUD?</h3>
<p>Create, Read, Update, and Delete (CRUD) are the four basic functions of persistent storage (Database).</p>
<h3>Why?</h3>
<p>After a failed search for a basic admin panel that not involves writing code or installs web-based solutions, I come with ElectroCRUD idea.</p>
<p><a href="https://opencollective.com/redirect?url=https%3A%2F%2Fforthebadge.com"><img src="https://opencollective-production.s3.us-west-1.amazonaws.com/a0036600-3e4b-11ed-a4c0-4ddd0565effb.svg" /></a></p>
<h3>ElectroCRUD v1</h3>
<p>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 &amp; relations with few clicks without any experience in programming.</p>
<h3>ElectroCRUD v2</h3>
<p>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.</p>
<p><a href="https://opencollective.com/redirect?url=https%3A%2F%2Fforthebadge.com"><img src="https://opencollective-production.s3.us-west-1.amazonaws.com/a04cf220-3e4b-11ed-a4c0-4ddd0565effb.svg" /></a> <a href="https://opencollective.com/redirect?url=https%3A%2F%2Fforthebadge.com"><img src="https://opencollective-production.s3.us-west-1.amazonaws.com/a0a32870-3e4b-11ed-a4c0-4ddd0565effb.svg" /></a> <a href="https://opencollective.com/redirect?url=https%3A%2F%2Fforthebadge.com"><img src="https://opencollective-production.s3.us-west-1.amazonaws.com/a0ee6240-3e4b-11ed-a4c0-4ddd0565effb.svg" /></a> </p>
<h3>Functionality</h3>
<ul>
<li>[x] MySQL Support</li>
<li>[x] SSH Tunnels</li>
<li>[x] Accounts (represent a database)</li>
<li>[x] Add / Edit</li>
<li>[x] Test connection (ssh, db)</li>
<li>[ ] Export / Import</li>
<li>[x] Views (represent a table) </li>
<li>[x] Add new view &amp; Edit view configurations</li>
<li>[x] Data table with pagination</li>
<li>[x] Search</li>
<li>[x] Permissions (C,R,U,D)</li>
<li>[x] Terminology</li>
<li>[x] Selection of columns to display or search by</li>
<li>[x] Add new record / Edit record</li>
<li>[x] Edit record</li>
<li>[ ] Export data in various formats like: csv, dump</li>
<li>[ ] Views relations</li>
<li>[ ] One to one, One to many</li>
<li>[ ] Drill from view to view</li>
<li>[x] View widgets (display aggregated data in the view)</li>
<li>[x] Add / Edit / Remove widgets</li>
<li>[x] Aggregation functions (AVG, SUM, MIN, MAX, COUNT)</li>
<li>[ ] Apply filters on widget data</li>
<li>[x] View filters (build where clauses to filter the data)</li>
<li>[x] Add / Edit / Remove filter in each view</li>
<li>[x] One click apply / unapply on view data</li>
<li>[x] Simple &amp; friendly interface to build where clauses</li>
<li>[ ] Process manager (view running queries)</li>
<li>[ ] Export / Import of all user accounts.</li>
</ul>
<h3>Databases</h3>
<ul>
<li>[x] MySQL/MariaDB</li>
<li>[ ] MSSQL</li>
<li>[ ] PostgreSQL</li>
<li>[ ] Oracle</li>
</ul>
<h3>Download Binaries</h3>
<p><a href="https://github.com/garrylachman/ElectroCRUD/releases"><img src="https://opencollective-production.s3.us-west-1.amazonaws.com/a185c040-3e4b-11ed-a4c0-4ddd0565effb.svg" /></a></p>
<h3>Download Sources</h3>
<p><a href="https://github.com/garrylachman/ElectroCRUD">ElectroCRUD on GitHub</a></p>
<h3>Screenshots</h3>
<p><img src="https://opencollective-production.s3.us-west-1.amazonaws.com/a1b7f3d0-3e4b-11ed-a4c0-4ddd0565effb.png" />
<img src="https://opencollective-production.s3.us-west-1.amazonaws.com/a2161960-3e4b-11ed-a4c0-4ddd0565effb.png" /></p>
<p><img src="https://opencollective-production.s3.us-west-1.amazonaws.com/a2e29120-3e4b-11ed-a4c0-4ddd0565effb.svg" /> 
<img src="https://opencollective-production.s3.us-west-1.amazonaws.com/a3385240-3e4b-11ed-a4c0-4ddd0565effb.svg" />
</p>

ElectroCRUD

Database CRUD application built on Electron

Contributors

ElectroCRUD is all of us

Our contributors 3

About

Our team