Login | Register
My pages Projects Community openCollabNet

simplesql
Project home

If you were registered and logged in, you could join this project.

Summary A session based SQL plugin for jEdit.
Category construction
License GNU General Public License
Owner(s) townsfolk

Goals

  • To create a new jEdit plugin that provides features and functionality the current SQL plugin does not.
  • To use a session based model, allowing for the use of some basic JDBC features such as commit and rollback.
  • To provide a free open-source tool for accessing databases

Features

  • Execution selected text (SQL) or the entire jEdit buffer.
  • A "Report" pane that shows error messages, as well as information regarding executing queries.
  • A "Result" pane that shows the result set of a query.
  • A toolbar that will allow the user to switch between databases and provide quick buttons to important functionality.
  • An option pane to allow users to create new database connections as well as new DataSource definitions.
  • A BeanShell variable for better BeanShell integration.
  • A free open-source Java database (Axion).
  • I hope to also build in a "Navigator" pane that will allow users to navigate a database, providing an interface to view schemas, tables and column info.

Scope

Initially, this project will be developed as a plugin to jEdit, but with the intention of being a standalone application as well.

Coding will be done from a standalone standpoint, but will use jEdit as it's UI.

Related resources

  • jEdit A programmers text editor
  • Axion The Open Source Java Database