Using MySQL with Aptana
Aptana 2.0 no longer ships with Aptana PHP or the Database tools included by default. You need to install the PDT plugin for PHP development, and the Quantum Database plugin for managing database connections.
To install the Quantum Database Utilities, in Aptana open Help > Install Additional Features. Under Featured Plugins, select Quantum Database Utility and click Install. Select the features and click Next. Click Next again, accept the license agreement and click Finish. When installation finishes, restart Aptana.
Use the same process to install the PHP Development Tools (PDT) and the PHP Debugger Binaries. I also installed jQuery Support.
To add a database bookmark, open the Quantum DB Perspective. If you don’t have the icon for this perspective already, click Window > Open Perspective > Other and select Quantum DB. Right-click on the (Internal) Derby bookmark or click the Add Bookmark icon in the Database Bookmarks pane.
If you haven’t already, add the MySQL JDBC driver by clicking Add Driver. Click Add External Jar and locate your jdbc jar file, you shoud have saved it in /Library/Java/Extensions. Click Browse and select com.mysql.jdbc.Driver then click Ok then Finish.
Back at the New Bookmark dialog, select the MySQL JDBC driver and click Next. Enter your MySQL username and password. Leave the hostname and port as is, then enter the name of the database. When you click Finish you should be able to browse your database tables.
The functionality of Quantum DB Utilities is disappointing. Apart from browsing tables and manually enter SQL statements, the only editing functionality is table data. phpMyAdmin is more useful.
I would pay money not to get jammed so hard as Aptana jammed everyone on the upgrade from 1.5 to 2.0.
It’s cost me hours.
Documentation all over the web refers to 1.5 or below.
I realize it’s free. I realize it’s caveat emptor.
Still, they could have made this so much better. It’s not that hard to communicate.
I find the new conventions for both PHP and mySQL to be tedious and faintly pompous. As a community, we’ve dealt with database CONNECTIONS for 30 years. Now we call them “bookmarks?” How arrogant.
Yeah, quantum is really, really disappointing.
I’ll do the Aptana developers the ultimate favor of just going away.
I purchase a lot of software, but Aptana doesn’t have a reasonable pricing structure for me. And after this debacle, I wouldn’t trust them very much.
hey thanks for the info…