TopAlter.com

ElectroCRUD Alternatives

ElectroCRUD Alternatives

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

Best ElectroCRUD Alternatives

Are you looking for alternatives to ElectroCRUD? Please see our top picks. In this article, we provide the list of some ElectroCRUD alternatives that will work on Windows and other platforms.

phpMyAdmin

phpMyAdmin

FreeOpen SourceWebPHP

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables...

MySQL Workbench

MySQL Workbench

FreeOpen SourceWindows

Provides data modeling, SQL development, and comprehensive administration tools for servers.

Features:

  • Database
  • GUI Designer
  • Server Management
  • Spell checking
DBeaver

DBeaver

FreemiumOpen SourceMacWindowsLinuxEclipseJava

DBeaver - Universal Database Manager and SQL Client. DBeaver is free and open source (GPL) universal database tool for developers and database administrators. ...

Features:

  • Data export/import
  • Autocompletion
  • Database Management
  • ER Diagrams
  • Foreign key linking
  • Function Key Shortcuts
  • Material design
  • Night mode/Dark Theme
  • PostgreSQL support
  • Restore on reboot
  • Support for Oracle
  • Built-in viewer
  • Clean design
  • Database Management
  • Dedicated Server Hosting
  • Export to CSV
  • MongoDB
  • Multiple DataBase
  • Night mode/Dark Theme
  • Portable
  • Smooth lines
  • Ssh tunnel
  • Tabbed interface
HeidiSQL

HeidiSQL

FreeOpen SourceWindows

Lets you view and edit data from MariaDB, MySQL, Microsoft SQL, or PostgreSQL databases.

Features:

  • Lightweight
  • Data export/import
  • Database
  • IDE
  • Night mode/Dark Theme
  • Portable
  • Server Variables Manager
  • Simple import
  • Ssh tunnel
Valentina Studio

Valentina Studio

FreemiumMacWindowsLinux

FREE native database manager for SQLite, MySQL, PostgreSQL, SQL Server and Valentina DB. PRO Edition adds Report Editor and Form Editor with JavaScripting and dozen...

Features:

  • Schema editor
  • Autocompletion
  • Import CSV data
  • Data export/import
  • Database
  • Database Management
  • ER Diagrams
  • Export to CSV
  • Mac Apps
  • MariaDB
  • Multi databases
  • Reporting
  • SQL Diff
  • Support for MS SQL Server
  • Visual Editing
Sequel Pro

Sequel Pro

FreeOpen SourceMac

Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases.

Features:

  • MySQL Support
  • User interface
  • Database Management
  • Lightweight
  • Support for Multiple Users
  • Native application
  • Ssh tunnel
  • Visual Query Builder
  • Web Development
LibreOffice - Base

LibreOffice - Base

FreeOpen SourceMacWindowsLinuxBSDPortableApps.com

Open-source database front-end similar to Microsoft Access with extensive database engine support.

Features:

  • Database
  • Database Management
  • Multiple languages
  • Portable
Adminer

Adminer

FreeOpen SourceSelf-HostedPHP

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the...

Features:

  • Lightweight
  • Php
DataGrip

DataGrip

CommercialMacWindowsLinux

DataGrip is a database IDE from JetBrains that is tailored to suit specific needs of professional SQL developers. — Intelligent query console Allows you to write...

Features:

  • Autocompletion
  • PostgreSQL support
  • Database
  • Database Management
  • Editable grid
  • Idea
Tableplus

Tableplus

CommercialMacWindows

TablePlus is a native app which helps you easily edit database data and structure. TablePlus includes many security features to protect your database, including native...

Features:

  • Data-management
  • Night mode/Dark Theme

Upvote Comparison

Interest Trends

ElectroCRUD Reviews

Add your reviews & share your experience when using ElectroCRUD to the world. Your opinion will be useful to others who are looking for the best ElectroCRUD alternatives.

Copyright © 2021 TopAlter.com

Sites we Love: AnswerBun, MenuIva, UKBizDB, Sharing RPP