Warning: session_start(): open(/tmp/sess_hmcg0u36o9lre2i9ctaludtee2, O_RDWR) failed: No space left on device (28) in /www/H01/htdocs/lib/base/lib_base.php on line 280
Kate SQL Plugin openDesktop.org


	KDE-Apps.org Applications for the KDE-Desktop GTK-Apps.org Applications using the GTK Toolkit GnomeFiles.org Applications for GNOME MeeGo-Central.org Applications for MeeGo CLI-Apps.org Command Line Applications Qt-Apps.org Free Qt Applications Qt-Prop.org Proprietary Qt Applications Maemo-Apps.org Applications for the Maemo Plattform Java-Apps.org Free Java Applications eyeOS-Apps.org Free eyeOS Applications Wine-Apps.org Wine Applications Server-Apps.org Server Applications apps.ownCloud.com ownCloud Applications


	KDE-Look.org Artwork for the KDE-Desktop GNOME-Look.org Artwork for the GNOME-Desktop Xfce-Look.org Artwork for the Xfce-Desktop Box-Look.org Artwork for your Windowmanager E17-Stuff.org Artwork for Enlightenment Beryl-Themes.org Artwork for the Beryl Windowmanager Compiz-Themes.org Artwork for the Compiz Windowmanager EDE-Look.org Themes for your EDE Desktop


	Debian-Art.org Stuff for Debian Gentoo-Art.org Artwork for Gentoo Linux SUSE-Art.org Artwork for openSUSE Ubuntu-Art.org Artwork for Ubuntu Kubuntu-Art.org Artwork for Kubuntu LinuxMint-Art.org Artwork for Linux Mint Arch-Stuff.org Art And Stuff for Arch Linux Frugalware-Art.org Themes for Frugalware Fedora-Art.org Artwork for Fedora Linux Mandriva-Art.org Artwork for Mandriva Linux


	KDE-Files.org Files for KDE Applications OpenTemplate.org Documents for OpenOffice.org GIMPStuff.org Files for GIMP InkscapeStuff.org Files for Inkscape ScribusStuff.org Files for Scribus BlenderStuff.org Textures and Objects for Blender VLC-Addons.org Themes and Extensions for VLC


	KDE-Help.org Support for your KDE Desktop GNOME-Help.org Support for your GNOME Desktop Xfce-Help.org Support for your Xfce Desktop

openDesktop.org: Applications Artwork Linux Distributions Documents Linux42.org OpenSkillz.com

Kate SQL Plugin

0.2

KDE Text Editor

Score 81%

MMentos
Home

Downloads: 670

Submitted: Jun 29 2010
Updated: Jul 22 2010

Description:

This is a plugin that transform Kate into a simple, light, versatile and useful SQL client.
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:
- supports all Qt Sql drivers
- manage multiple connections simultaneously
- provides an integrated viewer for SELECT statements
- a simple wizard to export query results in csv file
- provides a basic schema browser for views, tables and fields with primary keys

(Tested on Linux and Windows with MySQL, SQLite and ODBC drivers)

Important:
KateSQL was moved to svn.kde.org , under /trunk/KDE/kdesdk/kate/plugins/katesql/ , and to kate git repository hosted on gitorious.org

Therefore, KateSQL is available on the latest KDE trunk.

Build instructions:
---------------------
If your distribution does not provide the kate development package with libkateinterfaces, you need to compile Kate from sources.
Please follow these steps from the official Kate wiki: http://gitorious.org/kate/pages/Building Kate .

QtSql with development libraries is required.

Note:
---------
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 ... )

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.

There are a lot of features planned for future releases, like parameters recognition, support for multiple queries, configurable fonts and colors for outputs.

If you have questions or you need to report a bug, please send an email to marcomentasti@gmail.com or report to bugs.kde.org.

Any suggestions are appreciated.

Changelog:

0.2 - 22/07/2010
- table fields added to schema browser
- configuration parameters to change output colors
- save/restore last used connection
- improved performance exporting data
- fixed bugs
0.1 - 05/07/2010
- select results are now displayed with default system font.
- fixed incorrect export behavior.
- added possibility to export column names and line numbers.
- added context menu to data output, to quickly export/copy selected cells.

0.1-RC1 - 29/06/2010
- preview release

License: LGPL

Source

(katesql-0.2-sources)

Send to a friend
Subscribe
Other Content from MMentos
Report inappropriate content

I like it :)

by locke87 on: Jun 29 2010

Score 50%

locke87

I really like your effort. That's really improving my workflow when I don't have to login on a remote phpmyadmin :)

Reply to this

thank you!

by freinhard on: Jun 29 2010

Score 50%

freinhard

Thank you so much for that plugin! Built and works!

Reply to this

Great

by rADOn on: Jun 29 2010

Score 50%

rADOn

I have been waiting for this for a looong time. Thank you.

Reply to this

nice!

by milianw on: Jun 29 2010

Score 50%

milianw
KDevelop / Kate
Home

hey, really cool :)

if you polish it more, you can get this upstream into kdelibs, so that it can be pushed to the masses with 4.6.

Contact us developers at kwrite-devel@kde.org and/or #kate on freenode IRC.

Hope to hear from you, bye

Reply to this

very nice

by BastianBalthazarreBux on: Jun 29 2010

Score 50%

BastianBalth azarreBux

It's a really nice start, it would be even greater with the following:

resizeable panel for SQL Output

Using the same font as the window, may be with possibility to select a different one

support for multiple query with one selection

parameters in query for example like python %(param)s. When the query is executed the parameter will be asked with a dialog.

Reply to this

Re: very nice

by MMentos on: Jun 29 2010

Score 50%

MMentos
Home

Hi Bastian,
- what do you mean with "resizable panel"? all kate panels are resizable by default (the splitter is between the statusbar and the panel).

- ok, i will restore the the normal font by default. the possibility to configure fonts and colors for blobs and nulls is already planned for the next release

- multiple query support is provided internally by the sql driver. mysql supports multiple queries putting a ; after each query, odbc not. But i can try emulate this behavior parsing text with a regexp, and detect queries manually. Good idea?

- yesss, i already have this idea. also, with a possibility to enter parameters manually or from an input file (for multiple insert statements, for example).

Really thanks for your suggestions!

Reply to this

Re: Re: very nice

by BastianBalthazarreBux on: Jun 30 2010

Score 50%

BastianBalth azarreBux

Hi Bastian,
- "resizable panel"? <<< My Bad :p

- ok, i will restore the the normal font by default. the possibility to configure fonts and colors for blobs and nulls is already planned for the next release <<< yay

- multiple query support is provided internally by the sql driver. mysql supports multiple queries putting a ; after each query, odbc not. But i can try emulate this behavior parsing text with a regexp, and detect queries manually. Good idea?
<<< Actually you will need to parse anyway to grab the parameters right? then it could be a good idea, otherwise the complexity added is not worth it. For example phpMyAdmin botch it some times and it's a mature project.
Actually I've tried with a QMYSQL connection, it give me the error:

30 Jun 2010 09:59:59: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM tab_users' at line 2 QMYSQL3: Unable to prepare statement

with this text selected:
UPDATE tab_users set id = 1231231231 where id = 1231231231;
SELECT * FROM tab_users;

One strange thing is that the class who give the error is QMYSQL3 when I've used a QMYSQL connection, maybe it's only inherited or maybe it's a bug

- yesss, i already have this idea. also, with a possibility to enter parameters manually or from an input file (for multiple insert statements, for example). <<< yay

Really thanks for your suggestions!
... and to you for this plugin

Reply to this

still alive?

by otzy007 on: Apr 17 2011

Score 50%

otzy007
Home

What happend to the plugin? Is it still developed? It seems that it doesn't exist anymore on the kde anonsvn

Reply to this

Re: still alive?

by MMentos on: Apr 17 2011

Score 50%

MMentos
Home

Yes, this plugin is alive, and must be included in KDE >= 4.6.0.
Or you can find latest sources in kate repository hosted on git.kde.org (https://projects.kde.org/projects/kde/kdebase/kate/repository/revisions/master/show/kate/plugins/katesql).
Follow this guide to get more information on how to build kde from sources (http://kate-editor.org/get-it/).
Thanks for your interest

Add commentBack

Desktop Screenshots

Newest Groups

Elementary OS

Nahuatl language

FORUM

Who we are
Contact
More about us
Frequently Asked Questions
Register
Twitter
Blog

Explore
Apps
Artwork
Jobs
Knowledge
Events
People
Updates on identi.ca
Updates on Twitter
Content RSS
Events RSS

Participate
Groups
Forum
Add Content
Public API

About openDesktop.org
Legal Notice
Spreadshirt Shop
CafePress Shop
Advertising
Sponsor us
Report Abuse

Copyright 2007-2016 openDesktop.org Team
All rights reserved. openDesktop.org is not liable for any content or goods on this site.
All contributors are responsible for the lawfulness of their uploads.
openDesktop is a trademark of the openDesktop.org Team

All

Office

Multimedia

Graphic

Network

Printing

Text Editors

Education

Business

Telephony

Games

Development

Administration

Scientific

Security

Utilities

PDA Software

Server Software

Accessibility

Embedded

Libraries

Other Software

Documents

Social Desktop Contest

Kate SQL Plugin