Firstly, I started with the UI design and planned the full structure of the project. I wanted the website to feel modern, simple, and easy to use instead of looking like a typical complex database tool. So I first designed the homepage, navigation flow, and overall layout before moving into development.
I have created the Connect Database page, where users can choose between SQLite, MySQL, and PostgreSQL and connect quickly. Making support for 3 databases took time because each one had different connection handling and some errors came while testing.
Next, I developed the main Table Editor page, which is the core feature of the project. Here users can open tables, edit records, add rows, create new tables, add columns, and save changes directly. I wanted it to feel similar to spreadsheets so beginners can use it without learning SQL.
In the final stage, I polished buttons, spacing, colors, and overall user flow. This project taught me a lot about combining UI thinking with backend logic and turning an idea into a working product.
Still there’s a lot to learn like adding future possibilites like ER diagram, and primary key constraint and many more.
I will try to update this project if possible.
Thank You,
Regards,
Priyanshu
Log in to leave a comment
