|MySQL Conference and Expo April 14-17, 2008, Santa Clara, CA|
17. The Select schema window shows two items:
18. In the Schema
19. Move the Schema
20. In the main ViennaSQL window, enter the following SQL Query into the bottom pane. Then click the Execute (right arrow) icon (top, fifth from the left).
21. The query results are shown in the upper pane.
We have only scratched the surface of the powerful, general-purpose ViennaSQL GUI SQL client. We can develop and test our SQL queries, interactively, against test or live data. Once the queries are validated, we can literally copy/paste them to our CFMX programs. The Query we just executed was our (soon-to-be famous) Phone List.
There is much more you can do with ViennaSQL: create databases, create or alter tables, create views, etc. (depending on the capability of the specific database system). A more comprehensive treatment of ViennaSQL is beyond the scope of this article, but I suggest you review the documentation and spend some time experimenting with the program. It is time well invested and will be paid back many times over.
It needs to be said that using a powerful, interactive tool like ViennaSQL requires a certain discipline. It is possible, with a few keystrokes, to irretrievably delete (or modify) all of the records in a table, or even drop entire databases. Proceed responsibly!
I should also note that CFMX, ViennaSQL, and other programs can access the databases concurrently -- though some database systems may not support advanced RDBMS features such as transaction isolation, locking, rollback, and deadlock detection/avoidance. CFMX contains features that help prevent problems that can occur with concurrent database access and modification; other languages may not offer similar protection. My advice? You should limit your concurrent database access and modifications to the lowest-common-denominator of what is supported by the underlying database system and the individual programs and programming languages used to access it.
We will not cover the setup of ViennaSQL connections for each individual database system that we interface from this point on. But the procedure is the same for each database -- only the connection details are different. The connection details can be copy/pasted between the CFMX Administrator and ViennaSQL Connection configurator. If you plan to use the database at all, take a few moments and set up a ViennaSQL connection.
Where Do We Go from Here?
There are quite a few other databases that can be interfaced to our CFMX Mac OS X developer system, and many other related topics that we can explore. Here's your chance to contribute! Below is a list of topics that are on the "To Do" list. We want you, the readers, to prioritize them for us. If you don't see the topic you want, feel free to add to the list.
Dick Applebaum has been doing Web development since 1997, primarily with ColdFusion -- including his latest challenge to port ColdFusion MX to Mac OS X.
Return to the Web Development DevCenter.