[SSS]

As an experienced ASP developer, I can tell you that MySQL is a great database backend with IIS/ASP. WebYog won't interfere since it is a direct connection to your database.

A few suggestions:

1) For ASP, use an ODBC connection instead of a DSN. MySQL reads ODBC calls VERY QUICKLY, and this saves your Windows server from doing a registry lookup for the DSN which ultimately means faster connections under heavy loads. Good book on ASP/vb script: Wrox press Beginning ASP 3.0 (getting tougher to find nowadays).

2) CLOSE ALL RECORDSET,COMMAND AND CONNECTION OBJECTS — at the end of every asp page. This keeps things clean and prevents lockups (yes, even if you are using connection pooling on your Windows server).

3) Run your MySQL on a linux box and connect to it from your Windows server if possible. This works much better than using MySQL on the same box as your Windows Server (MySQL can be a resource hog on some Windows configurations, better scaling on linux, security, data is separate from application, etc).

4) If you are using an insecure connection to your database server via webyog, I strongly suggest you use a secure connection by using an SSH client. I recommend using PuTTY because it's free and easy to use:PuTTY – a free SSH client tool

Here's instructions from the MySQL site on setting up your SSH connection: Connecting to MySQL Remotely from Windows with SSH

PuTTY isn't very intuitive to set up for a newbie, so here's some extra advice:

Session: select SSH, type in host name or IP address.

Skip the Terminal & Window categories — default should be okay.

Connection: if you go through Proxy, click on it to configure.

– Click on SSH; select “SSH2 only” as preferred.

– Click on Tunnels; under port forwarding/add a new port: Source port = “3306” Destination = “[host name or IP address]:3306” select the “local” radio button

Go back to the session category, type in a session name and click save.

Now as long as you have local access on your MySQL server and a system user account with sufficient rights, you can now open PuTTY, load the session, and type in your user name and password.

Now open webyog, use “localhost” as your MySQL host address, type in your user name/password, and your good-to-go with a secure SSH tunnel to your database server!

Good luck! 😀

[SSS]

Swwweeeeeeet!!! 😀

[SSS]

Although Shadow misunderstood Benny's question at first, he/she does bring up a good point: forms.

I think this tool would become an even more formidible software solution if it had forms capability like MS Access does. For a relatively complex normalized database (20 tables all related to each other in various ways), we are often forced to create a web front-end to ensure that data is inserted/updated correctly. It would be great if we could create forms designed to update multiple tables that are idiot-proof on the end user side without the time it takes to write code for web-based applications.

I have to admit that I was once a MS Access user (back in school) and despite the severe shortcomings of the Access database, Access forms were an excellent data-input interface because 1) they were easy to create, 2) easy to set up rules for, 3) easy to lock down for the end-user and most importantly, 4) because they were intimately tied to the underlying database, they automatically maintained data integrity through foreign keys, cascade updates/deletes, relationships, etc. — making multi-table updates a breeze.

With the addition of forms, sqlyog would not only be a complete management tool, but also a very powerful data entry tool! I sure hope it's in the works.

[SSS]

Thank you, Ritesh for giving us a roadmap! I know this will help us all understand the direction of the product. One last question: When the Max version comes out sometime in December, will the “regular” (i.e. 3.x) series continue? Or will it just be Lite and Max versions at that point?

Thanks!! 😀

[SSS]

Thanks Ritesh!

😀

[SSS]

If you are using Windows to connect, I suggest you use PuTTY, a free SSH tool that will connect to MySQL securely.

PuTTY, latest version is 0.53b (is pretty stable and works great!)

PuTTY: A Free Win32 Telnet/SSH Client

David Carlson has a great mini-tutorial on SSH in the MySQL.com documentation:

2.6.2.4 Connecting to a Remote MySQL from Windows with SSH

2.6.2.4 Connecting to a Remote MySQL from Windows with SSH

[SSS]

When will we know more about future development? What about the pro version? What will the “regular” price be as compared to the “introductory” price?

My company will not make any purchase decisions and I am afraid that we might go with another vendor or keep the old 3.11 until we know more about your product plans.

I think answering these questions would also curb the flame posts on this topic.

Thanks!! 😀

[Author]

Posts