Sunday, October 28, 2012

Execute Sql KDevelop Plugin

Lot of stuff happened at the Kate/KDevelop sprint in Vienna. (Thanks again to Joseph and KDE e.V. for sponsoring the sprint)

One small - but still useful - thing is the first public beta release of the kdev-sql plugin. It allows you to execute SQL queries from within KDevelop. Simply press Ctrl+E (or Run->Execute SQL) to execute the contents of the current file as SQL query.

The only use case this is trying to solve is debugging and performance testing of queries.






Database connections can be configured per project - all QtSql divers are supported.


Get the script here: kdev-sql-1.3.80.tar.bz2
(compatible with KDevelop 4.4)

In future other features like schema browsing and autocompletion could be implemented...

KDevelop XDebug - PHP Debugger Beta Release

It has been a pretty long time since the first beta release of XDebug. I picked up the plugin again and adapted it to work for the current version of KDevelop.
To get it working you need:
  • Php + xdebug extension
  • xdebug configured to accept remote connections
    • xdebug.remote_enable = 1
    • xdebug.remote_host = localhost (yourhost if on remote server)
  • KDevplatform 1.4, KDevelop 4.4
  • The following KDevelop Plugins: 
    • kdev-executebrowser
    • kdev-xdebug

Configuring and using the debugger didn't change, use steps described in my last blog post


And for the future: yesterday we merged the unittests branches Miha Čančula wrote - and guess what: you can debug PHPUnit tests using xdebug.

Thursday, October 25, 2012

KDevelop Project and Filesystem view improvements

Since I'm from Austria I had to attend the KDevelop/Kate sprint which is held in Vienna this year. Thanks to Joseph for organizing the sprint. We are having a great time here - hacking all day long...

After two days I have been productive and implemented a few small but still possibly useful features.

Since quite some time the project view supports moving items using drag and drop.  However copy was not supported. I added there a drop menu allowing you to copy - and as a side effect also allow you to cancel an accidental move operation.



The second new feature is similar: it gives you the possibility to copy/paste items in the project view through the clipboard. Even pasting files that where copied eg. in dolphin is supported.



The third one is bookmark support for the filesystem view - just a kate has it. The bookmarks are stored per session. This can be useful for web developers to store the fish:// locations of test/production servers for quick access.



And last but not least, it is now possible to add two filesystem views - which might be useful to connect to test/production server.


All features can be found in master branch and will not be in the recently released KDevelop 4.4. But 4.5 will follow early next year...