Project Shaphan Updated

This page has moved.  Please update your links:
http://psst0101.digitaleagle.net/2010/11/27/project-shaphan-updated/

I just finished releasing a new version of my Project Shaphan to the Google Code site.  My goal with the project is to create a database query tool.  Oracle has SQL Developer which is a great, but it is geared more for database development.  Most PeopleSoft database users will never see a line of plsql or a single stored procedure.  What we need is a tool that understands PeopleSoft databases more and offers tools for querying it.

New Feature: Navigation Search

It isn’t very pretty, but here is a tool where you can enter a Component Name, and the tool will display all of the navigations for that component:

Selection_598

 

Meta SQL

I only have %CurrentDateIn working right now, but I plan to get more:

Selection_599

Getting Your Copy

To try it out, you can download the Jar file from the right side of the main page.  Make sure you have Java 6 installed.  Then, place the Jar file in a directory by itself, and double click on it.

Selection_600

About these ads

2 Responses to “Project Shaphan Updated”

  1. greg Says:

    Interesting idea, but why create your own query tool instead of making this a SQL Developer plug-in? Many companies/organizations limit what software can be used by their developers; they are much more likely to use SQL Developer then an unknown query tool.

  2. digitaleagle Says:

    Greg,

    Thanks for the thought.

    I just searched through my blog and found this post when I was thinking it through:
    http://psst0101.wordpress.com/2009/01/12/query-tool-that-includes-meta-sql/

    I think my biggest thing was trying to find information on how to write an extension. I didn’t see anything back then. I think I was looking for “plugin” rather than “extension”. I just searched for extension, and I found this:
    http://sueharper.blogspot.com/2006/05/write-your-own-extension-to-sql.html

    That link is pretty old, and all of the links that looked like they would help were broken.

    On top of that, I decided that it might be nice to try to create a different type of interface. All of the other tools seem geared toward creating one big script where you can run it all at once. Then, they add a feature to run only what you highlight or detect a single statement. I chose to create a separate text box for each statement. So far, my interface isn’t anything special though — maybe one day.

    Regarding companies limiting software, do those companies also limit the extensions or plugins installed? For example, if they allow Firefox, can you install any extension into that you want? Just curious. I guess I am hoping that my tool would be good enough that the company would put it on the allow list. The price is right at least :) Besides, I am creating it mainly as a tool for myself.

    Thanks,

    Stephen


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: