Kate SQL Plugin 0.1

This is a plugin that transform Kate into a simple, light, versatile and useful SQL client.<br />It take the advantages of the Qt Sql module to allow you to open connections with all supported SQL drivers (MySQL, PostgreSQL, SQLite, ODBC, etc...) and easily launch queries on database. Some of the main features:<br />- supports all Qt Sql drivers<br />- manage multiple connections simultaneously<br />- provides an integrated viewer for SELECT statements<br />- a simple wizard to export query results in csv file<br />- provides a basic schema browser for views and tables<br /><br />(Tested on Linux and Windows with MySQL, SQLite and ODBC drivers)<br /><br />Build instructions:<br />---------------------<br />If your distribution does not provide the kate development package with libkateinterfaces, you need to compile Kate from sources.<br />Please follow these steps from the official Kate wiki: http://gitorious.org/kate/pages/Building Kate .<br />Before launching cmake command, you need to extract KateSQLPlugin sources in kate/plugins/ folder, and modify the file kate/plugins/CMakeLists.txt adding this line at the end:<br />add_subdirectory( katesql )<br /><br />QtSql with development libraries is required.<br /><br />Note:<br />---------<br />If you can\'t see your preferred driver in the new connection wizard, you need to install the appropriate qt driver package and restart kate. (eg. on debian: libqt4-sql-mysql, libqt4-sql-odbc ... )<br /><br />When you press the Run Query button, all selected text (or all text in the current document if none selected) is executed in an sql query. Pay attention! DELETE and DROP statements are tremendously rapid and destructive.<br /><br />There are a lot of features planned for future releases, like parameters recognition, support for multiple queries, configurable fonts and colors for outputs.<br /><br />If you have questions or you need to report a bug, please leave a comment or send me an email to marcomentasti@gmail.com<br />Any suggestions are appreciated.

Requirements:	No special requirements
Platforms:	*nix, Linux
Keyword:	Connections,  Current,  Development,  Driver,  Drivers,  Endadd Subdirectory,  Features,  Kate,  Kate Sql,  Kate Sql Plugin,  Katesql,  Libqt Sqlodbc,  Multiple,  Mysql,  Package,  Plugin,  Queries,  Query,  Selected,  Simple,  Sql,  Sql Plugin,  Sqlite,  Statements,  Wizard
Users rating:	0/10