CRUD?
Electron-builder (genrates executable for Windows,Mac and Linux, have server-less app auto-update feature,code signing, publishing etc, less boilerplate) electron-forge (genrates executable for Windows,Mac and Linux, it not just package apps but helps you create them as well, more boilerplate). Nov 04, 2019 On iOS, all apps must go through the App Store. On macOS, the Mac App Store is just one method of distribution and developers are free to publish their apps independently on their own website. 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. Building a Node application for all three platforms is pretty easy and I have done that a million times. Building my Electron app for Windows and Linux using the electron-builder is no rocket science either. In theory they should also run on MacOS. However I have never actually built an Electron app for MacOS. To build for production. In a windows terminal window- npm electron:windows; in a mac terminal window- npm electron:mac; in a linux terminal window- npm electron:linux; You will find the app build files in the 'app-builds' directory. Don't forget to deactivate the 'Developer Tools' by commenting win.webContents.openDevTools; in main.ts. Included Commands.
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 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.
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
- Custom SQL Queries
- 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
Install via Package Managers
Homebrew/brew (Mac OS/X)
brew cask install electrocrud Natal chart software for mac.
Download Sources
How to Video
Screenshots
Build from source
npm install
With codesign
Electron Mac Os Apps Built On Windows Access Download
npm run electron:mac-win-linux
Without codesign
CSC_IDENTITY_AUTO_DISCOVERY=false npm run electron:mac-win-linux