Exment - Laravel Open Source Web Database Solution
Tags: laravel, database, news
Published: 2021-01-02 07:30:32

Hi! I'm Hiroshi Sato, and representative Kajitori Co., Ltd.

We want to introduce Open Source Solution **"Exment"**.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/87639o7lo7k0reyenv8e.png)

## Origin

Exment is web database and Open Source Solution based Laravel.
The concept is **"Web system that can manage anything"**.

When you manage a lot of data on company or organization, maybe you use Microsoft Excel or Google Spreadsheet.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/dpo6awv2uc3t2nxyzuee.png)

But, you keep to use these softwares, maybe you will happen big issues. 

### Problems when managing with multiple people

If some employees manage this data, maybe happens these problems.

#### Inputs wrong data
Ex. sheet column is **"contract price"**, But somebody inputs **"customer name"**.  


#### Mess of multiple files
Ex. Want to manage "customer data", but before you know it, creates these files,

    - customer_data.xslx
    - customer_data2.xslx
    - customer_data_new.xslx
    - customer_data_reallynew.xslx
    - customer_data_20210102.xslx

**Can you select newest customer file??** Perhaps, we cannot.

#### Break file  
Sometimes, Microsoft excel file is broken. So, We rollback or create file again. It's too lost time.


### Difficult to utilize the entered data
If you want to use other system or data, but it's difficult.  
Ex, you have "customer" excel file, and you want to use other accounting system, but it's difficult. Maybe, you have to input accounting system watching "customer" excel file.



### Too expensive existing system
So, you want to append existing web database system, for example, Salesforce, Microsoft Dynamics.
But, it's too expensive, for small and medium-sized enterprises, ex. startup project or venture company.


## Developed OpenSource System
So we developed web database system, **AS OPEN SOURCE**.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/87639o7lo7k0reyenv8e.png)

Exment is Open Source Solution based Laravel. License is GPL-3.0. Please see [GitHub](https://github.com/exceedone/exment).

### Screenshot

#### Data List
Showing data list on browser.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/pseo6ozux98hr29bod9m.gif)

#### Data Show and Edit
If user clicks data row, showing data detail, and edit.
Of course, user can create data.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/74ugczkb7mqr0m01ypl2.gif)


#### Data Search
User can search all data. 
And user can search relation. For example, showing "estimate" list related "customer".
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/h64buodv895d4admjeke.gif)


#### Table Definition
System administrator can append table definition. Append-modify-delete table, append-modify-delete table's column,  etc.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/2wa5ncami5im6qky5i9s.gif)


### Merit

#### A lot of Functions
Exment has a loooooot of functions and can use free.

- Web database definition change
- Data list display
- Data addition / editing / display
- Batch import / output of data
- Data update settings
- Composite unique key settings
- Compare two columns
- Data interlocking setting
- Related refinement settings
- Document output (Excel format)
- Data sharing
- Restore deleted data
- Dashboard
- Calendar view
- Aggregate view
- template
- Authority management
- Add your own plugin
- Addition of original document format
- Web database template management
- Notification processing
- Data replication
- automatic numbering
- Value calculation on the screen
- Data and system backup / restore
- Change login method (Google account, Office365 account ...)
- API cooperation
- Data view sort order setting
- Workflow
- etc....


#### Append function as Plugin

And we can append function as Plugin(such as WordPress).
If use it, we can execute such as functions.

- If we want to append function as "Search YouTube play, like, dislike result", Append **Page Plugin**.
![YouTube Search](https://qiita-user-contents.imgix.net/https%3A%2F%2Fqiita-image-store.s3.ap-northeast-1.amazonaws.com%2F0%2F204834%2Fc5996da9-8d6f-ce7a-f5ad-2bb195b90f0b.png?ixlib=rb-1.2.2&auto=format&gif-q=60&q=75&w=1400&fit=max&s=59e33c14d06bd87c280eb01cae159622)

- If you want to append function about clicking button on customer data page, and when clicking button calls syncing customer data to other system (Ex. accounting, task, estimate system - Not Exment), we can append **Button Plugin**.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/ptwr9thrjjpbsmntygdd.png)

Developers only develop **you want to expand function**. 
If we develop as full scratch system, we need very very high cost and time. But we use Exment as platform, we only save very low them. 
And Exment adopts language PHP, and framework laravel. A lot of engineer can develop PHP, so it's easy developing expanding plugin.
We also show how to develop and upload plugin. Please see [here](https://exment.net/docs/#/plugin).


#### Operate on On-Premiss environment
Now many systems operate on crowd environment. But, some data or companies cannot use crowd, because ex. confidential data. 
Exment can operate On-Premiss environment, and can operate **"Completely blocked"** On-Premiss environment.
So Exment can adopt those some data or companies easily.

And, Exment operates LAMP, So very easy setting up environment.

## Conclusion
Exment is very useful and powerful and can expand system.
Please install, use, feedback, and pull requests!

We are Japanese and now using Exment users are almost Japanese. We support English and has English manual, but maybe English is wrong, sorry. Please tell us wrong English.

**We WANT Exment to be like WordPress**. 
WordPress is very very major, useful, and can expand system.
We want Exment to do the same in the field of web databases. We are convinced that it is a system with such a future.

Thanks reading this post!!! 


## Links
- [GitHub](https://github.com/exceedone/exment)
- [Manual](https://exment.net/docs/#/)