Database designer for web developers and beginner
Tags: web, database, mysql, php
Published: 2019-11-05 18:52:18

---
title: Database designer for web developers and beginner
published: true
description: I have ambitious to make database tools cheap and free for everyone 🇲🇨.
tags: web, database, mysql, PHP
---
This project start from my hobby in programming. Some day in january 2019 when i develop new project in my office. In this project i use MySQL for database engine. I use MySQL Workbench for develop database diagram. But you know there are many bug in MySQL workbench. Some time i can’t open my project file because file corrupt😰. I so sad about this, I angry but i can’t do any more. I don’t have money to buy paid SQL design tools like navicat. Because this problem i have a vision to build free database design for startup, individual with high feature of software like paid software. I start this project with code name https://dbdesigner.id in Github repository. I do this project in day off from my work office. After 8 month as side project in weekend project, i can release beta version this product in https://dbdesigner.id/app.

I have vision to make database tools are free for anyone who limited money.


This project focus to help web developer and beginner in database to design relational database quick and easy to learn. Just use double click this design can export to SQL create, SQL drop and Image.

This is simple https://dbdesginer.id design panel. This show how to design table and relation between Author and Book. One Author can have many Book.

![Alt Text](https://thepracticaldev.s3.amazonaws.com/i/212ztsc051dymxhv22bv.png)


**Drop Table Field :**
In the result of drop table you can copy and paste this SQL script to MySQL database CLI or PHP My Admin.

![Alt Text](https://thepracticaldev.s3.amazonaws.com/i/3a8ol9rstm5eksl450sz.png)

**Create Table Script :**
Don’t worry about how to create physical database in My SQL. Just click SQL Export and select SQL Create, you can got SQL Script to build table.
![Alt Text](https://thepracticaldev.s3.amazonaws.com/i/fz4gmad0tv6mncy0ld2t.png)


**Export to Image :**
Simple SQL export to image give every developer easy to get image from this design without take screen shoot in design area.
![Alt Text](https://thepracticaldev.s3.amazonaws.com/i/8rmmchscjfvvjv763v48.png)


**Example Project**
For give quick to learn about how to use dbdesigner.id the developer can try example project in this link https://dbdesigner.id/app?uuid=2c786d95-fdfd-4ab8-a750-54cd300d49a2. Developer will direct to example project, developer must fork to edit and use this example project for learn more.

![Alt Text](https://thepracticaldev.s3.amazonaws.com/i/ekyu2r2tybhlll0c95qf.png)

**Easy to share with classmate**
Project collaboration is hard when you do this with traditional work flow like use USB flash, Email and etc. Dbdesigner.id use modern workflow for collaboration, it like collaboration in google docs. All of your friend can view your project using magic link. Access this feature can access in **File > Properties > Status Share**. Change this status from private to public.

![Alt Text](https://thepracticaldev.s3.amazonaws.com/i/sijd3cce01f0zfnafy0z.png)

Thank you very much for your attention. I hope i can contribute this little application for one of part opensource project. And I want to make smile for any one use this application. 😊😊😊

The original post in : https://medium.com/@didin1453fatih/database-designer-for-web-developers-and-beginner-1a3ab3c63323