Best database design / improvement workflow

Zagrava

How should I organize my workflow so that I can quickly design & modify my database structure? I have tried pgAdmin, but it seems to me that writing sql scripts would be faster.

I want to be able to write my CREATE TABLE queries, and my environment would parse them, modify database tables' structure for me, copy the data where it's possible (for columns that remained intact), and returned modified database to me, Is similar environment exist?

If not, then what kind of workflow you use / advice?

NogDog

On possibility would be if you built you application on a framework such as Laravel in PHP (or similar things like Rails for Ruby) where you can use its relevant commands to both build the database tables and their relevant models concurrently. I would not advise that simply as a way to do that, but rather leverage it if it makes sense to you to build your application with such a framework.

Otherwise, I often use pgAdmin to start building things, then view the SQL associated with a "thing", copying it and modifying it into SQL and/or PHP scripts which I can then customize to my heart's content to make re-usable tools. 🙂

VITSUSA

I agree with NogDog, this is a good idea which you can follow 🙂