this is a very useful tool which will make the creation of complex SQL tables easier. the automated command generation is brilliant.

This would have been a godsend when I was in college and learning PHP/MySQL from scratch for the first time. Typing in MySQL commands by hand is tedious and the slightest mistake can ruin any coders day. A application like this that takes care of the tediousness of coding seems invaluable. You mention its usefulness for complex databases, but I would also argue that it is an excellent tool for novice coders. The interface and graphical representation of the databases would be useful for novice coders, and having such a program would eliminate many of the depressing coding errors that manage to bog down even the most experienced coders.

I have studied IBM Mainframe and knows how important SQL is. It is very tedious to write the code without making mistakes. I think SQLEditor could be useful when lots of tables and data are involved.

I’ve used Microsoft Access before to make databases. When the database file becomes too big the program becomes so slow. It is quite easy to learn and use though. SQLEditor seems to be an easy way to transition from Access to mysql.

I haven’t previously used SQL Editor, but I am going to explore the idea of doing so now. Thanks!

This is a more user friendly application, better than the tools that come from SQL Server.

Though this will likely need to be able to create sql that is specific to the different flavors of SQL: MS SQL Server, MS Access, Foxpro, Sysbase,etc.

A UI tool like SQL editor is always useful. For complex databases the development start from the ER diagrams and a utility which can convert the diagram to the tables is really useful. It can save lots of time, its importance can be really appreciated in time critical development. It has the potential to remove lots of typos that we inherently make.

I really think this could save me a ton of time designing table structures, thanks for the link!

While I am not a Mac user this tool looks very similar to tools similar to many Entity/Relationship modeling tools that currently exist for the Wintel platform.

ER Diagrams are useful for the simple reason that a picture is worth a thousand words. A graphical representation is easier to look at and understand than SQL DDL statements.

It looks like SQLEditor is a tool that allows you to create a graphical representation of your database and then create the SQL DDL (Data Definition Language) statements to create that actual tables in a target database.

Again, I am not very familiar with the Mac environment and am not aware of any similar tools, but I would have to think they exist.